Insert into multiple tables using stream & tasks
As per the official documentation, it depicts as though we can insert into multiple tables from a task. Which sounds inaccurate since
- Once consumed the offsets of the stream are reset
- It is possible to execute only one SQL statement from a task
am I missing something here? I want to be able to insert into 2 tables reading out of a stream through the task.
Solution
You can do this with a multi-table insert:
https://docs.snowflake.com/en/sql-reference/sql/insert-multi-table.html
- AGE between 2 dates in snowflake
- get date day full name in snowflake
- Resuming tasks: Unable to update graph with root task *XXXX* since that root task is not suspended
- Executing Multiple Lines in a Snowflake Task
- Is there a way to force run a Snowflake's TASK now (before the next scheduled slot)?
- how can I add datetime stamp to zip file when unload data from snowflake to s3?
- Return only last statement from Snowflake SQL query to R
- Convert MongoDB query to Snowflake
- Passing list of tuples as values inside a cte in Snowflake
- How to use copy Storage Integration in a Snowflake task statement?
- SNOWFLAKE querying the array of elements
- Regular Expression not working as expected in Snoflake python connector
- Grant monitor on snowflake task
- Snowflake task with CRON not scheduled
- STREAM not consumed from a task created by a stored procedure
- Facing classnotfound exception while reading a snowflake table using spark
- How to run snowflake side effect functions like SYSTEM$GENERATE_SCIM_ACCESS_TOKEN within a procedure with owner rights?
- Snowflake event based TASK Scheduling instead of Time Based task scheduling
- Snowflake Task ran ever minute of the hour
- Stream/Task can be used as ETL in warehouse solution or not
- Merge/Load same files in multiple folders in S3 into Snowflake
- Insert into multiple tables using stream & tasks
- Concatenation issues with in-built functions
- How to load 533 columns of data into snowflake table?
- Snowflake to S3 with Header
- Does snowflake has function LISTAGG(column_name [, delimiter] ON OVERFLOW TRUNCATE )?
- Bulk Load Timestamp Formatting
- Snowflake Not Accepting File Format In Bulk Load
- Snowflake pass dynamic value binding and constant value
- Snowflake - copy column headers for empty row