Hello! I'm mostly using Metabase for BigQuery data visualizations and I noticed, that my metabase service account costs about 20$ per day, despite all my datasets which connected to metabase as data sources are updated via Google Scheduled Queries and they upload data to the partitioned tables once a day to lower the queries costs.
What is the schema of queries costs in that particular way?
Thanks!
Hi @privettoha
I don't understand your question. Try looking in the Google Console to see what is causing the cost.
Metabase runs sync and scans hourly/daily, which you can change:
https://www.metabase.com/docs/latest/administration-guide/01-managing-databases.html#choose-when-metabase-syncs-and-scans
Do not set user hash on queries to avoid similar queries not being cached:
https://www.metabase.com/docs/latest/administration-guide/databases/bigquery.html#include-user-id-and-query-hash-in-queries
Besides that, then whatever queries you make in Metabase runs against your BigQuery unless you have enabled caching:
https://www.metabase.com/docs/latest/administration-guide/14-caching.html