topic Re: Azure Synapse target - COPY INTO issue in Qlik Replicate

Azure Synapse target - COPY INTO issue

bilzekek — Mon, 21 Nov 2022 10:08:28 GMT

Hi,

I wanted to test the new features for Qlik Replicate target, Azure Synapse Analytics. Specifically, the new "Data Loading" end-point settings. I selected "COPY statement" as load data using option;

When running a test with these end-point settings, I receive the following error:

I can see that Replicate were able to copy files to the Data lake (Staging on Azure), but when running the "COPY INTO" SQL statement on the Dedicated SQL pool, it was not allowed to read the files.

Is there some additional access on the Data Lake that should be granted to the user added under ODBC Access in the end-point? and if so, which is it?

Re: Azure Synapse target - COPY INTO issue

bilzekek — Mon, 21 Nov 2022 11:26:19 GMT

Update: Apparently, I was missing managed identity access between the Synapse workspace and the storage account container, which should have been created when I configued the Synapse Workspace but somehow wasn't.

So not related to Replicate, but in case others are facing same issue, I followed this guide to fix it: https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-grant-workspace-managed-identity-permissions

Re: Azure Synapse target - COPY INTO issue

KellyHobson — Mon, 21 Nov 2022 14:13:04 GMT

Hey @bilzekek ,

We appreciate you following up with the resolution for this issue. It is helpful for others on the community page!

All the best,

Kelly