Google Cloud Dataplex V1 Client - Class DataQualityRule (1.3.0)

Reference documentation and code samples for the Google Cloud Dataplex V1 Client class DataQualityRule.

A rule captures data quality intent about a data source.

Generated from protobuf message google.cloud.dataplex.v1.DataQualityRule

Namespace

Google \ Cloud \ Dataplex \ V1

Methods

__construct

Constructor.

Parameters
Name
Description
data
array

Optional. Data for populating the Message object.

↳ range_expectation
DataQualityRule\RangeExpectation

Row-level rule which evaluates whether each column value lies between a specified range.

↳ non_null_expectation
DataQualityRule\NonNullExpectation

Row-level rule which evaluates whether each column value is null.

↳ set_expectation
DataQualityRule\SetExpectation

Row-level rule which evaluates whether each column value is contained by a specified set.

↳ regex_expectation
DataQualityRule\RegexExpectation

Row-level rule which evaluates whether each column value matches a specified regex.

↳ uniqueness_expectation
DataQualityRule\UniquenessExpectation

Row-level rule which evaluates whether each column value is unique.

↳ statistic_range_expectation
DataQualityRule\StatisticRangeExpectation

Aggregate rule which evaluates whether the column aggregate statistic lies between a specified range.

↳ row_condition_expectation
DataQualityRule\RowConditionExpectation

Row-level rule which evaluates whether each row in a table passes the specified condition.

↳ table_condition_expectation
DataQualityRule\TableConditionExpectation

Aggregate rule which evaluates whether the provided expression is true for a table.

↳ sql_assertion
DataQualityRule\SqlAssertion

Aggregate rule which evaluates the number of rows returned for the provided statement. If any rows are returned, this rule fails.

↳ column
string

Optional. The unnested column which this rule is evaluated against.

↳ ignore_null
bool

Optional. Rows with null values will automatically fail a rule, unless ignore_null is true . In that case, such null rows are trivially considered passing. This field is only valid for the following type of rules: * * RangeExpectation * * RegexExpectation * * SetExpectation * * UniquenessExpectation

↳ dimension
string

Required. The dimension a rule belongs to. Results are also aggregated at the dimension level. Supported dimensions are ["COMPLETENESS", "ACCURACY", "CONSISTENCY", "VALIDITY", "UNIQUENESS", "FRESHNESS", "VOLUME"]

↳ threshold
float

Optional. The minimum ratio of passing_rows / total_rowsrequired to pass this rule, with a range of [0.0, 1.0]. 0 indicates default value (i.e. 1.0). This field is only valid for row-level type rules.

↳ name
string

Optional. A mutable name for the rule. * * The name must contain only letters (a-z, A-Z), numbers (0-9), or hyphens (-). * * The maximum length is 63 characters. * * Must start with a letter. * * Must end with a number or a letter.

↳ description
string

Optional. Description of the rule. * * The maximum length is 1,024 characters.

↳ suspended
bool

Optional. Whether the Rule is active or suspended. Default is false.

getRangeExpectation

Row-level rule which evaluates whether each column value lies between a specified range.

Returns
Type
Description

hasRangeExpectation

setRangeExpectation

Row-level rule which evaluates whether each column value lies between a specified range.

Parameter
Name
Description
Returns
Type
Description
$this

getNonNullExpectation

Row-level rule which evaluates whether each column value is null.

Returns
Type
Description

hasNonNullExpectation

setNonNullExpectation

Row-level rule which evaluates whether each column value is null.

Parameter
Name
Description
Returns
Type
Description
$this

getSetExpectation

Row-level rule which evaluates whether each column value is contained by a specified set.

Returns
Type
Description

hasSetExpectation

setSetExpectation

Row-level rule which evaluates whether each column value is contained by a specified set.

Parameter
Name
Description
Returns
Type
Description
$this

getRegexExpectation

Row-level rule which evaluates whether each column value matches a specified regex.

Returns
Type
Description

hasRegexExpectation

setRegexExpectation

Row-level rule which evaluates whether each column value matches a specified regex.

Parameter
Name
Description
Returns
Type
Description
$this

getUniquenessExpectation

Row-level rule which evaluates whether each column value is unique.

Returns
Type
Description

hasUniquenessExpectation

setUniquenessExpectation

Row-level rule which evaluates whether each column value is unique.

Parameter
Name
Description
Returns
Type
Description
$this

getStatisticRangeExpectation

Aggregate rule which evaluates whether the column aggregate statistic lies between a specified range.

