snowflake.core.dynamic_table.DynamicTableCollection¶
- class snowflake.core.dynamic_table.DynamicTableCollection(schema: SchemaResource)¶
Bases:
SchemaObjectCollectionParent
[DynamicTableResource
]Attributes
- database¶
- root¶
- schema¶
Methods
- __init__(schema: SchemaResource)¶
- create(table: DynamicTable | DynamicTableClone | str, *, clone_table: str | Clone | None = None, copy_grants: bool | None = False, mode: CreateMode = CreateMode.error_if_exists) DynamicTableResource ¶
Create a dynamic table.
- Parameters:
table – The dynamic table object, together with the dynamic table’s properties. It can either be a table name or a
DynamicTableClone
object when it’s used with clone_table. It must be aDynamicTable
when it’s not used with this clause.clone_table – The clone clause.
copy_grants – copy grants when clone_table is provided.
mode –
One of the following strings.
CreateMode.error_if_exists: Throw an
snowflake.core.exceptions.ConflictError
if the table already exists in Snowflake. Equivalent to SQLcreate table <name> ...
.CreateMode.or_replace: Replace if the task already exists in Snowflake. Equivalent to SQL
create or replace table <name> ...
.CreateMode.if_not_exists: Do nothing if the task already exists in Snowflake. Equivalent to SQL
create table <name> if not exists...
Default value is CreateMode.error_if_exists.
- items() ItemsView[str, T] ¶
- iter(*, like: str | None = None, starts_with: str | None = None, limit: int | None = None, from_name: str | None = None, deep: bool = False) Iterator[DynamicTable] ¶
Search
Table
objects from Snowflake.- Parameters:
like – The pattern of the Table name. Use
%
to represent any number of characters and?
for a single character.startswith – The table name starts with this string.
limit – limits the number of objects returned.
from_name – enables fetching the specified number of rows following the first row whose object name matches the specified string.
deep – fetch the sub-resources columns and constraints of every table if it’s
True
. DefaultFalse
.
- keys() KeysView[str] ¶
- values() ValuesView[T] ¶