Week 119 – Hard

Have you ever created a lightweight data pipelne using the Snowflake REST APIs and Postman? If not, this is the challenge for you. We provide you all the information and steps to complete this challenge.

Step 1: Set up Snowflake REST API Access

Refer to the Snowflake GA REST API announcement blog to understand the API capabilities and configure your Snowflake account for REST API access. Then, enable API integration, and generate the required API token for secure authentication.

Step 2: Install and configure Postman

After having downloaded and installed Postman, create a collection in Postman for your Snowflake REST API calls.

Step 3: Make your first API call

Use Postman to send a simple GET request to verify your connection to Snowflake. Use the /system/health endpoint (or any other basic endpoint) and verify the response status is 200, confirming the Snowflake instance is healthy.

Final step: Create a simple data pipeline in three paces

1. Create a Table in Snowflake: Use the Snowflake REST API to send a SQL command that creates a new table.
2. Add data to the table: Insert some example data into your table using the API.
3. Retrieve from table: Use a SELECT query to fetch the data you just added.

Run these steps using Postman, and view the responses to confirm your pipeline is working!

Remember if you want to participate:

1. Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘ (note joining our mailing list does not give you a Frosty Friday account)
2. Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
3. Post the URL in the comments of the challenge.