Unable to run queries with Google Cloud SDK

[Dhruthick Mohan]

Hi everyone,

I'm trying to run a script that access measurements-lab project on BigQuery and runs queries. However, I keep getting the following error, that says I don't have the required permission to use the measurement-lab project.

googleapi: Error 403: Caller does not have required permission to use project measurement-lab. Grant the caller the roles/serviceusage.serviceUsageConsumer role, or a custom role with the serviceusage.services.use permission, by visiting https://console.developers.google.com/iam-admin/iam/project?project=measurement-lab and then retry. Propagation of the new permission may take a few minutes.

Details:

[

  {

    "@type": "type.googleapis.com/google.rpc.Help",

    "links": [

      {

        "description": "Google developer console IAM admin",

        "url": "https://console.developers.google.com/iam-admin/iam/project?project=measurement-lab"

      }

    ]

  },

  {

    "@type": "type.googleapis.com/google.rpc.ErrorInfo",

    "domain": "googleapis.com",

    "metadata": {

      "consumer": "projects/measurement-lab",

      "service": "bigquery.googleapis.com"

    },

    "reason": "USER_PROJECT_DENIED"

  }

]

, forbidden

exit status 1

I've made sure I am trying to access the project through the same account as the one that is subscribed to this group. Does anyone have any suggestions or ideas on how I can resolve this issue?

Best,

Dhruthick

[Lai Yi Ohlsen]

Hi Dhruthick, 

To query the data programmatically you can create a service account: https://cloud.google.com/iam/docs/service-accounts-create. 

Once you create the account, reach out to sup...@measurementlab.net and we can approve permissions for the account. 

Best, 

--
You received this message because you are subscribed to the Google Groups "discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to discuss+u...@measurementlab.net.
To view this discussion on the web visit https://groups.google.com/a/measurementlab.net/d/msgid/discuss/b0409241-49ef-49b9-8814-81ea0f8f8298n%40measurementlab.net.

--

Lai Yi Ohlsen

Research and Data Lead

Measurement Lab

Code for Science & Society

[Nathan Kinkade]

Hi Dhruthick,

You should be able to use the Google Cloud SDK BigQuery client to access the M-Lab data using your Google account email address dgm...@ucsd.edu. I verified that it is indeed subscribed to the discuss@ group. Have you already done all the steps outlined here?

https://www.measurementlab.net/data/docs/bq/quickstart/#setup-access-to-m-lab-datasets-in-the-google-cloud-sdk

If so, and something is still not working, can you let me know exactly how you are trying to access the data?

Best,

Nathan

To view this discussion on the web visit https://groups.google.com/a/measurementlab.net/d/msgid/discuss/CAD3WrcO-_VtSqdO2x6ndrmPnPuYDv0s7TqWRH96kik%3DDm9W23g%40mail.gmail.com.