Snowflake DW with non-select SQL

JHE86 — Wed, 15 Dec 2021 18:19:31 GMT

Hi all!

We would like to use some non-select sql with !EXECUTE_NON_SELECT_QUERY to create a temporary table in Snowflake side.

We have a table called DATA which contains integer column ID and some values there.

I have a script for load part as follows:

LIB CONNECT TO 'SNOWFLAKE_CONNECTION';

sql
CREATE TEMPORARY TABLE TEMP (ID INT) !EXECUTE_NON_SELECT_QUERY;

SQL
INSERT INTO TEMP SELECT ID FROM DATA !EXECUTE_NON_SELECT_QUERY;

It seems that with different DB than Snowflake, the session stays the same but with Snowflake, the second SQL is not run with within the same session thus giving us an error "ERROR [42S02] SQL compilation error: Table 'TEMP' does not exist or not authorized."

Any ideas how to make it so that the same session is used? Or are we looking at wrong place?

Thanks!

--JH

topic Snowflake DW with non-select SQL in Connectivity & Data Prep

Snowflake DW with non-select SQL