The solution is to use SQL views, materialized views, or create a new table that contains only the filtered data the user needs.

A materialized view may be schema-qualified; if you specify a schema name when invoking the CREATE MATERIALIZED VIEW command, the view will be created in the specified schema. The view name must be ...

Contribute to mr-taha-saqib/Database-Views---Simple-and-Materialized-Views development by creating an account on GitHub.

That AWS ETL service allows programmers to write a little bit of SQL code to have a materialized view that can move from one source data store to another.