Send feedback
Class DataQualityRule.SqlAssertion (1.53.0)
Stay organized with collections
Save and categorize content based on your preferences.
Version 1.53.0 keyboard_arrow_down
public static final class DataQualityRule . SqlAssertion extends GeneratedMessageV3 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.<ListT>makeMutableCopy(ListT)
com.google.protobuf.GeneratedMessageV3.<ListT>makeMutableCopy(ListT,int)
com.google.protobuf.GeneratedMessageV3.<T>emptyList(java.lang.Class<T>)
com.google.protobuf.GeneratedMessageV3.internalGetMapFieldReflection(int)
Static Fields
SQL_STATEMENT_FIELD_NUMBER
public static final int SQL_STATEMENT_FIELD_NUMBER
Field Value
Type Description
int
Static Methods
getDefaultInstance()
public static DataQualityRule . SqlAssertion getDefaultInstance ()
getDescriptor()
public static final Descriptors . Descriptor getDescriptor ()
newBuilder()
public static DataQualityRule . SqlAssertion . Builder newBuilder ()
newBuilder(DataQualityRule.SqlAssertion prototype)
public static DataQualityRule . SqlAssertion . Builder newBuilder ( DataQualityRule . SqlAssertion prototype )
public static DataQualityRule . SqlAssertion parseDelimitedFrom ( InputStream input )
public static DataQualityRule . SqlAssertion parseDelimitedFrom ( InputStream input , ExtensionRegistryLite extensionRegistry )
parseFrom(byte[] data)
public static DataQualityRule . SqlAssertion parseFrom ( byte [] data )
Parameter
Name Description
databyte []
parseFrom(byte[] data, ExtensionRegistryLite extensionRegistry)
public static DataQualityRule . SqlAssertion parseFrom ( byte [] data , ExtensionRegistryLite extensionRegistry )
parseFrom(ByteString data)
public static DataQualityRule . SqlAssertion parseFrom ( ByteString data )
parseFrom(ByteString data, ExtensionRegistryLite extensionRegistry)
public static DataQualityRule . SqlAssertion parseFrom ( ByteString data , ExtensionRegistryLite extensionRegistry )
public static DataQualityRule . SqlAssertion parseFrom ( CodedInputStream input )
public static DataQualityRule . SqlAssertion parseFrom ( CodedInputStream input , ExtensionRegistryLite extensionRegistry )
public static DataQualityRule . SqlAssertion parseFrom ( InputStream input )
public static DataQualityRule . SqlAssertion parseFrom ( InputStream input , ExtensionRegistryLite extensionRegistry )
parseFrom(ByteBuffer data)
public static DataQualityRule . SqlAssertion parseFrom ( ByteBuffer data )
parseFrom(ByteBuffer data, ExtensionRegistryLite extensionRegistry)
public static DataQualityRule . SqlAssertion parseFrom ( ByteBuffer data , ExtensionRegistryLite extensionRegistry )
parser()
public static Parser<DataQualityRule . SqlAssertion > parser ()
Methods
equals(Object obj)
public boolean equals ( Object obj )
Parameter
Name Description
objObject
Overrides
getDefaultInstanceForType()
public DataQualityRule . SqlAssertion getDefaultInstanceForType ()
getParserForType()
public Parser<DataQualityRule . SqlAssertion > getParserForType ()
Overrides
getSerializedSize()
public int getSerializedSize ()
Returns
Type Description
int
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.
hashCode()
Returns
Type Description
int
Overrides
internalGetFieldAccessorTable()
protected GeneratedMessageV3 . FieldAccessorTable internalGetFieldAccessorTable ()
Overrides
isInitialized()
public final boolean isInitialized ()
Overrides
newBuilderForType()
public DataQualityRule . SqlAssertion . Builder newBuilderForType ()
newBuilderForType(GeneratedMessageV3.BuilderParent parent)
protected DataQualityRule . SqlAssertion . Builder newBuilderForType ( GeneratedMessageV3 . BuilderParent parent )
Overrides
newInstance(GeneratedMessageV3.UnusedPrivateParameter unused)
protected Object newInstance ( GeneratedMessageV3 . UnusedPrivateParameter unused )
Returns
Type Description
Object
Overrides
toBuilder()
public DataQualityRule . SqlAssertion . Builder toBuilder ()
writeTo(CodedOutputStream output)
public void writeTo ( CodedOutputStream output )
Overrides
Send feedback
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-01-28 UTC.
Need to tell us more?
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-01-28 UTC."],[],[]]
