Hi Not sure if this is the right channel for the question bu

Question

Hi Not sure if this is the right channel for the question but what permissions does the BigQuery service account need to be used as a data source

future-teacher-7046 · Answer

Hi GrowthBook needs the same permissions as other BI tools That should be the Data Viewer Metadata Viewer and Job User roles

witty-laptop-42616 · Answer

Yeah thought so Was hoping maybe there s something that s not project level

future-teacher-7046 · Answer

I m not too familiar with BigQuery permissions but I thought you need a project level permission in order to run any queries We only query the exact tables you tell us to so it will probably work with more restrictive read access than some other things like Metabase

witty-laptop-42616 · Answer

Yeah true all tools I can think of require project level access because for some reason BQ doesn t have permissions with dataset table level query capabilities This has been a problem with some clients who can t share any keys that have full access to all of their data The solution has been to create a separate project for that purpose but there should be an easier solution to this

witty-laptop-42616 · Answer

well looks like this could actually work for our use case <https stackoverflow com a 58564834 4769218>

witty-laptop-42616 · Answer

I got the first experiment running but in the results section I get this error Before I debug any further maybe this is a known error or can someone provide a quick fix ```No matching signature for operator gt = for argument types TIMESTAMP DATETIME Supported signature ANY gt = ANY at 27 9 ```

fresh-football-47124 · Answer

do you see the full query that it s trying does the view queries link work

fresh-football-47124 · Answer

sounds like that comparison operator that is expecting the same types on both sides but one is a timestamp the other is a datetime so it doesn t know how to compare them

future-teacher-7046 · Answer

Yes you need to cast your date columns to DATETIME in your queries

witty-laptop-42616 · Answer

thanks the solution that worked for me was to use `DATETIME timestamp AS timestamp` in the source queries

fresh-football-47124 · Answer

+1