Direct Query with Snowflake from QLIK SENSE ON-PREMISE

[duquenne]

Hi,

Does this new feature available for SAAS since last year is planned to be available soon (or already available in new release) on QLIK SENSE ON-PREMISE ?

Thanks

[marksouzacosta · Accepted solution]

Hi @duquenne,

Direct Query was introduced in Qlik Sense. In Qlik Cloud was implemented in a different way.

Here is the help link for Direct Query in Qlik Sense: Direct Query | Qlik Sense on Windows Help

And this is a sample code I did to connect to Snowflake in Qlik Sense using Direct Query:

LIB CONNECT TO 'SnowflakeDB (ipc_mark.costa)';

SQL USE ROLE ACCOUNTADMIN;

[CUSTOMER]:
DIRECT QUERY
DIMENSION
 "C_CUSTKEY",
 "C_NAME",
 "C_ADDRESS",
 "C_NATIONKEY",
 "C_PHONE",
 "C_ACCTBAL",
 "C_MKTSEGMENT"
DETAIL
 "C_COMMENT"
FROM
 "SNOWFLAKE_SAMPLE_DATA"."TPCH_SF10"."CUSTOMER"
;

Regards,

Mark Costa

[duquenne]

perfect, thanks!