+++ This bug was initially created as a clone of Bug #1703615 +++ I am able to spin up the analysis environment for `rally-zero-one` but I cannot query the tables in the notebook environment. Running the following cell ``` %%bigquery select submission_timestamp, study_name, document_id from rally_zero_one.measurements_v1 where date(submission_timestamp) > date_sub(current_date, interval 30 day) limit 3 ``` yields the following error: ``` ERROR: 403 Access Denied: Table moz-fx-data-pioneer-prod:rally_zero_one_stable.measurements_v1: User does not have permission to query table moz-fx-data-pioneer-prod:rally_zero_one_stable.measurements_v1. (job ID: 66ff2bff-b52b-4497-8c7d-3d256c54fdca) -----Query Job SQL Follows----- | . | . | . | . | . | . | . | 1:select submission_timestamp, study_name, document_id 2:from rally_zero_one.measurements_v1 3:where date(submission_timestamp) > date_sub(current_date, interval 30 day) 4:limit 3 | . | . | . | . | . | . | . | ``` A call to `! gcloud auth list` yields the following: ``` Credentialed Accounts ACTIVE ACCOUNT * notebook-hulmer@moz-fx-data-rally-zero-one.iam.gserviceaccount.com To set the active account, run: $ gcloud config set account `ACCOUNT` ``` Please let me know if you need any other information on my end to diagnose.
Bug 1705754 Comment 0 Edit History
Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.
+++ This bug was initially created as a clone of Bug #1703615 +++ I am able to spin up the analysis environment for `rally-zero-one` but I cannot query the tables in the notebook environment. Running the following cell ``` %%bigquery select submission_timestamp, study_name, document_id from rally_zero_one.measurements_v1 where date(submission_timestamp) > date_sub(current_date, interval 30 day) limit 3 ``` yields the following error: ``` ERROR: 403 Access Denied: Table moz-fx-data-pioneer-prod:rally_zero_one_stable.measurements_v1: User does not have permission to query table moz-fx-data-pioneer-prod:rally_zero_one_stable.measurements_v1. (job ID: 66ff2bff-b52b-4497-8c7d-3d256c54fdca) -----Query Job SQL Follows----- | . | . | . | . | . | . | . | 1:select submission_timestamp, study_name, document_id 2:from rally_zero_one.measurements_v1 3:where date(submission_timestamp) > date_sub(current_date, interval 30 day) 4:limit 3 | . | . | . | . | . | . | . | ``` A call to `! gcloud auth list` yields the following: ``` Credentialed Accounts ACTIVE ACCOUNT * notebook-hulmer@moz-fx-data-rally-zero-one.iam.gserviceaccount.com To set the active account, run: $ gcloud config set account `ACCOUNT` ``` Please let me know if you need any other information on my end to diagnose or if there is something obviously wrong with what I've done.