Is there a way to synch a DB which is connected to Metabase at a specific time period?

Get Help
1

I have connected Bigquery to Metabase, and each time a query is run it is getting live data from Bigquery which is driving up cost.I do not need real live data for some DB so I need to sync them once a day.

When a went around the documentation only the schema of the db and query caching is present.

Can anyone help me here? If this can be done can tell me the steps to do so please.

2

Create a model of the data you need.

Create your questions using the model. Cache the model with a daily refresh interval.

May not be cheaper though - depends upon how much data you’re sucking out of the database to create the model.