Dataplex V1 API - Class Google::Cloud::Dataplex::V1::DataQualityRule::SqlAssertion (v2.3.1)

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.

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.