Azure Synapse target - COPY INTO issue

[bilzekek]

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?

[bilzekek · Accepted solution]

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-id...

[KellyHobson]

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