Reference documentation and code samples for the Google Cloud Dataplex V1 Client class SqlAssertion.
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
,
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
.
Example: SELECT * FROM ${data()} WHERE price < 0
Generated from protobuf message google.cloud.dataplex.v1.DataQualityRule.SqlAssertion
Namespace
Google \ Cloud \ Dataplex \ V1 \ DataQualityRuleMethods
__construct
Constructor.
data
array
Optional. Data for populating the Message object.
↳ sql_statement
string
Optional. The SQL statement.
getSqlStatement
Optional. The SQL statement.
string
setSqlStatement
Optional. The SQL statement.
var
string
$this
