Cloud Dataplex v1 API - Class DataQualityRule.Types.SqlAssertion (3.1.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.

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

Inheritance

object > DataQualityRule.Types.SqlAssertion

Implements

IMessage DataQualityRule Types SqlAssertion, IEquatable DataQualityRule Types SqlAssertion, IDeepCloneable DataQualityRule Types SqlAssertion, IBufferMessage, IMessage

Inherited Members

object.GetHashCode()

object.GetType()

object.ToString()

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`