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 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\u003e\u003ccode\u003eSqlAssertion\u003c/code\u003e is used to define SQL-based data quality rules where the presence of returned rows indicates a rule failure.\u003c/p\u003e\n"],["\u003cp\u003eThe SQL statements used in \u003ccode\u003eSqlAssertion\u003c/code\u003e rules must adhere to BigQuery standard SQL syntax and should not contain semicolons.\u003c/p\u003e\n"],["\u003cp\u003eThe documentation includes details on the class's inheritance, implemented interfaces, constructors, and the \u003ccode\u003eSqlStatement\u003c/code\u003e property, as well as the historical versions of this type ranging from 1.0.0 up to 3.6.0.\u003c/p\u003e\n"]]],[],null,[]]
