Snowflake · Schema

Stage

A Snowflake stage.

SnowflakeDataData WarehouseData LakehouseCloud Data PlatformAnalyticsArtificial IntelligenceData EngineeringData GovernanceSQLApache IcebergMCPT1

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

stage-stage-schema.json Raw ↑
{
  "$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."
    }
  }
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this
  • find_json_schemasBrowse and filter every JSON Schema in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/stage-stage"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.