Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,434 questions
1 answer
One of the answers was accepted by the question author.
Synape managed private endpoint is in refreshing state
Hello, In synapse studio managed private endpoints stuck in refreshing state. Do you know what is causing the issue here?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 13%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
2 answers
Connecting from Synapse Managed private endpoint to an Application Gateway Private Link Configuration
Is it possible to connect to an Application Gateway, which has a Private Link Configuration set (see https://learn.microsoft.com/en-us/azure/application-gateway/private-link-configure?tabs=portal), through a Synapse managed private endpoint? Currently,…
asked 2022-07-28T11:26:35.857+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 37%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
Erwin Kramer
6
Reputation points
commented 2024-05-15T20:27:34.0733333+00:00
Erwin Kramer
6
Reputation points
0 answers
self-hosted integration from sharepoint to synapse
Hello, I successfully connect my synapse to file system by setting up self-hosted integration. However, previous I would like to connect my sharepoint to synapse but it keeps on having this error. We investigated, was wondering if we also need…
asked 2024-05-15T12:47:22.0833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 2%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENW%3C/text%3E%3C/svg%3E)
Nick Wong
110
Reputation points
edited a comment 2024-05-15T18:31:17.2033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
26,761
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How to fix Resource provisioning failed. Please check deployment status for more details. in Synapse
Hi All, I ahve a synpase workspace.Currently I tried to add a user managed identiy to it so that I can use that for a pipeline .After that process was initiated it never completed the process and I see this error on the workspace
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
2 answers
How can I scan views from the same Azure Synapse Analytics schema to multiple collections?
I have multiple collections in Microsoft Purview. I have registered an Azure Synapse Analytics source to a parent collection. Depending on the ownership of the datasets I need to scan in views from the same schema to different collections. When I scan…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 69%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
0 answers
how to retrieve the path to workspace_publish branch OR any branch in devops , use that path in azure powershell script to read file from that branch.
I want to retrieve path to the branch and folder inside it, basically i wan to read the jsons here and change the dev keyword with uat and save the file back to the sam folder in workspace_publish branch. I can change dev to uat, but am not able to…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 24%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Pass value from an array selectively to For Each
Hi, I have a parent pipeline that captures values in an array - ArrayFullLoadData. Currently ArrayFullLoadData have three values [A,B,C] and the same is passed to a ForEach with @pipeline.parameters.ArrayFullLoadData. Inside ForEach, values A, B,C are…
asked 2024-05-03T19:53:04.3366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 51%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kumar, Arun
316
Reputation points
accepted 2024-05-15T13:12:14.4166667+00:00
Kumar, Arun
316
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Synapse Analytics Workspace connector in power bi is not connecting, are there system issues? It was working fine yesterday.
I am unable to view data in power bi using the "azure synapse analytics workspace" connector, the navigator view just spins forever. IS there an issue with the service? It was working yesterday and there have been no changes to our…
asked 2024-05-08T12:48:44.5133333+00:00
Seth Coleman
26
Reputation points
accepted 2024-05-15T12:46:48.9733333+00:00
Seth Coleman
26
Reputation points
1 answer
One of the answers was accepted by the question author.
connecting linked services error from sharepoint to synapse
Hello, Just wondering what else I could do if I get this error, I have all the correct information provided but flagged up with this error. An error occurred while sending the request.
0 answers
rename of pipeline failed part-way, now I have both source and destination pipeline and cant remove them
Hi we have a pipeline A that was being renamed to pipeline B, and the rename has failed. now we have pipeline A with an EntityState of "Deleting", and Pipeline B with an EntityState of "Creating". they are linked by Source and Target…
asked 2024-05-08T15:53:18.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 65%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Robert Vaughan
0
Reputation points
edited a comment 2024-05-15T11:10:31.1433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
6,400
Reputation points Microsoft Vendor
1 answer
Cancel reservation - synapse dedicated pool
I am reaching out to seek the community's assistance in understanding the process for cancelling our reservation. We have reserved the Synapse dedicated pool for 3 years and have completed 18 months. Is it possible to cancel this reservation? Also, we…
asked 2024-05-14T12:48:42.4066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 71%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sushil Kumar
0
Reputation points
edited a comment 2024-05-15T11:01:41.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
10,325
Reputation points Microsoft Vendor
1 answer
Synapse Serverless SQL request keeps running forever when using pyodbc connection
Synapse Serverless SQL request keeps running forever when I try to connect its database through pyodbc connection and make the request 'Create Schema XXX' remotely. There is no option available to stop or abort the process through the synapse workspace. …
asked 2024-05-15T09:14:24.3433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 52%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFQ%3C/text%3E%3C/svg%3E)
Feng, QingTang
0
Reputation points
answered 2024-05-15T10:30:22.07+00:00
PRADEEPCHEEKATLA-MSFT
78,581
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Where to find the authenication keys under synpase?
Hello, I would like to register synpase, when I go to synpase under Azure portal, I cannot see anything related authenication key, only see the object key etc. and what would the http proxy will be? I dont think i see anything in the documentation to…
1 answer
Workspace is in non-terminal state Failed and cannot be updated
Hello, I was working on creating a new workspace in Azure Synapse Analytics. During deployment, error is encountered. I tried to delete and re-create the workspace but same error. Tried to re-deploy, still error persisted. Any advice? Workspace is in…
asked 2024-05-09T18:04:49.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 32%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Arlene Aguinaldo
0
Reputation points Microsoft Employee
commented 2024-05-15T07:33:14.79+00:00
Smaran Thoomu
10,325
Reputation points Microsoft Vendor
1 answer
databricks integration with synapse
hey, is there any third party tool is available which will integrate synapse with databricks
asked 2024-05-13T16:06:41.3633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
185
Reputation points
commented 2024-05-15T07:31:36.71+00:00
Smaran Thoomu
10,325
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
ADLS Gen2 operation failed: Operation returned an invalid status code Conflict. Account: 'x' endpoint does not support BlobStorageEvents or SoftDelete
Currently setting up a storage account for a synapse analytics workspace, there is an existing synapse workspace with a linked service to an azure storage account, When I tried to setup a similar configuration I get the error message below. Here it…
asked 2024-05-09T00:21:35.9433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 39%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MrFlinstone
501
Reputation points
accepted 2024-05-15T07:15:59.1133333+00:00
MrFlinstone
501
Reputation points
1 answer
One of the answers was accepted by the question author.
Synapse Spark v3.4 CREATE DATABASE testdb LOCATION '<>' Not working on Spark 3.4
Executing the following statement on Apache Spark runtime 3.4 results in an error. Tried to do this on different vanilla spark pool configurations on different tennants in West Europe. database_name = 'test_sppool34' target_location =…
asked 2024-04-12T11:58:34.6166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 84%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Arthur Steijn
51
Reputation points
accepted 2024-05-15T05:55:25.79+00:00
Arthur Steijn
51
Reputation points
0 answers
how to link rest api in azure synapse for hubspot with OAuth 2.0 authentication
When I use the same Api endpoint in postman I get the access token, refresh token and the authentication is successful. I can see the data which I'm trying to extract.
asked 2024-05-14T00:09:51.0366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 23%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Abhishek Singh
0
Reputation points
commented 2024-05-15T05:31:18.85+00:00
Abhishek Singh
0
Reputation points
0 answers
How do i integrate my hubspot account in azure synapse to extract the customer details from the data pipeline?
I linked the hubspot account into the azure synapse data but when i click on data preview it has some missing columns which i need to extract. I want to access the full customer details from hubspot into the data pipeline.
asked 2024-05-13T03:02:02.5133333+00:00
Abhishek Singh
0
Reputation points
commented 2024-05-15T05:24:44.73+00:00
phemanth
6,400
Reputation points Microsoft Vendor
0 answers
ADF Copy Activity failed with ORA-00928: missing SELECT keyword
ADF Copy activity is failing with following error. Its happening after copying certain amount of data. So don't think its issue with pipeline. Also same pipeline works in another environment(PROD/DEV) so mostly its data issue. How to identify what is…
asked 2024-05-13T04:46:02.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 96%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Vivek, Anand
20
Reputation points
commented 2024-05-15T05:06:49.5666667+00:00
ShaikMaheer-MSFT
38,046
Reputation points Microsoft Employee