snowflake.core.table.TableCollection¶

class snowflake.core.table.TableCollection(schema: SchemaResource)¶

Bases: SchemaObjectCollectionParent[TableResource]

Attributes

database¶

root¶

schema¶

Methods

__init__(schema: SchemaResource)¶

create(table: TableModel | str, *, as_select: str | None = None, template: str | None = None, like_table: str | None = None, clone_table: str | None = None, copy_grants: bool | None = False, mode: CreateMode = CreateMode.error_if_exists) → TableResource¶

Create a table.

Parameters:

• table – The table object, together with the table’s properties, object parameters, columns, and constraints. It can either be a table name or a Table object when it’s used together with as_select, template, like_table, clone_table. It must be a Table when it’s not used with these clauses.

• as_select – The as select clause.

• template – The using template clause.

• like_table – The like 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 SQL create 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.

Not currently implemented:

• Row access policy

• Column masking policy

• Search optimization

• Tags

• Stage file format and copy options

items() → ItemsView[str, T]¶

iter(*, like: str | None = None, starts_with: str | None = None, limit: int | None = None, from_name: str | None = None, history: bool = False, deep: bool = False) → PagedIter[TableModel]¶

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. Default False.

• history – includes dropped tables that have not yet been purged.

keys() → KeysView[str]¶

values() → ValuesView[T]¶