![sql - Snowflake how can we loop over each row of a temp table and insert its values with into another table where each field with its value is a single row? - sql - Snowflake how can we loop over each row of a temp table and insert its values with into another table where each field with its value is a single row? -](https://i.stack.imgur.com/A9cIj.png)
sql - Snowflake how can we loop over each row of a temp table and insert its values with into another table where each field with its value is a single row? -
Support temp tables in Snowflake "table" materializations · Issue #2725 · dbt-labs/dbt-core · GitHub
![Snowflake: provide the option to use temporary tables instead of transient tables · Issue #1747 · great-expectations/great_expectations · GitHub Snowflake: provide the option to use temporary tables instead of transient tables · Issue #1747 · great-expectations/great_expectations · GitHub](https://user-images.githubusercontent.com/22968861/88987369-91b37b00-d28a-11ea-8e00-c032c0034485.png)