Class DataQualityRule.SqlAssertion.Builder (1.45.0)

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

Static Methods

getDescriptor()

public static final Descriptors.Descriptor getDescriptor()
Returns
Type Description
Descriptor

Methods

addRepeatedField(Descriptors.FieldDescriptor field, Object value)

public DataQualityRule.SqlAssertion.Builder addRepeatedField(Descriptors.FieldDescriptor field, Object value)
Parameters
Name Description
field FieldDescriptor
value Object
Returns
Type Description
DataQualityRule.SqlAssertion.Builder
Overrides

build()

public DataQualityRule.SqlAssertion build()
Returns
Type Description
DataQualityRule.SqlAssertion

buildPartial()

public DataQualityRule.SqlAssertion buildPartial()
Returns
Type Description
DataQualityRule.SqlAssertion

clear()

public DataQualityRule.SqlAssertion.Builder clear()
Returns
Type Description
DataQualityRule.SqlAssertion.Builder
Overrides

clearField(Descriptors.FieldDescriptor field)

public DataQualityRule.SqlAssertion.Builder clearField(Descriptors.FieldDescriptor field)
Parameter
Name Description
field FieldDescriptor
Returns
Type Description
DataQualityRule.SqlAssertion.Builder
Overrides

clearOneof(Descriptors.OneofDescriptor oneof)

public DataQualityRule.SqlAssertion.Builder clearOneof(Descriptors.OneofDescriptor oneof)
Parameter
Name Description
oneof OneofDescriptor
Returns
Type Description
DataQualityRule.SqlAssertion.Builder
Overrides

clearSqlStatement()

public DataQualityRule.SqlAssertion.Builder clearSqlStatement()

Optional. The SQL statement.

string sql_statement = 1 [(.google.api.field_behavior) = OPTIONAL];

Returns
Type Description
DataQualityRule.SqlAssertion.Builder

This builder for chaining.

clone()

public DataQualityRule.SqlAssertion.Builder clone()
Returns
Type Description
DataQualityRule.SqlAssertion.Builder
Overrides

getDefaultInstanceForType()

public DataQualityRule.SqlAssertion getDefaultInstanceForType()
Returns
Type Description
DataQualityRule.SqlAssertion

getDescriptorForType()

public Descriptors.Descriptor getDescriptorForType()
Returns
Type Description
Descriptor
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()
Returns
Type Description
FieldAccessorTable
Overrides

isInitialized()

public final boolean isInitialized()
Returns
Type Description
boolean
Overrides

mergeFrom(DataQualityRule.SqlAssertion other)

public DataQualityRule.SqlAssertion.Builder mergeFrom(DataQualityRule.SqlAssertion other)
Parameter
Name Description
other DataQualityRule.SqlAssertion
Returns
Type Description
DataQualityRule.SqlAssertion.Builder

mergeFrom(CodedInputStream input, ExtensionRegistryLite extensionRegistry)

public DataQualityRule.SqlAssertion.Builder mergeFrom(CodedInputStream input, ExtensionRegistryLite extensionRegistry)
Parameters
Name Description
input CodedInputStream
extensionRegistry ExtensionRegistryLite
Returns
Type Description
DataQualityRule.SqlAssertion.Builder
Overrides
Exceptions
Type Description
IOException

mergeFrom(Message other)

public DataQualityRule.SqlAssertion.Builder mergeFrom(Message other)
Parameter
Name Description
other Message
Returns
Type Description
DataQualityRule.SqlAssertion.Builder
Overrides

mergeUnknownFields(UnknownFieldSet unknownFields)

public final DataQualityRule.SqlAssertion.Builder mergeUnknownFields(UnknownFieldSet unknownFields)
Parameter
Name Description
unknownFields UnknownFieldSet
Returns
Type Description
DataQualityRule.SqlAssertion.Builder
Overrides

setField(Descriptors.FieldDescriptor field, Object value)

public DataQualityRule.SqlAssertion.Builder setField(Descriptors.FieldDescriptor field, Object value)
Parameters
Name Description
field FieldDescriptor
value Object
Returns
Type Description
DataQualityRule.SqlAssertion.Builder
Overrides

setRepeatedField(Descriptors.FieldDescriptor field, int index, Object value)

public DataQualityRule.SqlAssertion.Builder setRepeatedField(Descriptors.FieldDescriptor field, int index, Object value)
Parameters
Name Description
field FieldDescriptor
index int
value Object
Returns
Type Description
DataQualityRule.SqlAssertion.Builder
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.

Returns
Type Description
DataQualityRule.SqlAssertion.Builder

This builder for chaining.

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.

Returns
Type Description
DataQualityRule.SqlAssertion.Builder

This builder for chaining.

setUnknownFields(UnknownFieldSet unknownFields)

public final DataQualityRule.SqlAssertion.Builder setUnknownFields(UnknownFieldSet unknownFields)
Parameter
Name Description
unknownFields UnknownFieldSet
Returns
Type Description
DataQualityRule.SqlAssertion.Builder
Overrides