Error while creating a BigLake table

[vikramrathour]

I am trying to create a BigLake table and get the following error –

You are missing permissions and may need to talk to your administrator. Original error message: Failed to create table: Access Denied: Connection 383074778164.europe-west4.mibi-conn-biglake: User does not have bigquery.connections.delegate permission for connection 383074778164.europe-west4.mibi-conn-biglake.

Can you help?

I have granted following roles to the SA –

roles/storage.objectViewer

roles/bigquery.connectionAdmin

Thanks,

Vikram Rathour

[vikramrathour · Accepted solution]

This is solved. The solution is to grant "roles/bigquery.connectionAdmin" to the User group that has my account. I was doing it to the service account.