GoogleCloudPlatform / GoogleCloudPlatform/training-data-analyst

BQ Information Schema Query Failing due to Permissions

Open
#768 0 comments 2 reactions 0 assignees View on GitHub
Dominant language
Jupyter Notebook
Stars
8.6k
Forks
6.1k
Avg merge
4h 44m
Merged PRs (30d)
2

Description

Hi Evan!
The bigquery-public-data project does not seem to allow querying INFORMATION SCHEMA DATA. Everytime we try and run the query from:

training-data-analyst/quests/bq-optimize/demos/code/information_schema.sql

An error keep showing up:

Table bigquery-public-data:INFORMATION_SCHEMA.SCHEMATA: User does not have permission to query table bigquery-public-data:INFORMATION_SCHEMA.SCHEMATA.

Best

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.