GitHub Actions workflow for Snowflake object changes

Toboggan slop in Rouge Park, Toronto ON, Jan 25 2024

In this post we are adding a simple CICD workflow on top of what we’ve discussed in a previous blog: Snowflake Dev env using VSCode.

1 In VSCode, connect Snowflake Dev account and do code changes, test the changes in Dev account

Modify and test code in Snowflake Dev account

We have a file called task.sql which creates tasks in Snowflake. After modifying task schedule period from 1 min to 5 min, we’ll commit code to local, push to GitHub dev_branch and then log a PR.

Commit code changes to local

Push to GitHub dev_branch

Log a PR: dev_branch -> main using GitLens extension