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,437 questions
1 answer
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
![](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
edited a comment 2024-05-17T04:39:21.9366667+00:00
Abhishek Singh
0
Reputation points
2 answers
Brijlaxmi Cash CusTomeR care Toll free Number)+7781882167 //07781882167 // All
Fa g hdbck with the time to get the time
![](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(208, 88%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
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
150
Reputation points
commented 2024-05-16T19:25:13.0133333+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
0 answers
Connect SharePoint Online List with Synapse Integrated Runtime Managed Virtual Network
Getting an error when attempting to create a Linked Service for SharePoint Online List in Synapse. I've followed the instructions and prerequisites on MS documentation, but getting the following error when testing the connection: An error occurred while…
asked 2024-05-16T14:01:45.88+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, 56.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC2%3C/text%3E%3C/svg%3E)
CarmeloLoPresti-2973
41
Reputation points
commented 2024-05-16T17:55:14.45+00:00
CarmeloLoPresti-2973
41
Reputation points
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…
asked 2024-05-15T12:58:55.19+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(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)
Wasim
20
Reputation points
commented 2024-05-16T16:26:35.4466667+00:00
ShaikMaheer-MSFT
38,126
Reputation points Microsoft Employee
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
Abhishek Singh
0
Reputation points
edited a comment 2024-05-16T11:39:27.2266667+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,475
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Deploy the ETL code from Dev Synapse Analytics workspace to Another Workspace (different Resource group and Different subscription)
Hi all, I had an issue earlier and I had a great response and it has been resolved now. I need to know what's the best approach to: Deploy all ETL code (pipelines/ copy , data flows) produced on Synapse and stored on DevOps on different branches to…
asked 2024-05-16T07:53:22.36+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(137.6, 88%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXM%3C/text%3E%3C/svg%3E)
Xhevahir Mehalla
20
Reputation points
commented 2024-05-16T10:50:33.3433333+00:00
Xhevahir Mehalla
20
Reputation points
2 answers
One of the answers was accepted by the question author.
Configuring sql user permission to INSERT only via stored procedure in Synapse dedicated pool
We currently have a client with External users set up via AAD and each group has access to a certain schema with grant permission to select, insert, delete and update on their dedicated SQL pool. Our client would like to revoke explicit insert, delete…
asked 2024-05-02T10:09:36.33+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(48, 68%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Marjan Selahi
20
Reputation points
commented 2024-05-16T09:46:50.85+00:00
Marjan Selahi
20
Reputation points
1 answer
One of the answers was accepted by the question author.
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
20
Reputation points
commented 2024-05-16T09:41:45.39+00:00
PRADEEPCHEEKATLA-MSFT
78,911
Reputation points Microsoft Employee
1 answer
'Invalid column name 'is_change_feed_enabled'.'; detailedError - A database operation failed with the following error: 'Invalid column name 'is_change_feed_enabled'.'
When I tried to setup link connection between on-prem sql server and Azure sql dedicated pool, took the below error. Failed to enable Synapse Link on the source due to 'Failed to enable the source database: Some internal error happened due to 'Calling…
asked 2024-05-08T12:59:49.6566667+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, 97%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AdmKaraH
0
Reputation points
commented 2024-05-16T07:14:02.2466667+00:00
AnnuKumari-MSFT
31,561
Reputation points Microsoft Employee
1 answer
Can't able to connect the VM installed postgresql from ADF
Hi Team, We are unable to access the PostgreSQL from the ADF linked server. it's a azure PostgreSQL flexible server, and we have enabled the "Allow public services" setting within Azure for this server. However, we are still unable to create a…
![](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, 79%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
Azure Synapse Analytics Workspace And its Dedicated SQL Pool Migration From one subscription to another subscription during Cross Subscription Migration
I just Want to know that how can I migrate synapse workspace and its dedicated SQL pool from one subscription to another subscription during cross subscription migration
asked 2024-05-02T13:20:37.0333333+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(137.6, 66%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Maaz Ahmed Nagori
0
Reputation points
edited an answer 2024-05-16T04:23:56.1566667+00:00
PRADEEPCHEEKATLA-MSFT
78,911
Reputation points Microsoft Employee
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)
![](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(12.8, 48%, 11%)' 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)
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
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)
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
phemanth
6,475
Reputation points Microsoft Vendor