topic Re: User does not have bigquery.jobs.create permission in Qlik Replicate

User does not have bigquery.jobs.create permission

allann — Thu, 24 Mar 2022 13:19:21 GMT

New to Qlik. We're trying to create a task with Google BigQuery as the target endpoint. I believe all permissions are granted to the service account but this error is still shown. Only thing I can think of is permissions were edited after the key was made. Not sure if that matters.

Could something else cause this error?

Re: User does not have bigquery.jobs.create permission

SwathiPulagam — Thu, 24 Mar 2022 13:18:15 GMT

Hi @allann ,

What is your Replicate version?

Thanks,

Swathi

Re: User does not have bigquery.jobs.create permission

allann — Thu, 24 Mar 2022 13:21:39 GMT

May 2021 (2021.5.0.1186)

Re: User does not have bigquery.jobs.create permission

SwathiPulagam — Thu, 24 Mar 2022 13:32:05 GMT

Hi @allann ,

Does the user have the following permissions?

BigQuery > BigQuery Data Editor

BigQuery > BigQuery Job User

When you create a service account key, a JSON file containing the connection information will be downloaded to your computer. You will need to copy the contents of this file to the Service account key field in the Google Cloud BigQuery endpoint.

Thanks,

Swathi

Re: User does not have bigquery.jobs.create permission

allann — Thu, 24 Mar 2022 16:17:12 GMT

I had someone else check and there was one permission missing, the editor. That fixed the issue but now we're running in to a logging format issue on the source side.

Re: User does not have bigquery.jobs.create permission

SwathiPulagam — Thu, 24 Mar 2022 16:30:12 GMT

Hi @allann ,

Good to hear the current permission issue is resolved.

If source-related is a different issue I would suggest you to create a new post with detailed info.

Thanks,

Swathi