Service account used for Write to Big Query subscription

[slightlynachos]

Hello,

I am trying to create a new subscription from an existing topic that will write directly to a BQ table which I have created.

However when creating I get the following error message:

Cannot determine whether service account service-xxx has permission to write to the BigQuery table. Please check that the table exists and that permissions are configured.

This isn't a service account managed by me, so I don't know how to modify its permissions.

Is there a way to choose the service account that I want to use?

Best regards!

[c4talyst]

I also got stuck. This is how I unstuck myself. 

Read the docs here

But the problem is that you cannot see this service account (even after selecting "Include Google-provided role grants").

Solution:

* Visit https://console.cloud.google.com/iam-admin/iam 

* Choose your project

* Click "Add+" and enter the principal email

* Provide the Roles as required (double check docs)

* BigQuery Data Editor

* BigQuery Metadata Viewer

Success

[josegutierrez]

You could grant a role on the table such as roles/bigquery.dataEditor. You need to have the Service Account added to your project.

GRANT `ROLE_LIST`
ON TABLE DATASET.TABLE
TO 'USER_LIST';

See more on this document.