Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Bigquery tables get data API returning Access Denied

Not able to get the BQ get table data API work with row level policies.

Trying to make a HTTP API call to:

https://bigquery.googleapis.com/bigquery/v2/projects/<project-name>/datasets/<dataset-name>/tables/<table-name>/data

I have authenticated using a OAuth2 access token.

I am getting error: 

Access Denied: Table <table-name>: User does not have full access for table <table-name> due to row access policies

Row level security policy have been defined for my user on the table. How can I make the above API call work with row level security?

 

0 3 2,527
3 REPLIES 3