Class DataQualityRule.SqlAssertion.Builder (1.49.0) 
  
      
     
  
  
  
   
  
    
  
  
    
    
    
  Version 1.49.0keyboard_arrow_down  
  
 
    
    
    
    
      
  
  
  
    
public   static   final   class  DataQualityRule . SqlAssertion . Builder   extends   GeneratedMessageV3 . Builder<DataQualityRule . SqlAssertion . Builder >  implements   DataQualityRule . SqlAssertionOrBuilder  
   
   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
 Protobuf type google.cloud.dataplex.v1.DataQualityRule.SqlAssertion
 
  
  
  
    Inherited Members 
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
      com.google.protobuf.GeneratedMessageV3.Builder.getUnknownFieldSetBuilder() 
    
    
    
    
    
    
    
      com.google.protobuf.GeneratedMessageV3.Builder.internalGetMapFieldReflection(int) 
    
    
    
      com.google.protobuf.GeneratedMessageV3.Builder.internalGetMutableMapFieldReflection(int) 
    
    
    
    
    
    
      com.google.protobuf.GeneratedMessageV3.Builder.mergeUnknownLengthDelimitedField(int,com.google.protobuf.ByteString) 
    
    
      com.google.protobuf.GeneratedMessageV3.Builder.mergeUnknownVarintField(int,int) 
    
    
    
    
    
      com.google.protobuf.GeneratedMessageV3.Builder.parseUnknownField(com.google.protobuf.CodedInputStream,com.google.protobuf.ExtensionRegistryLite,int) 
    
    
    
    
      com.google.protobuf.GeneratedMessageV3.Builder.setUnknownFieldSetBuilder(com.google.protobuf.UnknownFieldSet.Builder) 
    
    
    
    
    
    
    
    
    
    
    
    
   
  Static Methods
   
   
  getDescriptor() 
  
    
public   static   final   Descriptors . Descriptor   getDescriptor ()  
   
  
  Methods
   
   
  addRepeatedField(Descriptors.FieldDescriptor field, Object value) 
  
    
public   DataQualityRule . SqlAssertion . Builder   addRepeatedField ( Descriptors . FieldDescriptor   field ,   Object   value )  
   
  
  
  Overrides 
  
   
  build() 
  
    
public   DataQualityRule . SqlAssertion   build ()  
   
  
   
  buildPartial() 
  
    
public   DataQualityRule . SqlAssertion   buildPartial ()  
   
  
   
  clear() 
  
    
public   DataQualityRule . SqlAssertion . Builder   clear ()  
   
  
  Overrides 
  
   
  clearField(Descriptors.FieldDescriptor field) 
  
    
public   DataQualityRule . SqlAssertion . Builder   clearField ( Descriptors . FieldDescriptor   field )  
   
  
  
  Overrides 
  
   
  clearOneof(Descriptors.OneofDescriptor oneof) 
  
    
public   DataQualityRule . SqlAssertion . Builder   clearOneof ( Descriptors . OneofDescriptor   oneof )  
   
  
  
  Overrides 
  
   
  clearSqlStatement() 
  
    
public   DataQualityRule . SqlAssertion . Builder   clearSqlStatement ()  
   
   Optional. The SQL statement.
 string sql_statement = 1 [(.google.api.field_behavior) = OPTIONAL];
 
  
   
  clone() 
  
    
public   DataQualityRule . SqlAssertion . Builder   clone ()  
   
  
  Overrides 
  
   
  getDefaultInstanceForType() 
  
    
public   DataQualityRule . SqlAssertion   getDefaultInstanceForType ()  
   
  
   
  getDescriptorForType() 
  
    
public   Descriptors . Descriptor   getDescriptorForType ()  
   
  
  Overrides 
  
   
  getSqlStatement() 
  
    
public   String   getSqlStatement ()  
   
   Optional. The SQL statement.
 string sql_statement = 1 [(.google.api.field_behavior) = OPTIONAL];
 
  
    
      
        Returns  
       
      
        Type  
        Description  
       
      
        String  
        The sqlStatement.
 
       
     
  
   
  getSqlStatementBytes() 
  
    
public   ByteString   getSqlStatementBytes ()  
   
   Optional. The SQL statement.
 string sql_statement = 1 [(.google.api.field_behavior) = OPTIONAL];
 
  
    
      
        Returns  
       
      
        Type  
        Description  
       
      
        ByteString  
        The bytes for sqlStatement.
 
       
     
  
   
  internalGetFieldAccessorTable() 
  
    
protected   GeneratedMessageV3 . FieldAccessorTable   internalGetFieldAccessorTable ()  
   
  
  Overrides 
  
   
  isInitialized() 
  
    
public   final   boolean   isInitialized ()  
   
  
  Overrides 
  
   
  mergeFrom(DataQualityRule.SqlAssertion other) 
  
    
public   DataQualityRule . SqlAssertion . Builder   mergeFrom ( DataQualityRule . SqlAssertion   other )  
   
  
  
   
  
  
    
public   DataQualityRule . SqlAssertion . Builder   mergeFrom ( CodedInputStream   input ,   ExtensionRegistryLite   extensionRegistry )  
   
  
  
  Overrides 
  
  
   
  mergeFrom(Message other) 
  
    
public   DataQualityRule . SqlAssertion . Builder   mergeFrom ( Message   other )  
   
  
    
      
        Parameter  
       
      
        Name  
        Description  
       
      
        other 
        Message  
       
     
  
  
  Overrides 
  
   
  mergeUnknownFields(UnknownFieldSet unknownFields) 
  
    
public   final   DataQualityRule . SqlAssertion . Builder   mergeUnknownFields ( UnknownFieldSet   unknownFields )  
   
  
  
  Overrides 
  
   
  setField(Descriptors.FieldDescriptor field, Object value) 
  
    
public   DataQualityRule . SqlAssertion . Builder   setField ( Descriptors . FieldDescriptor   field ,   Object   value )  
   
  
  
  Overrides 
  
   
  setRepeatedField(Descriptors.FieldDescriptor field, int index, Object value) 
  
    
public   DataQualityRule . SqlAssertion . Builder   setRepeatedField ( Descriptors . FieldDescriptor   field ,   int   index ,   Object   value )  
   
  
  
  Overrides 
  
   
  setSqlStatement(String value) 
  
    
public   DataQualityRule . SqlAssertion . Builder   setSqlStatement ( String   value )  
   
   Optional. The SQL statement.
 string sql_statement = 1 [(.google.api.field_behavior) = OPTIONAL];
 
  
    
      
        Parameter  
       
      
        Name  
        Description  
       
      
        value 
        String The sqlStatement to set.
 
       
     
  
  
   
  setSqlStatementBytes(ByteString value) 
  
    
public   DataQualityRule . SqlAssertion . Builder   setSqlStatementBytes ( ByteString   value )  
   
   Optional. The SQL statement.
 string sql_statement = 1 [(.google.api.field_behavior) = OPTIONAL];
 
  
    
      
        Parameter  
       
      
        Name  
        Description  
       
      
        value 
        ByteString The bytes for sqlStatement to set.
 
       
     
  
  
   
  setUnknownFields(UnknownFieldSet unknownFields) 
  
    
public   final   DataQualityRule . SqlAssertion . Builder   setUnknownFields ( UnknownFieldSet   unknownFields )  
   
  
  
  Overrides 
  
 
     
    
  
  
  
     
  
 
  
    
    
      
       
    
    
  
  
 
  Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
  Last updated 2025-10-30 UTC.
 
 
  
  
  
    
      [[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-10-30 UTC."],[],[]]