Table storage migration to sql Hello, We’ve got a table held in table storage that contains a value history dating back many many years. Looking at the analytics side, it holds over 0.5TiB. In this format, it’s useless unless you…
I have a Azure Synapse SQL workspace. I want it to: (a) read the data from Azure blob storage, (b) run the SQL query, and (c) write the output back to Azure blob. I got (a) and (b) above working…
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"…