Snowflake · Schema

Stage

A Snowflake stage.

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name Type Description
kind string Specifies whether the stage is permanent or temporary.
url string URL for the external stage; blank for an internal stage.
endpoint string The S3-compatible API endpoint associated with the stage; always NULL for stages that are not S3-compatible.
comment string Specifies a comment for the stage.
encryption object Encryption parameters of the stage.
directory_table object Directory table parameters of the stage.
created_on string Date and time when the stage was created.
has_credentials boolean Indicates that the external stage has access credentials; always false for an internal stage.
has_encryption_key boolean Indicates that the external stage contains encrypted files; always false for an internal stage.
owner string Role that owns the stage.
owner_role_type string The type of role that owns the object, either ROLE or DATABASE_ROLE. If a Snowflake Native App owns the object, the value is APPLICATION. Snowflake returns NULL if you delete the object because a dele
region string Region where the stage is located.
cloud string Cloud provider; always NULL for an internal stage.
View JSON Schema on GitHub