row_access_policies

Creates, updates, deletes, gets or lists a row_access_policies resource.

Overview

Name	row_access_policies
Type	Resource
Id	google.bigquery.row_access_policies

Fields

Name	Datatype	Description
creationTime	string	Output only. The time when this row access policy was created, in milliseconds since the epoch.
etag	string	Output only. A hash of this resource.
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
lastModifiedTime	string	Output only. The time when this row access policy was last modified, in milliseconds since the epoch.
rowAccessPolicyReference	object	Id path of a row access policy.

Methods

Name	Accessible by	Required Params	Description
list	SELECT	+datasetId, +tableId, projectId	Lists all row access policies on the specified table.

SELECT examples

Lists all row access policies on the specified table.

SELECT
creationTime,
etag,
filterPredicate,
lastModifiedTime,
rowAccessPolicyReference
FROM google.bigquery.row_access_policies
WHERE +datasetId = '{{ +datasetId }}'
AND +tableId = '{{ +tableId }}'
AND projectId = '{{ projectId }}';