Snowflake

Snowflake Database API

The database API from Snowflake — 12 operation(s) for database.

GitHub OpenAPI

Operations 18

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

GET /api/v2/databases List the databases I can access · List databases #
Ask an LLM
“Which Snowflake databases does my role have access to?”
“Can I see dropped databases that haven't been purged yet in the database list?”
Tell an agent
List all the databases I can access.
List my databases with history set to {history} so dropped ones show up too.
POST /api/v2/databases Create a new database · Create a database #
Ask an LLM
“How do I create a new database through the REST API?”
“Can I make a transient database instead of a permanent one when creating it?”
Tell an agent
Create a database named {name}.
Create a {kind} database called {name} with {days} days of data retention.
POST /api/v2/databases:from-share Create a database from a data share · Create a database from a share #
Ask an LLM
“How can I turn a data share someone gave me into a database I can query?”
“What do I need to mount an inbound share as a new database?”
Tell an agent
Create a database named {name} from the share {share}.
Mount inbound share {share} as a new database.
POST /api/v2/databases/{name}:from_share Create a database from a share (legacy endpoint) · Create a database from a share #
Ask an LLM
“Is there an older from_share endpoint that puts the database name in the URL path?”
“Does the deprecated create-from-share route still work for existing integrations?”
Tell an agent
Use the legacy from_share endpoint to create database {database} from share {share}.
Call the deprecated path-based route to build a database out of share {share}.
POST /api/v2/databases/{name}:clone Clone an existing database · Clone a database #
Ask an LLM
“How do I make a zero-copy clone of one of my databases?”
“Can I clone a database as it looked at an earlier point in time?”
Tell an agent
Clone database {source} into a new one named {name}.
Clone the database as of {point_of_time} into a copy called {name}.
GET /api/v2/databases/{name} Get the details of a database · Fetch database #
Ask an LLM
“What are the owner, retention time and other properties of a specific database?”
“Where can I look up one database's full definition?”
Tell an agent
Show me the details of database {database}.
Fetch the definition of the named database, including its owner and comment.
PUT /api/v2/databases/{name} Create or update a database definition · Create a new, or alters an existing, database #
Ask an LLM
“Can I change an existing database's properties by sending its full definition?”
“Which call creates a database if missing or alters it if it already exists?”
Tell an agent
Create or alter database {database} so its retention is {days} days.
Update database {name} with the log level {log_level}, creating it if needed.
DELETE /api/v2/databases/{name} Drop a database · Delete a database #
Ask an LLM
“How do I drop a database I no longer need?”
“Can I stop a database from being dropped if other objects still reference it?”
Tell an agent destructive · confirm first
Drop database {database}.
Delete the database with restrict set to {restrict}.
POST /api/v2/databases/{name}:undrop Restore a dropped database · Undrop a database #
Ask an LLM
“Can I bring back a database I accidentally dropped?”
“Is it possible to recover a deleted database while it's still in Time Travel?”
Tell an agent
Undrop database {database} that I just deleted.
Restore the dropped database back to active use.
POST /api/v2/databases/{name}/replication:enable Enable replication of a database to accounts · Enable database replication #
Ask an LLM
“How do I make a database a primary so other accounts can hold replicas of it?”
“Can I skip the edition check when turning on database replication?”
Tell an agent
Enable replication of database {database} to accounts {accounts}.
Promote this database to a replication primary for {accounts} with ignore_edition_check {ignore}.
POST /api/v2/databases/{name}/replication:disable Disable replication of a primary database · Disable database replication #
Ask an LLM
“How do I stop secondary databases in other accounts from being refreshed from this primary?”
“What happens to existing replicas when I turn database replication off?”
Tell an agent
Disable replication of primary database {database} for accounts {accounts}.
Stop replicating this database to {accounts}.
POST /api/v2/databases/{name}/replication:refresh Refresh a secondary database from its primary · Refresh database replications #
Ask an LLM
“How do I pull the latest snapshot of the primary into my replica database?”
“What happens if I refresh a secondary database while another refresh is already running?”
Tell an agent
Refresh secondary database {database} from its primary.
Sync my replica database with the newest snapshot of the primary.
POST /api/v2/databases/{name}/failover:enable Allow accounts to fail over a database · Enable database failover #
Ask an LLM
“Which accounts can promote a replica of this database to primary, and how do I set that?”
“How do I set up failover targets for a primary database?”
Tell an agent
Enable failover of database {database} to accounts {accounts}.
Let {accounts} promote their replica of this database to primary.
POST /api/v2/databases/{name}/failover:disable Disable failover for a primary database · Disable database failover #
Ask an LLM
“How do I stop replicas of a database from being promoted to primary?”
“Can I revoke failover rights from specific accounts for one database?”
Tell an agent
Disable failover of database {database} for accounts {accounts}.
Remove {accounts} from the database's failover targets.
POST /api/v2/databases/{name}/failover:primary Promote a replica database to primary · Set a primary database #
Ask an LLM
“How do I promote my secondary database so it becomes the writeable primary?”
“What happens to the old primary database when a replica takes over?”
Tell an agent
Fail over to replica database {database} and make it the primary.
Promote the secondary database in this account to primary.
POST /api/v2/databases/{name}:set-tags Attach tags to a database · Set tags on a database #
Ask an LLM
“How do I apply governance tags to a database?”
“Can I set tag values on a database through the REST API?”
Tell an agent
Set tags on database {database}.
Tag the database with our data classification values.
POST /api/v2/databases/{name}:unset-tags Remove tags from a database · Unset tags from a database #
Ask an LLM
“How do I remove a tag I previously set on a database?”
“Can I clear tag assignments from a database without dropping the tag itself?”
Tell an agent
Unset the tags on database {database}.
Strip the tag assignments off the database.
GET /api/v2/databases/{name}:get-tags Show the tags assigned to a database · Get the tag assignments for a database #
Ask an LLM
“Which tags are currently assigned to this database?”
“Does reading a database's tag assignments need an active warehouse?”
Tell an agent
Show me every tag assigned to database {database}.
Get the database's current tag assignments.

