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
Snowflake public workspace in Postman - workspace
Get Started with Snowflake in Postman - workspace
Configuring Key-pair authentication in Snowflake - docs
Смотрите видео Get started with Snowflake SQL API in Postman онлайн без регистрации, длительностью 14 минут 17 секунд в хорошем hd качестве. Это видео добавил пользователь Joyce Lin 18 Ноябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3 тысяч раз и оно понравилось 29 людям.