Class: Google::Cloud::Dataplex::V1::DataQualityRule::SqlAssertion

Inherits:
Object
  • Object
show all
Extended by:
Protobuf::MessageExts::ClassMethods
Includes:
Protobuf::MessageExts
Defined in:
proto_docs/google/cloud/dataplex/v1/data_quality.rb

Overview

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 BigQuery standard SQL 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

Instance Attribute Summary collapse

Instance Attribute Details

#sql_statement ⇒ ::String

Returns Optional. The SQL statement.

Returns:

  • (::String) —

    Optional. The SQL statement.



517
518
519
520
 
# File 'proto_docs/google/cloud/dataplex/v1/data_quality.rb', line 517

class SqlAssertion
  include ::Google::Protobuf::MessageExts
  extend ::Google::Protobuf::MessageExts::ClassMethods
end