Manage dynamic tables¶

The Dynamic Table API provides the following endpoints to manage Snowflake dynamic tables:

Snowflake Dynamic Table API endpoints¶

Endpoint

Description

GET /api/v2/databases/database/schemas/.schema/dynamic-tables

Lists the dynamic tables under the database and schema.

POST /api/v2/databases/database/schemas/.schema/dynamic-tables

Creates a dynamic table with standard create modifiers as query parameters.

GET /api/v2/databases/database/schemas/.schema/dynamic-tables/name

Fetches a dynamic table.

DELETE /api/v2/databases/database/schemas/.schema/dynamic-tables/name

Deletes a dynamic table with the given name.

POST /api/v2/databases/database/schemas/.schema/dynamic-tables/name:clone

Creates a new dynamic table by cloning from the specified resource.

POST /api/v2/databases/database/schemas/.schema/dynamic-tables/name:undrop

Undrops a dynamic table.

POST /api/v2/databases/database/schemas/.schema/dynamic-tables/name:suspend

Suspends refreshes on the specified dynamic table.

POST /api/v2/databases/database/schemas/.schema/dynamic-tables/name:resume

Resumes refreshes on the specified dynamic table.

POST /api/v2/databases/database/schemas/.schema/dynamic-tables/name:refresh

Specifies that the specified dynamic table should be manually refreshed.

POST /api/v2/databases/database/schemas/.schema/dynamic-tables/.name:suspend-recluster

Suspends reclustering of the specified dynamic table.

POST /api/v2/databases/database/schemas/.schema/dynamic-tables/.name:resume-recluster

Resumes reclustering of the specified dynamic table.

POST /api/v2/databases/database/schemas/.schema/dynamic-tables/name:swap-with

Swaps with another dynamic table.

For reference documentation, see Snowflake Dynamic Table API reference.