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 page provides documentation for the \u003ccode\u003eDataQualityRule.Types.SqlAssertion\u003c/code\u003e class within the Google Cloud Dataplex V1 API.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eSqlAssertion\u003c/code\u003e class is used to define SQL statements that identify invalid data rows within a data quality rule, returning those rows to signify that the rule has failed.\u003c/p\u003e\n"],["\u003cp\u003eThis class is implemented using various interfaces such as \u003ccode\u003eIMessage\u003c/code\u003e, \u003ccode\u003eIEquatable\u003c/code\u003e, \u003ccode\u003eIDeepCloneable\u003c/code\u003e, and \u003ccode\u003eIBufferMessage\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe documentation outlines the availability of multiple versions of this class, from version 1.0.0 up to the latest, 3.6.0, with a focus on version 3.5.0.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eSqlAssertion\u003c/code\u003e class can be constructed with default values, or given another object of its type, it contains one property, \u003ccode\u003eSqlStatement\u003c/code\u003e, which holds the SQL assertion to be executed.\u003c/p\u003e\n"]]],[],null,[]]
