Google Cloud Dataplex V1 Client - Class SqlAssertion (0.16.1)

Version 0.16.1

• 1.1.0 (latest)
• 1.0.1
• 0.16.1
• 0.15.1
• 0.14.0
• 0.13.0
• 0.12.0
• 0.11.1
• 0.10.0
• 0.9.0
• 0.8.0
• 0.7.0
• 0.6.0
• 0.5.1
• 0.4.0
• 0.3.0
• 0.2.3
• 0.1.6

Reference documentation and code samples for the Google Cloud Dataplex V1 Client class SqlAssertion.

Queries for rows returned by the provided SQL statement. If any rows are are returned, this rule fails.

The SQL statement needs to use BigQuery standard SQL syntax, and must not contain any semicolons. ${data()} can be used to reference the rows being evaluated, i.e. the table after all additional filters (row filters, incremental data filters, sampling) are applied. Example: SELECT * FROM ${data()} WHERE price < 0

Generated from protobuf message google.cloud.dataplex.v1.DataQualityRule.SqlAssertion

Namespace

Google \ Cloud \ Dataplex \ V1 \ DataQualityRule

Methods

__construct

Constructor.

Parameters
Name	Description
data	array Optional. Data for populating the Message object.
↳ sql_statement	string Optional. The SQL statement.

getSqlStatement

Optional. The SQL statement.

Returns
Type	Description
string

setSqlStatement

Optional. The SQL statement.

Parameter
Name	Description
var	string

Returns
Type	Description
$this