TableAsset
A class representing a table from a SQL database
Parameters
Name Description table_name
The name of the database table to be added
schema_name
The name of the schema containing the database table to be added.
Adds a daily Batch Definition to this Data Asset
Parameters
Name Description name
The name of the Batch Definition to be added
column
The column name on which to partition the asset by day
sort_ascending
Boolean to indicate whether to sort ascending (default) or descending. When running a validation, we default to running the last Batch Definition if one is not explicitly specified.
Returns
Type Description BatchDefinition
The added BatchDefinition object.
Adds a monthly Batch Definition to this Data Asset
Parameters
Name Description name
The name of the Batch Definition to be added
column
The column name on which to partition the asset by month
sort_ascending
Boolean to indicate whether to sort ascending (default) or descending. When running a validation, we default to running the last Batch Definition if one is not explicitly specified.
Returns
Type Description BatchDefinition
The added BatchDefinition object.
Adds a whole table Batch Definition to this Data Asset
Parameters
Name Description name
The name of the Batch Definition to be added
Returns
Type Description BatchDefinition
The added BatchDefinition object.
Adds a yearly Batch Definition to this Data Asset
Parameters
Name Description name
The name of the Batch Definition to be added.
column
The column name on which to partition the asset by year.
sort_ascending
Boolean to indicate whether to sort ascending (default) or descending. When running a validation, we default to running the last Batch Definition if one is not explicitly specified.
Returns
Type Description BatchDefinition
The added BatchDefinition object.
Delete a batch definition.
Parameters
Name Description name (str)
Name of the BatchDefinition to delete.
Get a batch definition.
Parameters
Name Description name (str)
Name of the BatchDefinition to get.
Raises
Type Description KeyError
If the BatchDefinition does not exist.
Validates that the Batch Definition column is of a permissible type
- This isn't meant to be called directly. This is called internally when a Batch Definition
is added. Data asset implementers can override this for their specific data asset.
Raises
Type Description SqlAddBatchDefinitionError
The specified column to partition on is not of a permissible type for batching (ie date or datetime) or no data is present in this column.
class great_expectations.datasource.fluent.sql_datasource.TableAsset(
*,
name: str,
type: typing.Literal['table'] = 'table',
id: <pydantic.v1.fields.DeferredType object at 0x7fed497a3bc0> = None,
order_by: <pydantic.v1.fields.DeferredType object at 0x7fed497a3c80> = None,
batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fed497a3dd0> = None,
batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fed497a3f80> = None,
table_name: str = '',
schema_name: typing.Optional[str] = None
)
Methods
add_batch_definition_daily
add_batch_definition_daily(
name: str,
column: str,
sort_ascending: bool = True,
validate_batchable: bool = True
) → BatchDefinition
add_batch_definition_monthly
add_batch_definition_monthly(
name: str,
column: str,
sort_ascending: bool = True,
validate_batchable: bool = True
) → BatchDefinition
add_batch_definition_whole_table
add_batch_definition_whole_table(
name: str
) → BatchDefinition
add_batch_definition_yearly
add_batch_definition_yearly(
name: str,
column: str,
sort_ascending: bool = True,
validate_batchable: bool = True
) → BatchDefinition
delete_batch_definition
delete_batch_definition(
name: str
) → None
get_batch_definition
get_batch_definition(
name: str
) → great_expectations.core.batch_definition.BatchDefinition
validate_batch_definition
validate_batch_definition(
partitioner: Union[great_expectations.core.partitioners.PartitionerColumnValue,
great_expectations.core.partitioners.PartitionerMultiColumnValue,
great_expectations.core.partitioners.PartitionerDividedInteger,
great_expectations.core.partitioners.PartitionerModInteger,
great_expectations.core.partitioners.ColumnPartitionerYearly,
great_expectations.core.partitioners.ColumnPartitionerMonthly,
great_expectations.core.partitioners.ColumnPartitionerDaily,
great_expectations.core.partitioners.PartitionerDatetimePart,
great_expectations.core.partitioners.PartitionerConvertedDatetime]
) → None