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?