Select

class

class Select(
    to_table: TableNameSpec,
    include_quality_columns: IncludeQualityColumnsSpec = 'none',
    criteria: Criteria,
)

Bases: CriteriaOperator

Categories: dq-operator

An operator that copies the rows selected by criteria to another table, leaving the target table unchanged.

Examples

Copy the failing rows out for review, leaving the table untouched:

Select(AnyFailed(), to_table="to_review")

Parameters

parameter

to_tableTableNameSpec (str)

Table the selected rows are written to; a valid table name (required).

parameter

include_quality_columnsIncludeQualityColumnsSpec (Literal['none', 'criteria', 'all'])

Verdict columns to carry into to_table: "none", "criteria" or "all" (default "none").

parameter

criteriaCriteria

Selects the rows to copy.

Methods

method

to_dict

def to_dict() -> dict[str, Any]

method

to_json

def to_json(indent: int | None = None) -> str

Parameters:

parameter

indentint | None

method

from_dict

def from_dict(d: dict[str, Any]) -> Any

Parameters:

parameter

ddict[str, Any]

method

from_json

def from_json(s: str | bytes) -> Any

Parameters:

parameter

sstr | bytes