snowflake.core.schema.SchemaCollection¶

class snowflake.core.schema.SchemaCollection(database: DatabaseResource)¶

Bases: ObjectCollection[SchemaResource]

Attributes

database¶

root¶

Methods

__init__(database: DatabaseResource) → None¶

create(schema: ModelSchemaModel, *, clone: str | CloneModel | None = None, mode: CreateMode = CreateMode.error_if_exists, kind: str = '') → SchemaResource¶

Create a schema in Snowflake.

Parameters:

• schema – an instance of Schema.

• mode –

  One of the following strings. CreateMode.error_if_exists: Throw an snowflake.core.exceptions.ConflictError if the schem already exists in Snowflake. Equivalent to SQL create schema <name> ....

  CreateMode.or_replace: Replace if the schema already exists in Snowflake. Equivalent to SQL create or replace schema <name> ....

  CreateMode.if_not_exists: Do nothing if the schema already exists in Snowflake. Equivalent to SQL create schema <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) → PagedIter[ModelSchemaModel]¶

Look up schemas in Snowflake.

keys() → KeysView[str]¶

values() → ValuesView[T]¶