topic Override Snowflake TIMESTAMP_TYPE_MAPPING parameter via Qlik session? in Qlik Replicate

Override Snowflake TIMESTAMP_TYPE_MAPPING parameter via Qlik session?

qlik_admin_lm — Mon, 15 Jul 2024 16:54:33 GMT

We are using Qlik Replicate to write change records to a Snowflake target. We are wondering if there is a way to utilize the TIMESTAMP_TYPE_MAPPING session parameter in Snowflake from within our Qlik Replicate Session. Qlik translates TIMESTAMP columns to TIMESTAMP in Snowflake and the default value for our Account for TIMESTAMP_TYPE_MAPPING is TIMESTAMP_NTZ. Wondering if it's possible to set the session parameter to TIMESTAMP_LTZ in the Qlik target endpoint somehow.

Re: Override Snowflake TIMESTAMP_TYPE_MAPPING parameter via Qlik session?

john_wang — Mon, 15 Jul 2024 23:10:27 GMT

Hello @qlik_admin_lm ,

Thanks for reaching out to Qlik Community!

If my memory serves me well, Qlik Replicate map the DATETIME in source DB to TIMESTAMP_NTZ(6) in Snowflake, this is the default setting.

If you still want to change the data type mapping, there are many options:

1. Utilizes the Global Transformation or table level transformation

2. Change the syntax, this is the example for MySQL. You may apply the similar datatype mapping in Snowflake

3. Execute "ALTER SESSION" clause in Qlik Replicate session

Hope this helps.

John.

Re: Override Snowflake TIMESTAMP_TYPE_MAPPING parameter via Qlik session?

qlik_admin_lm — Tue, 16 Jul 2024 22:06:22 GMT

Thanks for the reply John,

Can you tell me how to execute an "ALTER SESSION" from Qlik Replicate. That is what I'm trying to understand.

Thanks.

Re: Override Snowflake TIMESTAMP_TYPE_MAPPING parameter via Qlik session?

qlik_admin_lm — Tue, 16 Jul 2024 23:42:41 GMT

Looks like I need to use the afterConnectScript Internal parameter?

Re: Override Snowflake TIMESTAMP_TYPE_MAPPING parameter via Qlik session?

john_wang — Tue, 16 Jul 2024 23:44:31 GMT

Hello @qlik_admin_lm ,

You are right. you may execute set clause in afterConnectScript .

Regards,

John.