1708011 - Access Denied: Table moz-fx-data-pioneer- prod:rally_debug_live.enrollment_v1

Status: RESOLVED FIXED

(Firefox :: Pioneer, defect)

Description

[Alessio Placitelli [:Dexter]]

I was doing a live debug session with Anthony to check that pings generated from the Rally Core-Addon, via glean.js, are correctly being received. To do this, I was accessing the live tables from the bq command line on the remote instance. However, running the following command, resulted in a error:

bq query --use_legacy_sql=false 'select count(*) from rally_debug.
enrollment_v1_live where date(submission_timestamp) > "2021-04-01"'
BigQuery error in query operation: Error processing job 'moz-fx-data-rally-
debug:bqjob_r6ccdf9a996ec1f0d_0000017914dc535b_1': Access Denied: Table moz-fx-data-pioneer-
prod:rally_debug_live.enrollment_v1: User does not have permission to query table moz-fx-data-pioneer-
prod:rally_debug_live.enrollment_v1.

As recommended by Anthony, I run the following diagnostics:

ext_aplacitelli_mozilla_com@python-20210427-203556:~$ gcloud auth list
Credentialed Accounts
ACTIVE ACCOUNT

•   [e-mail]
  

Comment 1

[Alessio Placitelli [:Dexter]]

Other folks that were added in bug 1698913 might be affected too :(

Comment 2

[Wesley Dawson [:whd]]

https://bugzilla.mozilla.org/show_bug.cgi?id=1705754#c1

As I've forgotten the extra authorization step twice now I'll look into automating the loop between table creation and authorization.