Reference documentation and code samples for the Cloud Dataplex v1 API class DataQualityRule.Types.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 BigQuery standard SQL 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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-03-25 UTC."],[[["The `DataQualityRule.Types.SqlAssertion` class in the Cloud Dataplex v1 API is used to define SQL-based data quality rules, which checks data validity by returning rows that match an invalid state."],["The latest version of the `DataQualityRule.Types.SqlAssertion` class is 3.6.0, with numerous previous versions dating back to 1.0.0."],["This class implements several interfaces including `IMessage`, `IEquatable`, `IDeepCloneable`, and `IBufferMessage` and inherits from `object`."],["The `SqlAssertion` class has a `SqlStatement` property that allows the user to set the SQL statement for data validation using BigQuery standard SQL syntax."],["The SQL statement defined in the `SqlAssertion` class can use the `${data()}` reference parameter to interact with the source table, including any previously defined filters, and should not include any semicolons."]]],[]]