snowflake.core.dynamic_table.DynamicTable

class snowflake.core.dynamic_table.DynamicTable(*, name: Annotated[str, Strict(strict=True)], kind: Annotated[str, Strict(strict=True)] | None = 'PERMANENT', columns: List[DynamicTableColumn] | None = None, target_lag: TargetLag, refresh_mode: Annotated[str, Strict(strict=True)] | None = None, initialize: Annotated[str, Strict(strict=True)] | None = None, warehouse: Annotated[str, Strict(strict=True)], cluster_by: List[Annotated[str, Strict(strict=True)]] | None = None, query: Annotated[str, Strict(strict=True)], data_retention_time_in_days: Annotated[int, Strict(strict=True)] | None = None, max_data_extension_time_in_days: Annotated[int, Strict(strict=True)] | None = None, comment: Annotated[str, Strict(strict=True)] | None = None, created_on: datetime | None = None, database_name: Annotated[str, Strict(strict=True)] | None = None, schema_name: Annotated[str, Strict(strict=True)] | None = None, rows: Annotated[int, Strict(strict=True)] | None = None, bytes: Annotated[int, Strict(strict=True)] | None = None, scheduling_state: Annotated[str, Strict(strict=True)] | None = None, automatic_clustering: Annotated[bool, Strict(strict=True)] | None = None, owner: Annotated[str, Strict(strict=True)] | None = None, owner_role_type: Annotated[str, Strict(strict=True)] | None = None, budget: Annotated[str, Strict(strict=True)] | None = None)

Bases: BaseModel

A model object representing the DynamicTable resource.

Constructs an object of type DynamicTable with the provided properties.

Parameters:

  • name (str) – Specifies the name for the dynamic table, must be unique for the schema in which the dynamic table is created

  • target_lag (TargetLag)

warehousestr

Specifies the name of the warehouse that provides the compute resources for refreshing the dynamic table

querystr

Specifies the query whose results the dynamic table should contain

kindstr, default ‘PERMANENT’

Specifies the dynamic table type, permanent (default) or transient.

columns : list[DynamicTableColumn], optional

refresh_modestr, optional

Specifies the refresh type for the dynamic table

initializestr, optional

Specifies the behavior of the initial refresh of the dynamic table

cluster_bylist[str], optional

Specifies one or more columns or column expressions in the dynamic table as the clustering key

data_retention_time_in_daysint, optional

Specifies the retention period for the dynamic table so that Time Travel actions (SELECT, CLONE) can be performed on historical data in the dynamic table

max_data_extension_time_in_daysint, optional

Specifies the retention period for the dynamic table so that Time Travel actions (SELECT, CLONE) can be performed on historical data in the dynamic table

commentstr, optional

Specifies a comment for the dynamic table.

created_ondatetime, optional

Date and time when the dynamic table was created.

database_namestr, optional

Database in which the dynamic table is stored

schema_namestr, optional

Schema in which the dynamic table is stored

rowsint, optional

Number of rows in the dynamic table.

bytesint, optional

Number of bytes that will be scanned if the entire table is scanned in a query. Note that this number may be different than the number of actual physical bytes stored on-disk for the table

scheduling_statestr, optional

Scheduling state (RUNNING or SUSPENDED)

automatic_clusteringbool, optional

If Automatic Clustering is enabled for your account, specifies whether it is explicitly enabled or disabled for the dynamic table.

ownerstr, optional

Role that owns the table

owner_role_typestr, optional

The type of role that owns the object.

budgetstr, optional

Name of the budget if the object is monitored by a budget

Create a new model by parsing and validating input data from keyword arguments.

Raises [ValidationError][pydantic_core.ValidationError] if the input data cannot be validated to form a valid model.

self is explicitly positional-only to allow self as a field name.

Methods

classmethod from_dict(obj: dict) → DynamicTable

Create an instance of DynamicTable from a dict.

classmethod from_json(json_str: str) → DynamicTable

Create an instance of DynamicTable from a JSON string

to_dict(hide_readonly_properties: bool = False) → dict[str, Any]

Returns the dictionary representation of the model using alias

to_dict_without_readonly_properties() → dict[str, Any]

Return the dictionary representation of the model without readonly properties.

to_json() → str

Returns the JSON representation of the model using alias.

to_str() → str

Returns the string representation of the model using alias.

Language: English