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

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Stage",
  "type": "object",
  "description": "A Snowflake stage.",
  "properties": {
    "kind": {
      "type": "string",
      "description": "Specifies whether the stage is permanent or temporary."
    },
    "url": {
      "type": "string",
      "description": "URL for the external stage; blank for an internal stage."
    },
    "endpoint": {
      "type": "string",
      "description": "The S3-compatible API endpoint associated with the stage; always NULL for stages that are not S3-compatible."
    },
    "comment": {
      "type": "string",
      "description": "Specifies a comment for the stage."
    },
    "encryption": {
      "type": "object",
      "description": "Encryption parameters of the stage."
    },
    "directory_table": {
      "type": "object",
      "description": "Directory table parameters of the stage."
    },
    "created_on": {
      "type": "string",
      "description": "Date and time when the stage was created."
    },
    "has_credentials": {
      "type": "boolean",
      "description": "Indicates that the external stage has access credentials; always false for an internal stage."
    },
    "has_encryption_key": {
      "type": "boolean",
      "description": "Indicates that the external stage contains encrypted files; always false for an internal stage."
    },
    "owner": {
      "type": "string",
      "description": "Role that owns the stage."
    },
    "owner_role_type": {
      "type": "string",
      "description": "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 deleted object does not have an owner role."
    },
    "region": {
      "type": "string",
      "description": "Region where the stage is located."
    },
    "cloud": {
      "type": "string",
      "description": "Cloud provider; always NULL for an internal stage."
    }
  }
}