topic Re: Direct Query with Snowflake from QLIK SENSE ON-PREMISE in Connectivity & Data Prep

Direct Query with Snowflake from QLIK SENSE ON-PREMISE

duquenne — Wed, 26 Jun 2024 15:42:04 GMT

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

Re: Direct Query with Snowflake from QLIK SENSE ON-PREMISE

marksouzacosta — Wed, 26 Jun 2024 16:29:51 GMT

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

Re: Direct Query with Snowflake from QLIK SENSE ON-PREMISE

duquenne — Wed, 26 Jun 2024 16:57:56 GMT

perfect, thanks!