Snowflake & CI/CD

Johan
2 min readDec 2, 2023

My case for CI/CD in Snowflake is very specific: every 30 days I register for a new Snowflake 30 day trial, to run several experiments. When spinning up this new environment, it contains only the bare necessities: some roles (ACCOUNTADMIN, SYSADMIN, etc) and some databases (DEMO_DB plus the shared SNOWFLAKE databases).

So, my experiment can now start. It contains of a lot of SQL scripts that I need every time in my new Snowflake account.

For this I have chosen the most basic approach I can think of. Some people would call it an MVP :)

--

--

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