Send feedback
Dataplex V1 API - Class Google::Cloud::Dataplex::V1::DataQualityRule::SqlAssertion (v0.21.0)
Stay organized with collections
Save and categorize content based on your preferences.
Version latest keyboard_arrow_down
Reference documentation and code samples for the Dataplex V1 API class Google::Cloud::Dataplex::V1::DataQualityRule::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.
Example: SELECT * FROM ${data()} WHERE price < 0
Extended By
Google::Protobuf::MessageExts::ClassMethods
Includes
Google::Protobuf::MessageExts
Methods
#sql_statement
def sql_statement() -> ::String
Returns
(::String) — Optional. The SQL statement.
#sql_statement=
def sql_statement=(value) -> ::String
Parameter
value (::String) — Optional. The SQL statement.
Returns
(::String) — Optional. The SQL statement.
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-05-23 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
Need to tell us more?