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,149 questions
1 answer
Azure Synapse support end
Hello- I have heard that Microsoft is going to end support for synapse.Is that true ? What if customers don't want to move to Microsoft Fabric? I believe it works on data mesh so that may not be suitable for all organisation. Thanks, Sourav
asked 2024-09-03T13:18:19.65+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, 35%, 19%)' 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)
Sourav
125
Reputation points
commented 2025-01-26T07:58:59.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(150.4, 3%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERI%3C/text%3E%3C/svg%3E)
Rub Ire Pos
0
Reputation points
1 answer
Insert operation at Azure SQL Synapse Analytics is running longer
Hi, We have DW500C system and observing strange behavior, which i would like to understand bit better. we have a Fact load Insert statement that runs for more than an Hour and its direct execution of SELECT statement is completing within 15 minutes. I…
asked 2025-01-23T12:16:46.5033333+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(108.80000000000001, 45%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rodrigues Dixon
0
Reputation points
answered 2025-01-25T11:24:26.3166667+00:00
Vinodh247
27,281
Reputation points MVP
1 answer
I have enabled azure synapse link for a container in dev environemnt. I want to turn off that right now? How do i do it?
I have enabled azure synapse link for a container in dev environment. I want to turn off that right now? I didn't create any workspace for that. i just enabled it for a particualr container.
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,102 questions
Azure Synapse Analytics
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,149 questions
asked 2025-01-24T04:04:52.9733333+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(60.8, 39%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
crynos_001
0
Reputation points
answered 2025-01-25T11:16:08.83+00:00
Vinodh247
27,281
Reputation points MVP
0 answers
Insert operation at Azure SQL Synapse Analytics is running longer
Hi, We have DW500C system and observing strange behavior, which i would like to understand bit better. we have a Fact load Insert statement that runs for more than an Hour and its direct execution of SELECT statement is completing within 15 minutes. I…
asked 2025-01-23T12:17:42.0233333+00:00
Rodrigues Dixon
0
Reputation points
commented 2025-01-24T23:01:43.8266667+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
7,260
Reputation points Microsoft Vendor
1 answer
Azure Synapse pipeline
Hi, I have a question regarding Synapse. I want to create a pipeline that can delta update the target table “quotes_target” from source table “quotes_source” with filtered quotes data. I have a list of quotes id of the updated quotes after I extracted it…
asked 2025-01-17T09:16:28.69+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(89.60000000000001, 14.000000000000002%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Lotus88
46
Reputation points
commented 2025-01-24T22:56:15.11+00:00
Chandra Boorla
7,260
Reputation points Microsoft Vendor
0 answers
Azure Synapse Notebook does't fail immediately in case of error in code
Hello, I am struggling with really weird behavior when executing a notebook within Azure Synapse. I am utilizing pyspark and sql within this notebook and noticed that the notebook doesn't fail immediately in case of a bug or let's say typo in a code. For…
asked 2025-01-23T18:26:28.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(182.40000000000003, 38%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Peter Polacek
20
Reputation points
commented 2025-01-24T21:49:13.04+00:00
Chandra Boorla
7,260
Reputation points Microsoft Vendor
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-24T17:18:06.1566667+00:00
AnnuKumari-MSFT
33,986
Reputation points Microsoft Employee
1 answer
How to use terraform to auto create synapse sql pool user and grant permission
Hi there, I would like to ask how to use terraform to auto create synapse sql pool user and grant permission Thanks&Regards, zmsoft
asked 2025-01-07T00:56:50.63+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, 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)
zmsoft
280
Reputation points
commented 2025-01-24T17:15:47.9866667+00:00
AnnuKumari-MSFT
33,986
Reputation points Microsoft Employee
1 answer
How to Disable Synapse Link in Azure Cosmos DB Container?
Hello, I recently enabled Synapse Link for a container in my Azure Cosmos DB account, but I’m unable to find the option to disable or turn off the feature. I checked the container settings, but I can’t see an option to disable the Analytical Store or…
asked 2025-01-24T04:14:47.13+00:00
crynos_001
0
Reputation points
commented 2025-01-24T16:35:15.6066667+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,270
Reputation points Microsoft Vendor
2 answers
How to connect synapse external table using ADF.
I have Azure Synapse external tables and wanted to bring those table data into another adls account using adf. Created Link service in ADF using authentication type as sql authentication. used admin username and password in the same. Test connection…
asked 2025-01-24T11:28:31.66+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(25.6, 48%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Harshraj Sawant
0
Reputation points
answered 2025-01-24T13:51:30.9133333+00:00
Nandan Hegde
33,561
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
Issues Fetching Access Token in Azure DevOps Release Pipeline for Azure Synapse Workspace Deployment
We build a Release Pipeline in Azure DevOps. This pipeline should deploy artifacts to an Azure Synapse Workspace (as described in this post:…
asked 2025-01-21T09:00:54.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(67.2, 76%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER6%3C/text%3E%3C/svg%3E)
RieDaniel-6883
25
Reputation points
accepted 2025-01-24T10:10:06.12+00:00
RieDaniel-6883
25
Reputation points
1 answer
Delta Tables in Unity Catalog - My Organization vs Unity Catalog - Legacy - Hive Metastore
We have multiple Databricks Delta Tables that were created before Unity Catalog came into picture. After Unity Catalog got included in our Project, all our Tables are shown in Unity Catalog as part of Legacy. We would like to know if having them as…
asked 2025-01-22T20:07:40.7633333+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(240, 59%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIN%3C/text%3E%3C/svg%3E)
Immaneni, Nanda
0
Reputation points
commented 2025-01-24T07:35:43.2933333+00:00
Chandra Boorla
7,260
Reputation points Microsoft Vendor
0 answers
setting up private endpoint between cosmos db and synapse analytics
hello team, i want to setup private endpoint for synapse workspace and cosmos db but the "managed virtual network" is set as No. how does it affect the private endpoint connection. please let me know if any way to establish the explicit…
asked 2025-01-22T11:55:22.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(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
85
Reputation points
commented 2025-01-24T04:50:05.6166667+00:00
Ganesh Gurram
3,270
Reputation points Microsoft Vendor
0 answers
How to turn off azure synapse link for a container i didn't create it a workspace for it just anabled in azure cosmos db for dev env. My major concern is should i be charged for that?
How to turn off azure synapse link for a container i didn't create it a workspace for it just anabled in azure cosmos db for dev env. My major concern is should i be charged for that?
asked 2025-01-24T04:06:52.27+00:00
crynos_001
0
Reputation points
asked 2025-01-24T04:06:52.27+00:00
crynos_001
0
Reputation points
2 answers
How to connect Azure Data Explorer pool in Synapse to Cosmos DB
Hi, I am trying to connect Data Explorer (Synapse pool) to the Analytical Store in a Cosmos DB container. I was informed on this forum that this is indeed possible and the documentation shows how to do this. Unfortunately when I try to ingest data into…
asked 2025-01-20T11:04:52.11+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, 61%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Christopher Wilkinson
0
Reputation points
commented 2025-01-23T21:45:42.3+00:00
Chandra Boorla
7,260
Reputation points Microsoft Vendor
1 answer
Find total activities run and vCore hours consumed in a month from all of my monthly pipeline
How can I see the total vCore hours consumed in a month from all of my pipeline runs inside a Synapse Workspace. I know how to get that value for each pipeline run but I am trying to find out whether there is a report/view/screen where it can be seen on…
asked 2025-01-23T16:24:40.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(96, 80%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Shafayat Syed
65
Reputation points
answered 2025-01-23T17:23:32.9466667+00:00
hossein jalilian
9,700
Reputation points
3 answers
Datetime2 error when querying parquet file produced from Synapse copy activity from OData Business Central Source (data seems to be changed from 0001-01-01 to 0000-12-30)
I have a pipeline running a copy activity to copy data from Business Central OData source to parquet file everyday. Everything works fine before 16/07/2024 but problem arises starting from 17/07/2024. The parquet file no longer be able to query from…
asked 2024-07-24T15:13:17.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(233.6, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
Victor Chu
15
Reputation points
commented 2025-01-23T16:26:38.87+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(70.4, 46%, 16%)' 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)
Jeff S
0
Reputation points
1 answer
Data loading into sql managed instance table taking time
Hi All, we have couple of data loads in which the distribution is taking lot of time. Our source queries are extracting results in and around 15 minutes but as per sys.dm_pdw_sql_requests column operation_type=OnOperation and column…
asked 2025-01-02T09:13:19.56+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(291.2, 8%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Dixon Rodrigues
0
Reputation points
commented 2025-01-23T11:45:59.0233333+00:00
Rodrigues Dixon
0
Reputation points
2 answers
One of the answers was accepted by the question author.
I can't get diagnostics logging working on a dedicated sql pool
I want to see the exec requests and waits on a dedicated pool. So I created a log analytics workspace in the same workspace as the sql pool and I went to the dedicated sql pool and in the Diagnostics Settings option I created a new one for the logs exec…
asked 2025-01-15T08:25:39.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(76.8, 91%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEH%3C/text%3E%3C/svg%3E)
Ellen Heijmans
21
Reputation points
accepted 2025-01-23T10:40:18.4566667+00:00
Ellen Heijmans
21
Reputation points
1 answer
One of the answers was accepted by the question author.
How to let synapse pipeline identify a value as hexadecimal encoded text
Hello, I want to sign a JWT token using the signing functionality of Azure Key Vault and have generated a private key. I want to send a request to the Key Vault from Azure Synapse pipeline's Web component. The configuration of this web component is as…
![](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, 7.000000000000001%, 37%)' 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)