November 9, 2024

Parenting lobby

Make Every Parenting lobby Count

Google BigQuery Permissions Issue stopping scheduled queries from running

We had a data intern who scheduled a lot of queries to power our google data studio reports. After she left, we removed her access, and now the queries don’t run. This is the error we see:

BigQuery error: Access Denied: Table pm-match-mobile:analytics_232872718.DAU_WAU_MAU: Permission bigquery.tables.get denied on table pm-match-mobile:analytics_232872718.DAU_WAU_MAU (or it may not exist).

Is there a way to transfer access or ownership of those queries to a different email/account so that we don’t have to do everything from scratch as it will cost us a ton of time? Thanks so much for helping.