Reference documentation and code samples for the Dataplex V1 API class Google::Cloud::Dataplex::V1::DataQualityRule::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 GoogleSQL
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"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-04 UTC."],[],[],null,["# Dataplex V1 API - Class Google::Cloud::Dataplex::V1::DataQualityRule::SqlAssertion (v2.5.0)\n\nVersion latestkeyboard_arrow_down\n\n- [2.5.0 (latest)](/ruby/docs/reference/google-cloud-dataplex-v1/latest/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [2.4.1](/ruby/docs/reference/google-cloud-dataplex-v1/2.4.1/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [2.3.1](/ruby/docs/reference/google-cloud-dataplex-v1/2.3.1/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [2.2.0](/ruby/docs/reference/google-cloud-dataplex-v1/2.2.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [2.1.0](/ruby/docs/reference/google-cloud-dataplex-v1/2.1.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [2.0.0](/ruby/docs/reference/google-cloud-dataplex-v1/2.0.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [1.4.0](/ruby/docs/reference/google-cloud-dataplex-v1/1.4.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [1.3.0](/ruby/docs/reference/google-cloud-dataplex-v1/1.3.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [1.2.0](/ruby/docs/reference/google-cloud-dataplex-v1/1.2.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [1.1.0](/ruby/docs/reference/google-cloud-dataplex-v1/1.1.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [1.0.1](/ruby/docs/reference/google-cloud-dataplex-v1/1.0.1/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.23.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.23.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.22.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.22.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.21.1](/ruby/docs/reference/google-cloud-dataplex-v1/0.21.1/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.20.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.20.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.19.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.19.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.18.2](/ruby/docs/reference/google-cloud-dataplex-v1/0.18.2/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.17.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.17.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.16.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.16.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.15.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.15.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.14.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.14.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.13.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.13.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.12.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.12.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.11.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.11.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.10.1](/ruby/docs/reference/google-cloud-dataplex-v1/0.10.1/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.9.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.9.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.8.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.8.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.7.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.7.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.6.1](/ruby/docs/reference/google-cloud-dataplex-v1/0.6.1/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.5.1](/ruby/docs/reference/google-cloud-dataplex-v1/0.5.1/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.4.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.4.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.3.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.3.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.2.1](/ruby/docs/reference/google-cloud-dataplex-v1/0.2.1/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion)\n- [0.1.0](/ruby/docs/reference/google-cloud-dataplex-v1/0.1.0/Google-Cloud-Dataplex-V1-DataQualityRule-SqlAssertion) \nReference documentation and code samples for the Dataplex V1 API class Google::Cloud::Dataplex::V1::DataQualityRule::SqlAssertion.\n\nA SQL statement that is evaluated to return rows that match an invalid\nstate. If any rows are are returned, this rule fails.\n\n\nThe SQL statement must use [GoogleSQL\nsyntax](https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax),\nand must not contain any semicolons.\n\nYou can use the data reference parameter `${data()}` to reference the\nsource table with all of its precondition filters applied. Examples of\nprecondition filters include row filters, incremental data filters, and\nsampling. For more information, see [Data reference\nparameter](https://cloud.google.com/dataplex/docs/auto-data-quality-overview#data-reference-parameter).\n\n\u003cbr /\u003e\n\nExample: `SELECT * FROM ${data()} WHERE price \u003c 0` \n\nInherits\n--------\n\n- Object \n\nExtended By\n-----------\n\n- Google::Protobuf::MessageExts::ClassMethods \n\nIncludes\n--------\n\n- Google::Protobuf::MessageExts\n\nMethods\n-------\n\n### #sql_statement\n\n def sql_statement() -\u003e ::String\n\n**Returns**\n\n- (::String) --- Optional. The SQL statement.\n\n### #sql_statement=\n\n def sql_statement=(value) -\u003e ::String\n\n**Parameter**\n\n- **value** (::String) --- Optional. The SQL statement. \n**Returns**\n\n- (::String) --- Optional. The SQL statement."]]