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?
I don't use scheduled queries, but the manual says that the credentials for scheduled queries can be changed by clicking in the console or via the API.