topic Create Partition based on CDCT column in Qlik Replicate

Create Partition based on CDCT column

AnujGupta — Thu, 02 Nov 2023 15:15:48 GMT

Hello Team,

I am using data bricks Lakehouse delta connector & used CDCT column value as $AR_H_COMMIT_TIMESTAMP. I need to create a partition based on CDCT column with Year, Month, day. How is that possible using Qlik Replicate.

Version I am using November 2022 (2022.11.0.28)

Need below output in storage account location -

Re: Create Partition based on CDCT column

OritA — Fri, 03 Nov 2023 08:49:59 GMT

Hi,

Could you please open a case for this question and provide the details of the table DDL so we can provide you the relevant instruction accordingly.

Thanks & regards,

Orit

Re: Create Partition based on CDCT column

AnujGupta — Fri, 03 Nov 2023 09:26:21 GMT

Hi ,

I am using CDCT column $AR_H_COMMIT_TIMESTAMP.

It is populating data but in external location of ADLS it is not creating data based on partitions yyyy/mm/dd

Re: Create Partition based on CDCT column

AnujGupta — Mon, 06 Nov 2023 07:52:32 GMT

00123140: Create Partition based on CDCT column