Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
JHE86
Partner
Partner

Snowflake DW with non-select SQL

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

Labels (2)
0 Replies