Export the visualization query results as parquet files to a Cloud Storage bucket using a Cloud Function instance, triggered every 4 hours by Cloud Scheduler. Reference these parquet files in the data visualization tool.

Create views for the visualization queries and reference these views in the data visualization tool.

Create materialized views for the visualization queries, utilizing BigQuery's incremental updates capability to automatically handle changed data. Reference these materialized views in the data visualization tool.

Create materialized views with the allow_non_incremental_definition option enabled for the visualization queries. Set the max_staleness parameter to 4 hours and the enable_refresh parameter to true. Reference these materialized views in the data visualization tool.