Select

classView source ↗

class Select(
    criteria: Criteria,
    to_table: str,
    include_quality_columns: Literal['none', 'criteria', 'all'] = 'none',
)

Bases: CriteriaOperator

Categories: dq-operator

An operator that selects rows based on data quality criteria and writes them to another table.

This operation does not modify the original table.

Initializes the Select operator.

Parameters

parameter

criteria

The criteria for selecting rows. Defaults to Criteria.all_ok().

parameter

to_table

The name of the table where selected rows will be written.

parameter

include_quality_columns

The data quality columns to include in the table with selected data.

Properties

property

criteriaCriteria

Returns the criteria for this Fail operation.

property

include_quality_columnsLiteral['none', 'criteria', 'all']

Returns the data quality columns to included in the table with selected data.

property

to_tablestr

Returns the destination table for the selected rows.