Snowflake Automation using SnowSql CLI || Create Azure Devops CI CD using Snowsql CLI
Hello Guys, I am writing this blog to understand how we can automate snowflake databases using CI CD pipelines in Devops, I am using Azure Devops tool to automate snowflake pipeline. To start it lets have a repository and create a folder inside like called Migrations and inside it create a .sql file or you can have multiple .sql files if you want to execute the multiple files. file1.sql -- create a table using a Sequence use role sysadmin; use database snowstages_db; use schema public ; create or replace table test ( Id integer default SEQ_1.nextval, name varchar ( 50 ), Dept_number int ); file2.sql -- create a clone table using first one use role sysadmin; use schema public ; Create transient table if not exists Test_Clone1 clone Test; Go inside the Library in Devops Portal and add Config variab...