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\u003eThis page provides reference documentation for the \u003ccode\u003eDataQualityRule.Types.SqlAssertion\u003c/code\u003e class within the Google Cloud Dataplex V1 API, specifically for .NET development.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eSqlAssertion\u003c/code\u003e class defines a SQL statement for data quality checks, where the rule fails if the query returns any rows, indicating invalid data states.\u003c/p\u003e\n"],["\u003cp\u003eThe SQL statement used with \u003ccode\u003eSqlAssertion\u003c/code\u003e must adhere to BigQuery standard SQL syntax, without semicolons, and can use the \u003ccode\u003e${data()}\u003c/code\u003e parameter to reference the source table.\u003c/p\u003e\n"],["\u003cp\u003eThis documentation details the class's inheritance, implemented interfaces, namespace, assembly, constructors, and the \u003ccode\u003eSqlStatement\u003c/code\u003e property.\u003c/p\u003e\n"],["\u003cp\u003eMultiple versions are available for the DataQualityRule class, starting from version 1.0.0 up to the most recent version, 3.6.0.\u003c/p\u003e\n"]]],[],null,[]]
