Snowflake Table API

Number of APIs: 19

The Snowflake Table API is a REST API that you can use to access, update, and perform certain actions on Tables resource in a Snowflake database.

Contact Support: Name: Snowflake, Inc. Email: support@snowflake.com

  1. api-v2-databases-{database}-schemas-{schema}-tables-{name} - Fetch a table. GET {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/:name

  2. api-v2-databases-{database}-schemas-{schema}-tables-{name}:as_select - Create a table using the result of the specified select query POST {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/{{name}}:as_select?createMode=errorIfExists&copyGrants=false&query=<string>

  3. api-v2-databases-{database}-schemas-{schema}-tables-{name}:using_template - Create a table using the templates specified in staged files POST {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/{{name}}:using_template?createMode=errorIfExists&copyGrants=false&query=<string>

  4. api-v2-databases-{database}-schemas-{schema}-tables-{name} - Create a (or alter an existing) table. PUT {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/:name

  5. api-v2-databases-{database}-schemas-{schema}-tables-{name} - Delete a table DELETE {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/:name?ifExists=false

  6. api-v2-databases-{database}-schemas-{schema}-tables-{name}:clone - Clone table POST {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/{{name}}:clone?createMode=errorIfExists&copyGrants=false&targetDatabase=m&targetSchema=m

  7. api-v2-databases-{database}-schemas-{schema}-tables-{name}:create_like - Create a table like this existing one POST {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/{{name}}:create_like?createMode=errorIfExists&copyGrants=false&newTableName=<string>

  8. api-v2-databases-{database}-schemas-{schema}-tables-{name}:create-like - Create a table like this existing one POST {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/{{name}}:create-like?createMode=errorIfExists&copyGrants=false

  9. api-v2-databases-{database}-schemas-{schema}-tables-{name}:undrop - Undrop a table POST {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/{{name}}:undrop

  10. api-v2-databases-{database}-schemas-{schema}-tables-{name}:suspend_recluster - Suspend recluster of a table POST {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/{{name}}:suspend_recluster?ifExists=false