- HTTP request
- Path parameters
- Query parameters
- Request body
- Response body
- Authorization scopes
- RowAccessPolicy
- Try it!
Lists all row access policies on the specified table.
HTTP request
GET https://bigquery.googleapis.com/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/rowAccessPolicies
The URL uses gRPC Transcoding syntax.
Path parameters
Parameters | |
---|---|
projectId |
Required. Project ID of the row access policies to list. |
datasetId |
Required. Dataset ID of row access policies to list. |
tableId |
Required. Table ID of the table to list row access policies. |
Query parameters
Parameters | |
---|---|
pageToken |
Page token, returned by a previous call, to request the next page of results. |
pageSize |
The maximum number of results to return in a single response page. Leverage the page tokens to iterate through the entire collection. |
Request body
The request body must be empty.
Response body
Response message for the rowAccessPolicies.list method.
If successful, the response body contains data with the following structure:
JSON representation |
---|
{
"rowAccessPolicies": [
{
object ( |
Fields | |
---|---|
rowAccessPolicies[] |
Row access policies on the requested table. |
nextPageToken |
A token to request the next page of results. |
Authorization scopes
Requires one of the following OAuth scopes:
https://www.googleapis.com/auth/bigquery
https://www.googleapis.com/auth/cloud-platform
https://www.googleapis.com/auth/bigquery.readonly
https://www.googleapis.com/auth/cloud-platform.read-only
For more information, see the Authentication Overview.
RowAccessPolicy
Represents access on a subset of rows on the specified table, defined by its filter predicate. Access to the subset of rows is controlled by its IAM policy.
JSON representation |
---|
{
"etag": string,
"rowAccessPolicyReference": {
object ( |
Fields | |
---|---|
etag |
Output only. A hash of this resource. |
rowAccessPolicyReference |
Required. Reference describing the ID of this row access policy. |
filterPredicate |
Required. A SQL boolean expression that represents the rows defined by this row access policy, similar to the boolean expression in a WHERE clause of a SELECT query on a table. References to other tables, routines, and temporary functions are not supported. Examples: region="EU" date_field = CAST('2019-9-27' as DATE) nullable_field is not NULL numeric_field BETWEEN 1.0 AND 5.0 |
creationTime |
Output only. The time when this row access policy was created, in milliseconds since the epoch. |
lastModifiedTime |
Output only. The time when this row access policy was last modified, in milliseconds since the epoch. |