Qlik replicate converting Oracle Timestamp to String in Snowflake

vkura — Fri, 11 Mar 2022 17:55:53 GMT

Hi Team,

We are using Qlik Enterprise Manager to replicate data from Oracle to Snowflake and it automatically converting datatype from Timestamp LTZ to String in Snowflake. Please refer to the below attachments to resolve the issue.

Thank you,

Vinil

Re: Qlik replicate converting Oracle Timestamp to String in Snowflake

Heinvandenheuvel — Mon, 14 Mar 2022 15:10:24 GMT

@vkura wrote:

We are using Qlik Enterprise Manager to replicate data from Oracle to Snowflake

No you are not. 🙂

You are using the Enterprise Manager to create and manage a Replicate task.

Any issues with the inner working of that task is best discussed in the "replicate" sub-forum parallel to this forum also under "data Integration"

and it automatically converting datatype from Timestamp LTZ to String in Snowflake.

So it will create a string like "2022-03-04 15:19:17.885607" . Is that what is needed? If not, tell it how you would like to do the transform, what the timestamp as string should look like. This is done through an transformation under the "Fx" option with the datetime function strftime. ( https://www.sqlite.org/lang_datefunc.html )

>> Please refer to the below attachments to resolve the issue.

What issue?

UPDATE: I initially did not recognize that the issue was that Replicate forces a string where timestamp with timezone was the Oracle source datatype. This datatype is also available as datatype on the snowflake target and was desired, but apparently Replicate does not support that today. This action/restriction is documented in the Replicate User Guide under Oracle as Source.

hope this helps.

Hein

topic Re: Qlik replicate converting Oracle Timestamp to String in Snowflake in Qlik Replicate

Qlik replicate converting Oracle Timestamp to String in Snowflake

Re: Qlik replicate converting Oracle Timestamp to String in Snowflake