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"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["\u003cp\u003eThe \u003ccode\u003eDataQualityRule.Types.SqlAssertion\u003c/code\u003e 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.\u003c/p\u003e\n"],["\u003cp\u003eThe latest version of the \u003ccode\u003eDataQualityRule.Types.SqlAssertion\u003c/code\u003e class is 3.6.0, with numerous previous versions dating back to 1.0.0.\u003c/p\u003e\n"],["\u003cp\u003eThis class implements several interfaces including \u003ccode\u003eIMessage\u003c/code\u003e, \u003ccode\u003eIEquatable\u003c/code\u003e, \u003ccode\u003eIDeepCloneable\u003c/code\u003e, and \u003ccode\u003eIBufferMessage\u003c/code\u003e and inherits from \u003ccode\u003eobject\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eSqlAssertion\u003c/code\u003e class has a \u003ccode\u003eSqlStatement\u003c/code\u003e property that allows the user to set the SQL statement for data validation using BigQuery standard SQL syntax.\u003c/p\u003e\n"],["\u003cp\u003eThe SQL statement defined in the \u003ccode\u003eSqlAssertion\u003c/code\u003e class can use the \u003ccode\u003e${data()}\u003c/code\u003e reference parameter to interact with the source table, including any previously defined filters, and should not include any semicolons.\u003c/p\u003e\n"]]],[],null,[]]
