1705754 - 403 access denied error when running queries on tables in rally-zero-one in analysis environment

Status: RESOLVED FIXED

(Firefox :: Pioneer, task)

Description

[Hamilton]

+++ 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
*       [e-mail]
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.

Comment 1

[Wesley Dawson [:whd]]

I forgot steps 6-7 of https://mana.mozilla.org/wiki/pages/viewpage.action?spaceKey=DOPS&title=Pioneer#Pioneer-Addinganewstudy that authorize access to the views from the study environment. This should be fixed.