snowflake.core.stage.StageCollection¶

class snowflake.core.stage.StageCollection(schema: SchemaResource)¶

Bases: SchemaObjectCollectionParent[StageResource]

Attributes

database¶

root¶

schema¶

Methods

__init__(schema: SchemaResource)¶

create(stage: Stage, *, mode: CreateMode = CreateMode.error_if_exists) → StageResource¶

Create a stage.

Parameters:

• stage – The stage object, together with the stage’s properties, object parameters.

• mode –

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

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

  CreateMode.if_not_exists: Do nothing if the stage already exists in Snowflake. Equivalent to SQL create stage <name> if not exists...

  Default value is CreateMode.error_if_exists.

items() → ItemsView[str, T]¶

iter(*, like: str | None = None) → Iterator[Stage]¶

Search Stage objects from Snowflake.

Parameters:

like – The pattern of the Stage name. Use % to represent any number of characters and ? for a single character.

keys() → KeysView[str]¶

values() → ValuesView[T]¶