Snowflake Queries & Answers

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