How would a user execute a series of SQL statements using a task?

Question

Options

• AInclude the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO
• BA stored procedure can have only one DML statement per stored procedure invocation and
• CUse a stored procedure executing multiple SQL statements and invoke the stored procedure from
• DCreate a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of

• B
  3% (1)
• C
  94% (30)
• D
  3% (1)

Explanation

To execute a series of SQL statements using a task, a user would use a stored procedure that contains multiple SQL statements and invoke this stored procedure from the task. References: Snowflake Documentation.

No community discussion yet for this question.