topic Re: Bug with Microsoft Fabric Data Warehouse target in Qlik Replicate

Bug with Microsoft Fabric Data Warehouse target

cn88 — Thu, 07 Mar 2024 05:23:11 GMT

Hi,

There is a bug with the new Microsoft Fabric Data Warehouse endpoint.

Data is loaded into Fabric by first staging it as a CSV in ADLS Gen2 storage account. The CSV file uses double quotes (") for its FIELDQUOTE parameter. If the string contained within contains a double quote, the load fails.

Is there an Advanced option that let's me change the FIELDQUOTE character?

Re: Bug with Microsoft Fabric Data Warehouse target

SushilKumar — Thu, 07 Mar 2024 08:03:10 GMT

Hello @cn88

Request you to share information about product involved to get the context.

Regards,

Sushil Kumar

Re: Bug with Microsoft Fabric Data Warehouse target

cn88 — Thu, 07 Mar 2024 12:27:18 GMT

Hi @SushilKumar, I don’t understand your question I’m sorry. This bug has been posted under the Qlik Replicate product. The issue lies with the Microsoft Fabric DW target endpoint. I’m not sure what other information you would need, given the very obvious nature of the bug.

Re: Bug with Microsoft Fabric Data Warehouse target

john_wang — Fri, 08 Mar 2024 03:39:46 GMT

Hello @cn88 ,

Thanks for reaching out to Qlik Community!

By default the FIELDQUOTE applies to CSV and its value is (") in MS world. In Qlik Replicate some endpoints eg file target, the default value is as same as MS docs. the quote can be controlled by:

csvStringQuote:"\"",

Unfortunately I cannot find this internal parameter in Microsoft Fabric Data Warehouse target endpoint. We need further investigation.

Please take note that In Qlik Replicate 2023.11, Microsoft Fabric is currently in Preview as it was developed and tested with Microsoft Fabric Public Preview, We'd like suggest you open a support ticket, our support team would like to trace this behavior deeper.

Hope this helps.

John.

Re: Bug with Microsoft Fabric Data Warehouse target

cn88 — Fri, 08 Mar 2024 06:08:58 GMT

Hi John,

Thanks for your reply. I have raised a support ticket.

Cheers,

Chris.

Re: Bug with Microsoft Fabric Data Warehouse target

john_wang — Fri, 08 Mar 2024 06:11:40 GMT

Thank you for your support Chris @cn88 ! I will look into the case.