Reference documentation and code samples for the Cloud Dataplex v1 API class DataQualityRule.Types.SqlAssertion.
Queries for rows returned by the provided SQL statement. If any rows are
are returned, this rule fails.
The SQL statement needs to use BigQuery standard SQL syntax, and must not
contain any semicolons.
${data()} can be used to reference the rows being evaluated, i.e. the table
after all additional filters (row filters, incremental data filters,
sampling) are applied.
[[["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 document provides reference documentation for the \u003ccode\u003eDataQualityRule.Types.SqlAssertion\u003c/code\u003e class within the Google Cloud Dataplex v1 API, specifically for .NET.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eSqlAssertion\u003c/code\u003e class allows defining a SQL statement that, if it returns any rows, indicates a failure of the data quality rule.\u003c/p\u003e\n"],["\u003cp\u003eThe SQL statement for \u003ccode\u003eSqlAssertion\u003c/code\u003e must adhere to BigQuery standard SQL syntax and must not include semicolons, referencing the data using the\u003ccode\u003e${data()}\u003c/code\u003e placeholder.\u003c/p\u003e\n"],["\u003cp\u003eThe latest version of the documentation is 3.6.0, and historical versions are available ranging from 1.0.0 to 3.5.0, each with its own specific documentation for the class.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eDataQualityRule.Types.SqlAssertion\u003c/code\u003e class inherits from \u003ccode\u003eobject\u003c/code\u003e and implements \u003ccode\u003eIMessage\u003c/code\u003e, \u003ccode\u003eIEquatable\u003c/code\u003e, \u003ccode\u003eIDeepCloneable\u003c/code\u003e, and \u003ccode\u003eIBufferMessage\u003c/code\u003e, along with providing constructor and properties like \u003ccode\u003eSqlStatement\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,[]]
