CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquerymetadata
CRISTIAN ERNESTO TORO LOPEZ
CRISTIAN ERNESTO TORO LOPEZ

Reputation: 41

How to view the bigquery jobs metadata correctly? INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION

i'd like to use INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION in bigquery to search and find the jobs between projects which are pointing to specific tables.

I did it with my own project using INFORMATION_SCHEMA.JOBS_BY_PROJECT but i can't see the ORGANIZATION'S one to ask between projects.

"Access Denied: Table bc-te-dlake-dev-s7b3:region-us.INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION: User does not have permission to query table bc-te-dlake-dev-s7b3:region-us.INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION."

I have the "organization administrator" rol in my project.

Upvotes: 4

Views: 11887

Answers (2)

NK5
NK5

Reputation: 93

Along with the correct permissions, make sure you have the project and region in your query e.g.

SELECT * FROM `myproject`.`region-eu`.INFORMATION_SCHEMA.JOBS_BY_USER;

Upvotes: 9

Daniel Zagales
Daniel Zagales

Reputation: 3032

https://cloud.google.com/bigquery/docs/information-schema-jobs#required_permissions

JOBS_BY_ORGANIZATION requires bigquery.jobs.listAll for the organization and is available to the Organization bigquery.resourceAdmin, Organization Owner and Organization Admin roles. Note that JOBS_BY_ORGANIZATION is only available to users with defined Google Cloud organizations.

Verify you have all the required roles at the org as defined in the above docs

Upvotes: 1

Related Questions