Class SqlAssertion (2.9.0) 

SqlAssertion(mapping=None, *, ignore_unknown_fields=False, **kwargs)

A SQL statement that is evaluated to return rows that match an invalid state. If any rows are are returned, this rule fails.

The SQL statement must use GoogleSQL syntax <https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax>__, and must not contain any semicolons.

You can use the data reference parameter ${data()} to reference the source table with all of its precondition filters applied. Examples of precondition filters include row filters, incremental data filters, and sampling. For more information, see Data reference parameter <https://cloud.google.com/dataplex/docs/auto-data-quality-overview#data-reference-parameter>__.

Example: SELECT * FROM ${data()} WHERE price < 0

Attribute
Name Description
sql_statement str
Optional. The SQL statement.