Get Started with Snowflake in Postman

Number of APIs: 9

The Snowflake SQL API is a REST API to access and update data in a Snowflake database. You can use this API to execute standard SQL queries.

• The Quickstart folder walks through executing a SQL statement with the API and retrieving the results.
• The Polling folder walks through an example of executing a long-running SQL query, periodically checking if the query has completed, and then notifying you when it is completed.

In this collection, get started by exploring these API calls, and step through an example sequence of API calls. Then generate the client code to copy and paste your API requests into your own applications and integrations.

Get started

Update the following collection variables with your own required credentials. Setting collection variables allows you to re-use this data throughout every request in this collection.

Select the name of this collection Get Started with Snowflake in Qodex, tab over to Variables, and paste your own values under the CURRENT VALUE.

If you want to share this data with others, persist values under INITIAL VALUE in a team or public workspace. ⚠️ Do NOT do this if you want to keep this data private.

Additional resources

• Getting Started With Snowflake SQL API
• [Snowflake public workspace in Qodex]
• Configuring Key-pair authentication in Snowflake
• Watch the video below

1. Polling for Flows - Notification Copy POST https://postman-echo.com/post

2. Quickstart - Checks the status of the execution of a statement GET {{baseUrl}}/api/v2/statements/:statementHandle?requestId={{uuid}}

3. Quickstart - Cancels the execution of a statement POST {{baseUrl}}/api/v2/statements/:statementHandle/cancel?requestId={{uuid}}

4. Polling - SQL query by time POST {{baseUrl}}/api/v2/statements?requestId={{uuid}}&async=true

5. Polling - Checks the status GET {{baseUrl}}/api/v2/statements/:statementHandle?requestId={{uuid}}

6. Polling - Notification POST https://postman-echo.com/post

7. Polling for Flows - SQL query by time Copy POST {{baseUrl}}/api/v2/statements?requestId={{uuid}}&async=true

8. Polling for Flows - Checks the status Copy GET {{baseUrl}}/api/v2/statements/:statementHandle?requestId={{uuid}}

9. Quickstart - SQL query by rows POST {{baseUrl}}/api/v2/statements?requestId={{uuid}}&async=false