Method: rowAccessPolicies.list

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

string

Required. Project ID of the row access policies to list.

datasetId

string

Required. Dataset ID of row access policies to list.

tableId

string

Required. Table ID of the table to list row access policies.

Query parameters

Parameters
pageToken

string

Page token, returned by a previous call, to request the next page of results.

pageSize

integer

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 (RowAccessPolicy)
    }
  ],
  "nextPageToken": string
}
Fields
rowAccessPolicies[]

object (RowAccessPolicy)

Row access policies on the requested table.

nextPageToken

string

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 (RowAccessPolicyReference)
  },
  "filterPredicate": string,
  "creationTime": string,
  "lastModifiedTime": string
}
Fields
etag

string

Output only. A hash of this resource.

rowAccessPolicyReference

object (RowAccessPolicyReference)

Required. Reference describing the ID of this row access policy.

filterPredicate

string

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

string (Timestamp format)

Output only. The time when this row access policy was created, in milliseconds since the epoch.

lastModifiedTime

string (Timestamp format)

Output only. The time when this row access policy was last modified, in milliseconds since the epoch.