- 1.52.0 (latest)
- 1.51.0
- 1.50.0
- 1.49.0
- 1.47.0
- 1.46.0
- 1.45.0
- 1.44.0
- 1.43.0
- 1.42.0
- 1.41.0
- 1.40.0
- 1.39.0
- 1.38.0
- 1.37.0
- 1.35.0
- 1.34.0
- 1.33.0
- 1.32.0
- 1.31.0
- 1.30.0
- 1.29.0
- 1.28.0
- 1.27.0
- 1.26.0
- 1.25.0
- 1.22.0
- 1.21.0
- 1.20.0
- 1.19.0
- 1.18.0
- 1.17.0
- 1.16.0
- 1.15.0
- 1.14.0
- 1.13.0
- 1.12.0
- 1.11.0
- 1.10.0
- 1.9.0
- 1.7.0
- 1.6.0
- 1.5.0
- 1.4.0
- 1.3.0
- 1.2.0
- 1.1.2
- 1.0.1
- 0.2.2
public static final class DataQualityRule.SqlAssertion.Builder extends GeneratedMessageV3.Builder<DataQualityRule.SqlAssertion.Builder> implements DataQualityRule.SqlAssertionOrBuilder
Queries for rows returned by the provided SQL statement. If any rows are are returned, this rule fails.
The SQL statement needs to use BigQuery standard SQL syntax, and must not contain any semicolons.
${data()} can be used to reference the rows being evaluated, i.e. the table after all additional filters (row filters, incremental data filters, sampling) are applied.
Example: SELECT * FROM ${data()} WHERE price < 0
Protobuf type google.cloud.dataplex.v1.DataQualityRule.SqlAssertion
Inheritance
Object > AbstractMessageLite.Builder<MessageType,BuilderType> > AbstractMessage.Builder<BuilderType> > GeneratedMessageV3.Builder > DataQualityRule.SqlAssertion.BuilderImplements
DataQualityRule.SqlAssertionOrBuilderStatic 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 |
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 |
clearField(Descriptors.FieldDescriptor field)
public DataQualityRule.SqlAssertion.Builder clearField(Descriptors.FieldDescriptor field)
Parameter | |
---|---|
Name | Description |
field |
FieldDescriptor |
Returns | |
---|---|
Type | Description |
DataQualityRule.SqlAssertion.Builder |
clearOneof(Descriptors.OneofDescriptor oneof)
public DataQualityRule.SqlAssertion.Builder clearOneof(Descriptors.OneofDescriptor oneof)
Parameter | |
---|---|
Name | Description |
oneof |
OneofDescriptor |
Returns | |
---|---|
Type | Description |
DataQualityRule.SqlAssertion.Builder |
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 |
getDefaultInstanceForType()
public DataQualityRule.SqlAssertion getDefaultInstanceForType()
Returns | |
---|---|
Type | Description |
DataQualityRule.SqlAssertion |
getDescriptorForType()
public Descriptors.Descriptor getDescriptorForType()
Returns | |
---|---|
Type | Description |
Descriptor |
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 |
isInitialized()
public final boolean isInitialized()
Returns | |
---|---|
Type | Description |
boolean |
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 |
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 |
mergeUnknownFields(UnknownFieldSet unknownFields)
public final DataQualityRule.SqlAssertion.Builder mergeUnknownFields(UnknownFieldSet unknownFields)
Parameter | |
---|---|
Name | Description |
unknownFields |
UnknownFieldSet |
Returns | |
---|---|
Type | Description |
DataQualityRule.SqlAssertion.Builder |
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 |
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 |
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 |