Error 1: Failed to load one or more resources due to no access, error code 403. I checked with the answers here but they don't work for me. As the screenshots below suggest, I am the service administrator, owner and…
I'm trying to get a list of files from my sharepoint site in Azure Synapse Pipeline Activity. I'm using 2 web activities, the first one grabs the access token and the second one grabs the relative url: https://testsite.sharepoint.com/sites/Repository/_api/web/GetFolderByServerRelativeUrl('/sites/Repository/Shared%20Documents/General')/Files The second…
I have 100 dataflows ,50 pipelines and their related datasets variables etc. Now i want to use Synapse service and want my all pipelines amd stuff of ADF into Synapse. My Adf is git configured Can we export them in…
I'm trying to publish a reanaming pipeline and I'm getting this error and don't know how to deal with Error code: OK Inner error code: RenameDataFactoryResourceError Message: {"code":"InternalError","message":"Internal error has occurred.","target":null,"details":null,"error":null} I've already tried to rename the pipeline again but…
Me and my team are using Azure Synapse Analytics to ingest data from a REST API to a Azure Data Lake Storage Gen2, in order to create views automatically. The only way we could manage to do this in our…
In Azure Synapse pipeline I adjust loading from stage table to DWH on Azure Synapse SQL dedicated pool. I have a source table where one column has xml data stored in the column as text (nvarchar(max)). I need parse this…
I am working with Synpase Spark Pools in a controlled corporate environment. I have limited permission to query AAD but I can create UAMIs and assign them to Resources. When I access my Synpase workspace I can create a Spark…
I have a CSV File in the Following format which want to copy from an external share to my datalake: Test; Text "1"; "This is a text which goes on on a second line and on on a third line"…
The following code on Azure Synapse Serverless SQL Pool gives the following error: Incorrect syntax near 'DISTRIBUTION'. SELECT CM.EntityName, --Before the first column of each table, construct a DROP TABLE statement if already exist CASE WHEN CM.OrdinalPosition = 1 THEN…
In Azure Data Factory I created a pipeline with several copy data activities. As soon as one of them crashes I want that it continues to the next step and that it sends an e-mail with the error. The mail…