@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