Returns
Type
Description

hasStatisticRangeExpectation

setStatisticRangeExpectation

Aggregate rule which evaluates whether the column aggregate statistic lies between a specified range.

Parameter
Name
Description
Returns
Type
Description
$this

getRowConditionExpectation

Row-level rule which evaluates whether each row in a table passes the specified condition.

Returns
Type
Description

hasRowConditionExpectation

setRowConditionExpectation

Row-level rule which evaluates whether each row in a table passes the specified condition.

Parameter
Name
Description
Returns
Type
Description
$this

getTableConditionExpectation

Aggregate rule which evaluates whether the provided expression is true for a table.

Returns
Type
Description

hasTableConditionExpectation

setTableConditionExpectation

Aggregate rule which evaluates whether the provided expression is true for a table.

Parameter
Name
Description
Returns
Type
Description
$this

getSqlAssertion

Aggregate rule which evaluates the number of rows returned for the provided statement. If any rows are returned, this rule fails.

Returns
Type
Description

hasSqlAssertion

setSqlAssertion

Aggregate rule which evaluates the number of rows returned for the provided statement. If any rows are returned, this rule fails.

Parameter
Name
Description
Returns
Type
Description
$this

getColumn

Optional. The unnested column which this rule is evaluated against.

Returns
Type
Description
string

setColumn

Optional. The unnested column which this rule is evaluated against.

Parameter
Name
Description
var
string
Returns
Type
Description
$this

getIgnoreNull

Optional. Rows with null values will automatically fail a rule, unless ignore_null is true . In that case, such null rows are trivially considered passing.

This field is only valid for the following type of rules:

  • RangeExpectation
  • RegexExpectation
  • SetExpectation
  • UniquenessExpectation
Returns
Type
Description
bool

setIgnoreNull

Optional. Rows with null values will automatically fail a rule, unless ignore_null is true . In that case, such null rows are trivially considered passing.

This field is only valid for the following type of rules:

  • RangeExpectation
  • RegexExpectation
  • SetExpectation
  • UniquenessExpectation
Parameter
Name
Description
var
bool
Returns
Type
Description
$this

getDimension

Required. The dimension a rule belongs to. Results are also aggregated at the dimension level. Supported dimensions are ["COMPLETENESS", "ACCURACY", "CONSISTENCY", "VALIDITY", "UNIQUENESS", "FRESHNESS", "VOLUME"]

Returns
Type
Description
string

setDimension

Required. The dimension a rule belongs to. Results are also aggregated at the dimension level. Supported dimensions are ["COMPLETENESS", "ACCURACY", "CONSISTENCY", "VALIDITY", "UNIQUENESS", "FRESHNESS", "VOLUME"]

Parameter
Name
Description
var
string
Returns
Type
Description
$this

getThreshold

Optional. The minimum ratio of passing_rows / total_rowsrequired to pass this rule, with a range of [0.0, 1.0].

0 indicates default value (i.e. 1.0). This field is only valid for row-level type rules.

Returns
Type
Description
float

setThreshold

Optional. The minimum ratio of passing_rows / total_rowsrequired to pass this rule, with a range of [0.0, 1.0].

0 indicates default value (i.e. 1.0). This field is only valid for row-level type rules.

Parameter
Name
Description
var
float
Returns
Type
Description
$this

getName

Optional. A mutable name for the rule.

  • The name must contain only letters (a-z, A-Z), numbers (0-9), or hyphens (-).
  • The maximum length is 63 characters.
  • Must start with a letter.
  • Must end with a number or a letter.
Returns
Type
Description
string

setName

Optional. A mutable name for the rule.

  • The name must contain only letters (a-z, A-Z), numbers (0-9), or hyphens (-).
  • The maximum length is 63 characters.
  • Must start with a letter.
  • Must end with a number or a letter.
Parameter
Name
Description
var
string
Returns
Type
Description
$this

getDescription

Optional. Description of the rule.

  • The maximum length is 1,024 characters.
Returns
Type
Description
string

setDescription

Optional. Description of the rule.

  • The maximum length is 1,024 characters.
Parameter
Name
Description
var
string
Returns
Type
Description
$this

getSuspended

Optional. Whether the Rule is active or suspended.

Default is false.

Returns
Type
Description
bool

setSuspended

Optional. Whether the Rule is active or suspended.

Default is false.

Parameter
Name
Description
var
bool
Returns
Type
Description
$this

getRuleType

Returns
Type
Description
string
Design a Mobile Site
View Site in Mobile | Classic
Share by: