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. |