Snowflake Dynamic Table API

The dynamic-table API from Snowflake — 10 operation(s) for dynamic-table.

Documentation GitHub OpenAPI

Operations 15

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/{database}/schemas/{schema}/dynamic-tables List dynamic tables in a schema · List dynamic tables #

Ask an LLM

“Which dynamic tables exist in this schema?”

“Can I get extra detail on each dynamic table with the deep option?”

Tell an agent

List the dynamic tables in schema {schema} of database {database}.

List dynamic tables with deep set to {deep}.

POST /api/v2/databases/{database}/schemas/{schema}/dynamic-tables Create a dynamic table · Create a dynamic table #

Ask an LLM

“How do I create a dynamic table that refreshes from a query automatically?”

“What target lag and warehouse does a new dynamic table need?”

Tell an agent

In {database}.{schema}, create dynamic table {name} from query {query} with target lag {lag} on warehouse {warehouse}.

Create dynamic table {name} using {query}, lag {lag}, warehouse {warehouse} and refresh mode {mode}.

GET /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name} Get the details of a dynamic table · Fetch a dynamic table #

Ask an LLM

“What query, target lag and scheduling state does a given dynamic table have?”

“Where can I read one dynamic table's definition and row count?”

Tell an agent

Show me the details of dynamic table {table} in {database}.{schema}.

Fetch the dynamic table's definition and refresh settings.

DELETE /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name} Drop a dynamic table · Delete a dynamic table #

Ask an LLM

“How do I drop a dynamic table I no longer need?”

“Will deleting a dynamic table fail if it's already gone?”

Tell an agent destructive · confirm first

Drop dynamic table {table} from {database}.{schema}.

Delete the dynamic table permanently.

POST /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:clone Clone a dynamic table · Clone dynamic table #

Ask an LLM

“Can I copy a dynamic table into another schema or database?”

“How do I clone a dynamic table as it was at an earlier point in time?”

Tell an agent

Clone dynamic table {table} in {database}.{schema} as {name}.

Clone the dynamic table into {database}.{schema} as {name}.

POST /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:undrop Restore a dropped dynamic table · Undrop a dynamic table #

Ask an LLM

“Can I recover a dynamic table I dropped by mistake?”

“Is there a way to undrop a dynamic table?”

Tell an agent

Undrop dynamic table {table} in {database}.{schema}.

Bring the dropped dynamic table back.

POST /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:suspend Pause refreshes on a dynamic table · Suspend refreshes on the dynamic table #

Ask an LLM

“How do I stop a dynamic table from refreshing for a while?”

“Can I suspend a dynamic table's scheduled refreshes to save warehouse credits?”

Tell an agent

Suspend refreshes on dynamic table {table} in {database}.{schema}.

Pause the dynamic table's automatic refresh schedule.

POST /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:resume Resume refreshes on a dynamic table · Resume refreshes on the dynamic table #

Ask an LLM

“How do I turn scheduled refreshes back on for a suspended dynamic table?”

“Can a paused dynamic table start refreshing again?”

Tell an agent

Resume refreshes on dynamic table {table} in {database}.{schema}.

Restart the dynamic table's refresh schedule.

POST /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:refresh Manually refresh a dynamic table · Refresh the dynamic table #

Ask an LLM

“Can I force a dynamic table to refresh right now instead of waiting for its target lag?”

“How do I trigger a one-off manual refresh?”

Tell an agent

Refresh dynamic table {table} in {database}.{schema} now.

Trigger a manual refresh on the dynamic table.

POST /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:suspend-recluster Pause automatic reclustering of a dynamic table · Suspend recluster of a dynamic table #

Ask an LLM

“How do I stop automatic clustering from running on a dynamic table?”

“Can I suspend reclustering without stopping the table's refreshes?”

Tell an agent

Suspend reclustering on dynamic table {table} in {database}.{schema}.

Turn off background recluster for the dynamic table.

POST /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:resume-recluster Resume automatic reclustering of a dynamic table · Resume recluster of a dynamic table #

Ask an LLM

“How do I turn automatic clustering back on for a dynamic table?”

“Can reclustering be restarted after I suspended it?”

Tell an agent

Resume reclustering on dynamic table {table} in {database}.{schema}.

Switch background recluster back on for the dynamic table.

POST /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:swap-with Swap a dynamic table with another · Swap with another dynamic table #

Ask an LLM

“Can I atomically swap two dynamic tables to promote a rebuilt version?”

“How do I exchange a dynamic table with one in another schema?”

Tell an agent

Swap dynamic table {table} in {database}.{schema} with {target}.

Swap the dynamic table with {target} in {database}.{schema}.

POST /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:set-tags Attach tags to a dynamic table · Set tags on a dynamic table #

Ask an LLM

“How do I apply governance tags to a dynamic table?”

“Can I set tag values on a dynamic table through the API?”

Tell an agent

Set tags on dynamic table {table} in {database}.{schema}.

Tag the dynamic table with our cost-center values.

POST /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:unset-tags Remove tags from a dynamic table · Unset tags from a dynamic table #

Ask an LLM

“How do I remove a tag from a dynamic table?”

“Can I clear tag assignments on a dynamic table without dropping the tag?”

Tell an agent

Unset the tags on dynamic table {table} in {database}.{schema}.

Strip the tag assignments off the dynamic table.

GET /api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:get-tags Show the tags assigned to a dynamic table · Get the tag assignments for a dynamic table #

Ask an LLM

“Which tags are assigned to this dynamic table?”

“Does listing a dynamic table's tags need an active warehouse?”

Tell an agent

Show every tag assigned to dynamic table {table} in {database}.{schema}.

Get the dynamic table's current tag assignments.

Snowflake Dynamic Table API

Operations 15

Documentation

Specifications

Schemas & Data

Other Resources

Work with this as data

MCP server

Tools for apis

Call it yourself

Get an API key

OpenAPI Specification