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.
5,117 questions
1 answer
Performance Issues with Code Migration from Azure Synapse to Microsoft Fabric
Title: Performance Issues with Code Migration from Azure Synapse to Microsoft Fabric Details: I have been using Azure Synapse to curate code and create tables. After the introduction of Microsoft Fabric, I migrated all my code to Fabric. Currently, I am…
asked 2025-01-11T13:45:07.5266667+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, 7.000000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sarim Husain
0
Reputation points Microsoft Vendor
answered 2025-01-12T09:56:52.8133333+00:00
Vinodh247
26,936
Reputation points MVP
2 answers
how to fix this error The request content was invalid and could not be deserialized: Required property 'name' not found in 'sku'
getting error while synapse workspace deployment
asked 2024-12-09T14:46:47.8+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(294.40000000000003, 53%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Narendra Singh
15
Reputation points
commented 2025-01-11T03:44:00.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(83.2, 83%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
milan barot
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Check if an Azure Synapse Cosmos DB linked service container is a Read-Only replica
I'm accessing a Cosmos DB through a linked service in Synapse. And we need to be able to verify if the replica we are accessing is readonly of if it has write capabilities; can we do this? I have tried several approaches but cant seem to find a way to…
asked 2025-01-06T14:56:01.58+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(163.2, 50%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mariano Peinador Perez
20
Reputation points Microsoft Employee
accepted 2025-01-10T21:30:44.8033333+00:00
Mariano Peinador Perez
20
Reputation points Microsoft Employee
0 answers
With Azure Synapse Analytics Copy Activity I use pagination to combine multiple REST calls into one JSON file.
With Azure Synapse Analytics Copy Activity I use pagination to combine multiple REST calls into one JSON file. The resulting data however is a combination of several JSON structures and itself not a valid JSON format. How can I combine the multiple REST…
asked 2025-01-09T15:39:52.5166667+00:00
Jürg Gubler
0
Reputation points
commented 2025-01-10T20:07:47.3266667+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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
6,370
Reputation points Microsoft Vendor
1 answer
Notebook in Pyspark to compare schemas not naming the parquet file in correct format. It's defaulting instead of using name given
This code compares the schemas and then should update if needed. It updates to a new directory but does not keep the same name. I have tried everything how can I get it to rename to xyzYYYYMMDD.parquet for year in range(2024, 2025): # Adjust years as…
asked 2025-01-07T17:34:36.94+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(230.39999999999998, 26%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWY%3C/text%3E%3C/svg%3E)
Wurm, Yvonne L
0
Reputation points
commented 2025-01-10T16:35:29.3066667+00:00
Chandra Boorla
6,370
Reputation points Microsoft Vendor
1 answer
Granting the view permission for a stored procedure in a Synapse SQL pool
Hi, in a dedicated Synapse SQL pool is it to possible granting the view (and not the execution) permission for a stored procedure? Thanks
asked 2024-06-24T15:28:56.38+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(115.19999999999999, 41%, 21%)' 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)
pmscorca
1,007
Reputation points
commented 2025-01-10T16:32:35.1066667+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(220.8, 30%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Akram, Mashood (Admin)
0
Reputation points
2 answers
Re-use dataflows active cluster
I have the following scenario. There are csv files that users can drop into the data lake at any time. I need to check each csv file in the data lake in real time. Part of the verification is done with dataflows in azure synapse analytics. The…
asked 2025-01-08T10:02:50.15+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(192, 83%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Junior Steve KAMDEM DJOKO
0
Reputation points
answered 2025-01-10T06:28:47.4766667+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
12,895
Reputation points Microsoft Vendor
0 answers
Error while creating Synapse analytics workspace
The request content was invalid and could not be deserialized: Required property 'name' not found in 'sku'
![](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, 38%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
1 answer
How to get database name from Synapse serverless SQL pool query history
I have used the DMVs to get the Synapse serverless SQL pool query history and Synapse Studio. I do see in the query text listing that shows the from statement with the name of the view <schema>.<view name> but I do not see the data source…
asked 2024-12-16T12:30:26.8766667+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(307.2, 39%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Foster, Gwendolyn
0
Reputation points
commented 2025-01-10T05:20:06.2233333+00:00
phemanth
12,895
Reputation points Microsoft Vendor
0 answers
How to export a table from azure synapse dedicated DB pool
How to export a table from azure synapse dedicated DB pool
asked 2025-01-08T02:06:25.9+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, 7.000000000000001%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Naresh
0
Reputation points
commented 2025-01-10T04:35:04.77+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(201.6, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Ganesh Gurram
3,025
Reputation points Microsoft Vendor
0 answers
Error while loading data
Getting below error message while loading data using Pipeline. Failure happened on 'Source' side. ErrorCode=DB2DriverRunFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error thrown from driver. Sql code:…
asked 2025-01-07T17:24:25.6533333+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(102.4, 12%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gunti, Srikanth
0
Reputation points
commented 2025-01-09T17:33:16.93+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
18,965
Reputation points Microsoft Vendor
1 answer
How to use the wheel packaged Json files in the Azure Synapse Spark job definition or Notebook
Hello Everyone I'm facing an issue on accessing the json file packaged as a Python wheel on the Synapse Spark Job definition file. Below are my configs. Any help would be truly appreciated. Thanks. I'm using the below setup.py file to package the pyspark…
asked 2025-01-06T16:14:49.98+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(83.2, 22%, 18%)' 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)
manigandan
0
Reputation points
commented 2025-01-09T17:23:08.1566667+00:00
Smaran Thoomu
18,965
Reputation points Microsoft Vendor
1 answer
why my Selfhosted, dedicated sql pool and builtin sql pool
why cant i access my SHIR, Sql Pools at the same time i was using all of them till yesterday and now all of the sudden everything is unavailable
asked 2025-01-07T10:22:23.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(54.400000000000006, 66%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Raghuveeravenkata Pasala
0
Reputation points
commented 2025-01-09T17:03:50.21+00:00
Chandra Boorla
6,370
Reputation points Microsoft Vendor
2 answers
GIT enabled Synapse Workspace: is there any way to get the current branch name via Python?
Hi, I was wondering if there is any method (or some other way) to retrieve the name of the currently selected GIT branch programmatically within a running Synapse Notebook session using Python. To make thinks even more complicated: the Synapse…
![](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, 42%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
1 answer
Integration of On-Premises/third party Network with Synapse Spark
Hi Team, We have a requirement to integrate the on-premises network with Synapse Spark and extract data from the API hosted on the network. We have created an Azure Virtual Network Gateway and set up a site-to-site VPN connection between our local…
asked 2025-01-08T12:18:15.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(140.8, 27%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Rupesh Galla
0
Reputation points
answered 2025-01-09T07:11:20.9366667+00:00
AnnuKumari-MSFT
33,986
Reputation points Microsoft Employee
1 answer
ServiceNow Linked Service not able to get the data using copy activity
I am trying to connect to Service now from synapse to copy data of incidents and some other data. I tested the linked service after providing the credential and as successful to test the connection. but when trying to preview the data, get the below…
asked 2025-01-07T12:48:36.0633333+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(3.2, 7.000000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Dixan Thomas (Contractor)
0
Reputation points
commented 2025-01-09T05:58:40.8266667+00:00
Dixan Thomas (Contractor)
0
Reputation points
1 answer
One of the answers was accepted by the question author.
How do I convert a dataverse table object to a json string using FetchXML
Hi there, In synapse pipeline, I want to convert a dataverse table object to a json string using FetchXML. Whether FetchXML can achieve this function? Any suggestion? Thanks&Regards, zmsoft
![](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, 53%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
3 answers
How to query Kusto data in Synapse with cert auth in linked service
Hi, I'm trying to query Kusto data with linked service in Synapse. Synapse can generate the samples automatically as below. It can work when I use secret of application in setting up linked service. But it failed with the error when I tried to use cert…
asked 2024-04-10T06:26:26.6+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(281.6, 24%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMZ%3C/text%3E%3C/svg%3E)
Meng Zhang
31
Reputation points Microsoft Employee
answered 2025-01-08T20:51:27.91+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(134.4, 56.00000000000001%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jeremy Peach
0
Reputation points Microsoft Employee
1 answer
request not authorized to read metadata from cosmos db analytical store.
i am getting error as error occured during snapshot metadata read phase -com.microsoft.azure.storage.storageexception: request not authorized to perform operation. details ")" when selecting the analytical store of cosmosdb. the data can be…
asked 2025-01-06T14:44:18.5966667+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(3.2, 98%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
ANKIT GHENGE
65
Reputation points
commented 2025-01-08T16:47:27.47+00:00
Chandra Boorla
6,370
Reputation points Microsoft Vendor
2 answers
How to get a predicate pushed to a workspace table?
In my Synapse workspace I have created a spark table linked to a Cosmos analytical store instance with the following details (as described here) create table if not exists mytable using cosmos.olap options (spark.synapse.linkedService…
asked 2025-01-05T12:31:52.1566667+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(195.2, 21%, 28%)' 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)
Martin Smith
1
Reputation point
edited a comment 2025-01-08T11:06:03.5933333+00:00
Martin Smith
1
Reputation point