snowflake.core.database.DatabaseCollection¶

class snowflake.core.database.DatabaseCollection(root: Root)¶

Bases: AccountObjectCollectionParent[DatabaseResource]

Attributes

root¶

Methods

__init__(root: Root) → None¶

create(database: Database, *, clone: Clone | None = None, mode: Literal['errorifexists'] | Literal['orreplace'] | Literal['ifnotexists'] = 'errorifexists', kind: str = '') → DatabaseResource¶

Create a database in Snowflake.

Parameters:

• service – an instance of ComputePool.

• mode –

  One of the following strings.

  errorifexists: Throw an snowflake.core.exceptions.ConflictError if the compute pool already exists in Snowflake. Equivalent to SQL create compute pool <name> ....

  ”orreplace”: Replace if the compute pool already exists in Snowflake. Equivalent to SQL create or replace compute pool <name> ....

  ”ifnotexists”: Do nothing if the compute pool already exists in Snowflake. Equivalent to SQL create compute pool <name> if not exists...

  Default value is “errorifexists”.

create_from_share(name: str, share: str, kind: str = '', *, mode: Literal['errorifexists'] | Literal['orreplace'] | Literal['ifnotexists'] = 'errorifexists') → DatabaseResource¶

Create a Database from a share.

Share is of the form ‘<provider_account>.<share_name>’.

items() → ItemsView[str, T]¶

iter(*, like: str | None = None, startswith: str | None = None, limit: int | None = None, from_name: str | None = None) → PagedIter[Database]¶

Look up databases in Snowflake.

keys() → KeysView[str]¶

values() → ValuesView[T]¶