Documentation

📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/account
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/alert
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/api-integration
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/catalog-integration
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/compute-pool
📖
Documentation
https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-analyst/rest-api
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/cortex-inference
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/cortex-search-service
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/database-role
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/database
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/dynamic-table
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/event-table
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/external-volume
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/function
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/grant
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/iceberg-table
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/image-repository
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/managed-account
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/network-policy
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/notebook
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/notification-integration
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/pipe
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/procedure
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/result
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/role
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/schema
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/service
📖
Documentation
https://docs.snowflake.com/en/developer-guide/sql-api/index
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/stage
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/stream
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/table
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/task
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/user-defined-function
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/user
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/view
📖
Documentation
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/warehouse

Specifications

⚙
OpenAPI
https://artifacts.apis.io/snowflake/openapi/snowflake-database-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://artifacts.apis.io/snowflake/json-schema/snowflake-database-schema.json
📊
JSONSchema
https://artifacts.apis.io/snowflake/json-schema/snowflake-warehouse-schema.json

Other Resources

🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/account-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/alert-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/api-integration-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/catalog-integration-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/compute-pool-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/cortex-analyst-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/cortex-inference-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/cortex-search-service-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/database-role-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/database-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/dynamic-table-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/event-table-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/external-volume-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/function-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/grant-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/iceberg-table-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/image-repository-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/managed-account-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/network-policy-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/notebook-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/notification-integration-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/pipe-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/procedure-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/role-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/schema-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/service-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/sqlapi-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/snowflake-sql-rest-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/stage-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/stream-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/table-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/task-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/user-defined-function-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/user-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/view-context.jsonld
🔗
JSONLD
https://artifacts.apis.io/snowflake/json-ld/warehouse-context.jsonld
🔗
Overlay
https://artifacts.apis.io/snowflake/overlays/snowflake-database-overlay.yaml

Work with this as data

Every API 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 apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • 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 API 
curl "https://apis.io/api/v1/apis/snowflake:snowflake-database-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

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.

GitHub Google LinkedIn

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

OpenAPI Specification

snowflake-database-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  version: 0.0.1
  title: Snowflake Database API
  description: The Snowflake Database API is a REST API that you can use to access, update, and perform certain actions on Database resource in Snowflake.
  contact:
    name: Snowflake, Inc.
    url: https://snowflake.com
    email: support@snowflake.com
servers:
- description: Snowflake Database API
  url: https://org-account.snowflakecomputing.com
security:
- KeyPair: []
- ExternalOAuth: []
- SnowflakeOAuth: []
- ProgrammaticAccessToken: []
tags:


# --- truncated at 32 KB (37 KB total) ---
# Full source: https://artifacts.apis.io/snowflake/openapi/snowflake-database-api-openapi.yml