How to automate a sql script in snowflake

Question

I have a SQL script that transforms data for various tables in snowflake. I need to run this SQL code daily and I want to automate it somehow. I thought I could automate the SQL with 'tasks' in snowflake but 'tasks' are unable to run more than one single SQL statement and my code contains a multitude of SQL statements. Does anyone have any ideas? Any help is appreciated

Put the SQL in a Stored Procedure and then use a Task to run the SP — NickW
– NickW, Commented Feb 22, 2021 at 20:12
You can also have a task being dependent on the completion of another task. Might be an option if you're not dealing with too many statements. — Rajat
– Rajat, Commented Feb 22, 2021 at 22:24

Marcel · Accepted Answer · 2021-02-23 07:55:46Z

2

If you want to automate more than one sql statement, you have two options:

Run a task for each of your statements and build up dependencies between them
Wrap your whole script into a stored procedure and trigger this procedure with your task. The statement for triggering the procedure is something like CALL myProcedure(optional parameters);

answered Feb 23, 2021 at 7:55

Marcel

2,7001 gold badge7 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to automate a sql script in snowflake

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related