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

This project aims to bring the use of triggers, materialized views, and functions to a Business Intelligence process, where this data could be used to populate a dashboard in Power BI or Streamlit, ...

Incrementally maintains the results of SQL queries as materialized views, in-memory or on cloud storage, providing millisecond-level latency on complex transformations, joins, or aggregations.

Use the DROP MATERIALIZED VIEW command to remove a materialized view from the database. Before you can remove a materialzied view, you must remove all its dependent materialzied views.