- 1.81.0 (latest)
- 1.80.0
- 1.79.0
- 1.78.0
- 1.76.0
- 1.74.0
- 1.73.0
- 1.72.0
- 1.71.0
- 1.70.0
- 1.68.0
- 1.66.0
- 1.65.0
- 1.62.0
- 1.61.0
- 1.60.0
- 1.58.0
- 1.57.0
- 1.56.0
- 1.55.0
- 1.54.0
- 1.53.0
- 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 GeneratedMessage.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 GoogleSQL 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
java.lang.Object > AbstractMessageLite.Builder<MessageType,BuilderType> > AbstractMessage.Builder<BuilderType> > GeneratedMessage.Builder > DataQualityRule.SqlAssertion.BuilderImplements
DataQualityRule.SqlAssertionOrBuilderStatic Methods
getDescriptor()
public static final Descriptors.Descriptor getDescriptor()| Returns | |
|---|---|
| Type | Description |
Descriptor |
|
Methods
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 |
|
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. |
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 GeneratedMessage.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 |
|
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. |