Class: Google::Apis::DataplexV1::GoogleCloudDataplexV1DataQualityRuleSqlAssertion

Inherits:

Object

• Object
• Google::Apis::DataplexV1::GoogleCloudDataplexV1DataQualityRuleSqlAssertion

Includes:

Core::Hashable, Core::JsonObjectSupport

Defined in:

lib/google/apis/dataplex_v1/classes.rb,
lib/google/apis/dataplex_v1/representations.rb,
lib/google/apis/dataplex_v1/representations.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 (https://cloud.google.com/dataplex/docs/auto-data- quality-overview#data-reference-parameter).Example: SELECT * FROM $data() WHERE price < 0

Instance Attribute Summary

• #sql_statement ⇒ String

  Optional.

Instance Method Summary

• #initialize(**args) ⇒ GoogleCloudDataplexV1DataQualityRuleSqlAssertion constructor

  A new instance of GoogleCloudDataplexV1DataQualityRuleSqlAssertion.

• #update!(**args) ⇒ Object

  Update properties of this object.

Constructor Details

#initialize(**args) ⇒ GoogleCloudDataplexV1DataQualityRuleSqlAssertion

Returns a new instance of GoogleCloudDataplexV1DataQualityRuleSqlAssertion.

# File 'lib/google/apis/dataplex_v1/classes.rb', line 2548

def initialize(**args)
   update!(**args)
end

Instance Attribute Details

#sql_statement ⇒ String

Optional. The SQL statement. Corresponds to the JSON property sqlStatement

Returns:

• (String)

# File 'lib/google/apis/dataplex_v1/classes.rb', line 2546

def sql_statement
  @sql_statement
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object

# File 'lib/google/apis/dataplex_v1/classes.rb', line 2553

def update!(**args)
  @sql_statement = args[:sql_statement] if args.key?(:sql_statement)
end