CODEWITHSUNDEEP
google-bigquerylooker-studio
dbeings
dbeings

Reputation: 85

Bigquery and Google Data Studio - 1 min refresh

I have a google data studio dashboard where I switched data source from Google Sheets to BigQuery as BigQuery provided option of 1 minute data refresh. But when I started using BigQuery the data refresh speed was even slower than sheets - The sheets data got updated automatically after 15 mins but BigQuery data didnt get updated even after an hours.

I have set data refresh interval to 1 min for BigQuery data source but that does not appear to be working. I suspect this could be something related to data caching by BigQuery BI engine but I dont see an option to disable that.

Any pointers on above issue and how can I achieve every minute update with GDS and bigquery?

TIA dbeings

Upvotes: 0

Views: 435

Answers (1)

ali izadi
ali izadi

Reputation: 549

You Can schedule your query in Bigquery Studio for your desired intervals and also use the Bigquery BI engine to reduce your costs.

Upvotes: 0

Related Questions