Cloud Dataplex v1 API - Class DataQualityRule.Types.SqlAssertion (3.2.0) 

public sealed class DataQualityRule.Types.SqlAssertion : IMessage<DataQualityRule.Types.SqlAssertion>, IEquatable<DataQualityRule.Types.SqlAssertion>, IDeepCloneable<DataQualityRule.Types.SqlAssertion>, IBufferMessage, IMessage

Reference documentation and code samples for the Cloud Dataplex v1 API class DataQualityRule.Types.SqlAssertion.

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

Inheritance

object > DataQualityRule.Types.SqlAssertion

Namespace

Google.Cloud.Dataplex.V1

Assembly

Google.Cloud.Dataplex.V1.dll

Constructors

SqlAssertion()

public SqlAssertion()

SqlAssertion(SqlAssertion)

public SqlAssertion(DataQualityRule.Types.SqlAssertion other)
Parameter
Name Description
other DataQualityRuleTypesSqlAssertion

Properties

SqlStatement

public string SqlStatement { get; set; }

Optional. The SQL statement.

Property Value
Type Description
string