Working with 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/d`.`ynamic-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.