data_quality.rb in google-cloud-dataplex-v1-0.21.1

- old
+ new

@@ -237,10 +237,16 @@
         # @!attribute [rw] failing_rows_query
         #   @return [::String]
         #     The query to find rows that did not pass this rule.
         #
         #     This field is only valid for row-level type rules.
+        # @!attribute [r] assertion_row_count
+        #   @return [::Integer]
+        #     Output only. The number of rows returned by the SQL statement in a SQL
+        #     assertion rule.
+        #
+        #     This field is only valid for SQL assertion rules.
         class DataQualityRuleResult
           include ::Google::Protobuf::MessageExts
           extend ::Google::Protobuf::MessageExts::ClassMethods
         end
 
@@ -305,10 +311,14 @@
         #     specified condition.
         # @!attribute [rw] table_condition_expectation
         #   @return [::Google::Cloud::Dataplex::V1::DataQualityRule::TableConditionExpectation]
         #     Aggregate rule which evaluates whether the provided expression is true
         #     for a table.
+        # @!attribute [rw] sql_assertion
+        #   @return [::Google::Cloud::Dataplex::V1::DataQualityRule::SqlAssertion]
+        #     Aggregate rule which evaluates the number of rows returned for the
+        #     provided statement. If any rows are returned, this rule fails.
         # @!attribute [rw] column
         #   @return [::String]
         #     Optional. The unnested column which this rule is evaluated against.
         # @!attribute [rw] ignore_null
         #   @return [::Boolean]
@@ -482,9 +492,30 @@
           # Example: MIN(col1) >= 0
           # @!attribute [rw] sql_expression
           #   @return [::String]
           #     Optional. The SQL expression.
           class TableConditionExpectation
+            include ::Google::Protobuf::MessageExts
+            extend ::Google::Protobuf::MessageExts::ClassMethods
+          end
+
+          # 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`
+          # @!attribute [rw] sql_statement
+          #   @return [::String]
+          #     Optional. The SQL statement.
+          class SqlAssertion
             include ::Google::Protobuf::MessageExts
             extend ::Google::Protobuf::MessageExts::ClassMethods
           end
         end
 