- 1.53.0 (latest)
- 1.52.0
- 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.SqlAssertionOrBuilderA 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
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 |
StringThe 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 |
ByteStringThe 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 |
|