Class GoogleCloudDataplexV1DataQualityRuleSqlAssertion
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
Implements
Inherited Members
Namespace: Google.Apis.CloudDataplex.v1.Data
Assembly: Google.Apis.CloudDataplex.v1.dll
Syntax
public class GoogleCloudDataplexV1DataQualityRuleSqlAssertion : IDirectResponseSchema
Properties
ETag
The ETag of the item.
Declaration
public virtual string ETag { get; set; }
Property Value
Type | Description |
---|---|
string |
SqlStatement
Optional. The SQL statement.
Declaration
[JsonProperty("sqlStatement")]
public virtual string SqlStatement { get; set; }
Property Value
Type | Description |
---|---|
string |