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,464 questions
2 answers
One of the answers was accepted by the question author.
Querying with Filename and Filepath Functions in Synapse Serverless
Hello, I have been reading about using filename() and filepath() in t-sql statements with synapse serverless sql: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-specific-files#functions Wondering if for the following statement:…
asked 2024-05-21T17:38:30.0266667+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(54.400000000000006, 88%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Karl Gardner
45
Reputation points
answered 2024-05-21T20:52:17.8666667+00:00
Karl Gardner
45
Reputation points
1 answer
Synapse Link for Dataverse-SYN-806: Default storage container in Synapse workspace is not accessible error while enbling tables
Hi, I'm trying to setup a synapse link via dataverse to F&O. I'm able to setup the connection but when I enable tables sync status is throwing out error . Error details - SYN-806: Default storage container in Synapse workspace is not…
asked 2024-05-17T12:32:44.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(153.6, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sandz
66
Reputation points
commented 2024-05-21T20:31:04.35+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
27,566
Reputation points Microsoft Employee
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
170
Reputation points
commented 2024-05-21T20:30:33.79+00:00
BhargavaGunnam-MSFT
27,566
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Synapse Analytics | Pipeline | Linked Service to "Azure Database for PostgreSQL" not available in 'Stored Procedure'
Hi everyone, I am trying to create a simple pipeline in Azure Synapse Analytics which should write some files' metadata fields into a Database. To do so, I first created a linked service to a postresql database instance hosted on Azure: I am now trying…
asked 2024-05-21T10:06:49.0933333+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(297.6, 21%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Lorenzo Perino
20
Reputation points
accepted 2024-05-21T18:43:34.6533333+00:00
Lorenzo Perino
20
Reputation points
1 answer
One of the answers was accepted by the question author.
External Tables and Polybase in Synapse and Sql Server
So, I thought I knew external tables well in azure but I was reading about external tables with Sql Server: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=sql-server-ver16&tabs=dedicated and it seems…
asked 2024-05-17T21:19:29.67+00:00
Karl Gardner
45
Reputation points
commented 2024-05-21T15:20:25.3366667+00:00
Karl Gardner
45
Reputation points
1 answer
One of the answers was accepted by the question author.
wrong answer in dp 203 test exam question
Hello, I have test exam questions for dp 203 and i had the following question after the answer, it shows that it is wrong and gives a link to the documentation …
asked 2024-05-21T11:51:02.05+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(275.2, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDV%3C/text%3E%3C/svg%3E)
Darjuš Vasiukevič
20
Reputation points
accepted 2024-05-21T13:44:15.2666667+00:00
Darjuš Vasiukevič
20
Reputation points
1 answer
SAP CDC and SAP Tables connectors regarding SAP Note 3255746 ?
Dear Team, Is there any one who when through the SAP Note 3255746 ? What impact shroud we expect regarding the SAP CDC and SAP Tables connectors already implemented for our customers? Thanks for you input. Tarik
asked 2024-04-23T11:45:42.5766667+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(54.400000000000006, 52%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETZ%3C/text%3E%3C/svg%3E)
Tarik Zaaboul
0
Reputation points
commented 2024-05-21T11:47:22.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(217.60000000000002, 59%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Lorenz Bangerter
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Meta data activity Child item unable to load all the files from different folders via file system as a source
Hello, I have been trying to dynamically get the files from different folders and mapping into the dynamic folder within Datalake. However, when I used Childitems under metadata, I could only load files from circled folder in the attached below. is…
1 answer
How to Directly Connect Azure synapse workspace to MongoDB atlas (running on private network) without using SHIR ?
Hello, Azure synapse Analytics configuration: Public network access to workspace endpoints : Enabled Allow Azure services and resources to access this workspace: Enabled IP: Allowed all Allow Azure Synapse Link for Azure SQL Database to bypass…
![](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, 39%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
My data source is D365 F and O and I am trying to connect to QA of D365 V38 instance from Azure Synapse using Linked service. But I am receiving a error.
Hi Team, The data source, we have is D365 F and O and I am trying to connect from Azure Synapse using Linked service to D365 QA instance by entering URL, Client ID and Client secret. But When I try to test the connection, I am receiving the below error. …
asked 2024-03-20T19:32:14.3+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(246.4, 22%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Thanuja
20
Reputation points
commented 2024-05-21T09:25:34.31+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(92.8, 40%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Deepthi Chittari
0
Reputation points
0 answers
How to pass the correct audience when calling mssparkutils.credentials.getToken on Azure China (Mooncake) cloud?
I'm using Microsoft Spark Utilities (MSSparkUtils) with linked service to authenticate into Azure SQL using System Assigned Managed Identity (Synapse Workspace) on Azure China (Mooncake) cloud. However, when I call gettoken with the audience type…
asked 2024-05-21T04:20:59.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(246.4, 75%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Abhishek Bhatt
0
Reputation points Microsoft Employee
commented 2024-05-21T08:53:14.2533333+00:00
PRADEEPCHEEKATLA-MSFT
79,376
Reputation points Microsoft Employee
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-21T04:28:24.22+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,720
Reputation points Microsoft Vendor
1 answer
create store procedure in Synapse
Hi , How to create store procedure in synapse to create tables Regards
asked 2024-05-20T05:47:38.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(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-21T04:27:30.52+00:00
PRADEEPCHEEKATLA-MSFT
79,376
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Help on executing custom query on Azure Cosmos DB using Spark in Azure Synapse
Hi Team, I want to run custom query against cosmos db in spark using clientid and secret but I'm ending up with below error. can you please assit. I tried multiple way but it still gives same error. AppId has Reader access on the cosmos db account. As…
asked 2024-04-30T21:06:42.2066667+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(160, 73%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Abhiram Duvvuru
191
Reputation points Microsoft Employee
accepted 2024-05-20T23:35:27.1433333+00:00
Abhiram Duvvuru
191
Reputation points Microsoft Employee
2 answers
The Azure Synapse resource provider (Microsoft.Synapse) needs to be registered with the selected subscription
Hi Team, I am unable to use synapse analytics even though I have registered with Microsoft.Synapse and Microsoft.Sql. Can you please look into this? The below is screenshot for registered ones.
asked 2024-03-17T20:59:34.6633333+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(297.6, 4%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Srini v
0
Reputation points
answered 2024-05-20T21:55:57.8966667+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, 8%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kuriel Karrales
1
Reputation point
2 answers
One of the answers was accepted by the question author.
Using elephas and keras deep learning libraries in Synapse notebook
Hi, I tried to find a solution for distributed computing with Keras deep learning libraries in Azure Synapse Notebook. 'elephas' looks like a good option. But I encountered the following error: Py4JJavaError Traceback (most recent call last) Cell In…
![](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, 95%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUZ%3C/text%3E%3C/svg%3E)
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-20T10:53:23.73+00:00
ShaikMaheer-MSFT
38,126
Reputation points Microsoft Employee
2 answers
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…
asked 2024-05-14T06:10:02.6633333+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, 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)
Aravind
20
Reputation points
answered 2024-05-20T10:52:45.1733333+00:00
ShaikMaheer-MSFT
38,126
Reputation points Microsoft Employee
1 answer
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-20T10:42:11.4466667+00:00
ShaikMaheer-MSFT
38,126
Reputation points Microsoft Employee
3 answers
Configuring Linked Service for Dev to Prod Movement in Azure Synapse Analytics
In Azure Synapse Analytics, I have a linked service of type Azure SQL Database Managed Instance, and I have two linked services, one for dev and one for prod. How can I move from dev to prod without changing the linked service manually? How can I make it…
asked 2024-04-15T07:21:19.3566667+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(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' %3EAS%3C/text%3E%3C/svg%3E)
Aditya Singh
105
Reputation points
answered 2024-05-20T08:54:48.05+00:00
Pinaki Ghatak
2,400
Reputation points Microsoft Employee