Snowflake — CI/CD tooling

Johan
2 min readMay 16, 2024

TL/DR; take a look at my Python CI/CD tool for Snowflake: SFexecute. Put the SQL you want to execute in a folder, run the script and all the SQL will be executed in your Snowflake account.

Photo by Michael Dziedzic on Unsplash

Wrote about the CI/CD subject earlier, specifically about my pet project. Goal of this project was, after launching Snowflake trial number 20 or so, to ease my onboarding for the trial.

Things I did every time with every trial:

  • create a set of users
  • same for warehouses
  • same for roles
  • same for SQL scripts for testing/developing stuff

In my post I described some parts of my Python script I used for this purpose. In the mean time, I have published this script in a GIT repo:

SFExecute

Put the SQL you want to execute in a folder, run the script and all the SQL will be executed in your Snowflake account.

Feel free to use this, give me some feedback, fork the project, submit a pull request, etc.

Alternatively, we could use this GIT Preview feature. This + in the top of Snowsight is a very nice addition:

I will be testing this to see if is a good alternative for my specific scenario.

--

--

Johan

I am a freelance data engineer. My main focus is Snowflake, but I am always eager to learn new things. Python and AWS are my main side interests