google-cloud-platformgoogle-bigquerygoogle-cloud-iamrow-level-security

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 acccess 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?

Solution

  • You must use TRUE filter on your row filtering definition.