Get started with Snowflake SQL API in Postman

Описание: 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. Learn how to work with the API in Postman. And then learn how to automate the process of checking the status of a long-running SQL query in Postman.

0:00 Start
0:28 Fork the collection for Snowflake SQL API v2
1:25 Fork the Get Started with Snowflake in Postman collection
2:30 Generate JWT access token in terminal
3:20 Enable authorization in Postman
5:10 Send first SQL statement
7:00 Inspect the API response
8:33 Check status of SQL statement with an API request
9:00 Polling to periodically check status of SQL statement
9:45 Send long-running SQL query (asynchronous)
10:37 Automate the process of checking the status of SQL statement by HTTP status code
11:50 Run the folder of API calls in the runner
13:20 Code generation to replicate API calls

---
Additional resources

A Postman Tutorial for the Snowflake SQL API - quickstart
https://quickstarts.snowflake.com/gui...

Snowflake public workspace in Postman - workspace
https://www.postman.com/snowflake/wor...

Get Started with Snowflake in Postman - workspace
https://www.postman.com/devrel/worksp...

Configuring Key-pair authentication in Snowflake - docs
https://docs.snowflake.com/en/user-gu...