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.
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:
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.