Manage Tables¶

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

Snowflake REST Table API endpoints¶

Endpoint

Description

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

Lists the tables under the database and schema.

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

Creates a table.

POST /api/v2/databases/database/schemas/.schema/tables:as_select

Deprecated. Use the replacement endpoint below.

POST /api/v2/databases/database/schemas/.schema/tables:as-select

Creates a table using the result of the specified select query.

POST /api/v2/databases/database/schemas/.schema/tables:using_template

Deprecated. Use the replacement endpoint below.

POST /api/v2/databases/database/schemas/.schema/tables:using-template

Creates a table using the templates specified in staged files.

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

Fetches a table.

PUT /api/v2/databases/database/schemas/.schema/tables/name

Creates a new or alters an existing table.

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

Deletes a table.

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

Creates a new table by cloning from the specified resource.

POST /api/v2/databases/database/schemas/.schema/tables/name:create_like

Deprecated. Use the replacement endpoint below.

POST /api/v2/databases/database/schemas/.schema/tables/name:create-like

Creates a table like a specified one.

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

Undrops a table.

POST /api/v2/databases/database/schemas/.schema/tables/name:suspend_recluster

Deprecated. Use the replacement endpoint below.

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

Suspends a table reclustering action.

POST /api/v2/databases/database/schemas/.schema/tables/name:resume_recluster

Deprecated. Use the replacement endpoint below.

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

Resumes a suspended table reclustering action.

POST /api/v2/databases/database/schemas/.schema/tables/name:rename

Renames a table.

POST /api/v2/databases/database/schemas/.schema/tables/name:swapwith

Deprecated. Use the replacement endpoint below.

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

Swaps one table with another.

For reference documentation, see Snowflake Table API reference.