Dataplex V1 API - Class Google::Cloud::Dataplex::V1::DataQualityRule::SqlAssertion (v0.21.0)

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

Inherits

  • Object

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.