Bug with Microsoft Fabric Data Warehouse target

[cn88]

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?

[SushilKumar]

Hello @cn88 

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

Regards,

Sushil Kumar

[cn88]

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. 

[john_wang · Accepted solution]

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..., We'd like suggest you open a support ticket, our support team would like to trace this behavior deeper.

Hope this helps.

John.

[cn88]

Hi John,

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

Cheers,

Chris.

[john_wang]

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