I am unable to load data in Metabase, that is stored in a google sheet in Big Query. I can run and display the query in Big Query but in Metabase I keep getting the error message “question took too long”. The Metabase logs state “WARN metabase.query-processor :: Query failure: Read timed out”
The table actually contains only a little amount of data, and I cannot figure out why it cannot be displayed in Metabase.
Ive had a similar issues when filtering by date range - metabase sends a SQL cast query which bigquery struggles with. I havent fixed it but think the solution is to store dates as type: DATE inbig query to avoid the cast.