I am trying to retrieve DDL objects from BigQuery but encountered a failure on line 18 with the code ddl_set = query_job.result(). I’ve assigned the necessary roles listed below to the service account. BigQuery Admin BigQuery Data Editor BigQuery Data Owner BigQuery Data Viewer BigQuery Job User B…

What happens if you run the failing SQL statement in the BigQuery studio console? Can we parse the puzzle down to the exact statement that is failing and what it looks like? Maybe try run it using the “bq” command using the credentials file. Let’s remove some of the unknowns like the Python code.

Hi @dr41 , Welcome and thank you for reaching out to our community. I get that you are having challenges accessing your INFORMATION_SCHEMA and as the error message suggests, you may need to look into the specific permissions (aside from the roles ) and location needed to access INFORMATION_SCHEMA. …

Access denied while retrieving DDL tables from BigQuery

Google Cloud Data Analytics

dr41 March 12, 2024, 5:43am 4

@kolban The code is running without an issue after removing the “bq” command in line 14.

Topic		Replies	Views
BQ Admin but cannot access INFORMATION_SCHEMA.TABLES Data Analytics bigquery	3	708	August 6, 2024
Querying INFORMATION_SCHEMA.TABLE_STORAGE in BigQuery gives an access denied error Data Analytics bigquery	4	639	January 12, 2024
Unable to Execute INFORMATION_SCHEMA.TABLE_STORAGE Query Data Analytics bigquery	3	252	November 21, 2024

Access denied while retrieving DDL tables from BigQuery

AI Suggested topics