Microsoft Q&A

Azure Synapse Analytics

2,842 questions

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

Browse all Azure tags

2,842 questions with Azure Synapse Analytics tags

Sort by: Updated
Updated Created Answers
1 answer

Failed to load one or more resources due to no response.

I am receiving this error message when trying to log into Synapse Analytics "Failed to load one or more resources due to no response."

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.
2,842 questions
asked 2023-03-17T13:25:23.9166667+00:00
John Lyon 0 Reputation points
commented 2023-03-22T18:40:19.9833333+00:00
BhargavaGunnam-MSFT 10,071 Reputation points Microsoft Employee
0 answers

Can't query partitioned tables - Azure Synapse Link for Dataverse

Hi, we have a problem with accessing partitioned tables in Azure Synapse Workspace that were previously created by ingesting tables from Power Platform via Azure Synapse Link for Dataverse. Snapshot folder and .csv files are normally created but can't be…

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.
2,842 questions
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
930 questions
asked 2023-03-20T16:05:06.8433333+00:00
Leo Milos 5 Reputation points
commented 2023-03-22T18:27:40.7166667+00:00
BhargavaGunnam-MSFT 10,071 Reputation points Microsoft Employee
0 answers

Synapse Spark - The access code is invalid

We have some Spark external tables set up to point to a CDM storage folder that is fed by Dynamics F&O. Most of the time, the queries to these tables work but on occasion one or more will fail with below error Operation on target lkupLatestUpdate…

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.
2,842 questions
asked 2023-03-16T22:44:49.1366667+00:00
Ryan Abbey 1,081 Reputation points
commented 2023-03-22T18:22:01.3566667+00:00
Ryan Abbey 1,081 Reputation points
1 answer

Deadlock Iock

We are facing below error in azure synapse analytics. Any one can help how to track ? ErrorMessage: 110802;An internal DMS error occurred that caused this operation to fail. Details: Please use this Error ID when contacting your Administrator for…

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.
2,842 questions
asked 2023-03-20T09:55:48.4433333+00:00
Umer Shahbaz 0 Reputation points
commented 2023-03-22T16:56:59.36+00:00
MartinJaffer-MSFT 25,451 Reputation points Microsoft Employee
0 answers

Overcoming 20MB ARM template issue

In reference to the below issue for synapse : https://github.com/MicrosoftDocs/azure-docs/issues/89431 There is a documentation as below : what does this task here mean? Is it the Marketplace add in…

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.
2,842 questions
asked 2023-03-22T16:46:02.8+00:00
Nandan Hegde 22,191 Reputation points
0 answers

Azure Synapse Spark Notebook : InvalidAbfsRestOperationExceptionjava.net.SocketTimeoutException

I just started working on Azure Synapse Analytics and created a Spark pool. I am trying to run the notebook with the following code:…

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.
2,842 questions
asked 2023-03-22T14:38:00.89+00:00
Aayush Suresh Jain 66 Reputation points
commented 2023-03-22T15:46:02.3133333+00:00
Aayush Suresh Jain 66 Reputation points
0 answers

Synapse - UserAccounts

On Azure Synapse, We want to control using the workload management by using resource limitations. Can we use something like OAUTH token for multiple teams instead of having multiple accounts to trace the usage and queries?

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.
2,842 questions
asked 2023-03-22T14:45:42.18+00:00
mrsolo 0 Reputation points
edited the question 2023-03-22T15:07:16.5766667+00:00
mrsolo 0 Reputation points
2 answers

How to connect serverless sql pool by SSIS?

I want to extract data from serverless sql pool and load into my sql server database table by visual studio SSIS package. I'm using serverless sql pool table as a source and SQL server database table as destination. I can create a OLEDB connection…

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.
2,842 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,947 questions
asked 2022-05-25T08:08:55.52+00:00
Jisan 1 Reputation point
commented 2023-03-22T10:46:27.6133333+00:00
Sidney 40 Reputation points
1 answer One of the answers was accepted by the question author.

Azure Data Factory copy activity stuck on queued status

Hello, I have been experiencing an issue, where the data factory copy activities are stuck in 'queued' status. I have followed the troubleshoot documentation but did not find anything. These are the things that I have checked: Are there old…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,656 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.
2,842 questions
asked 2023-03-06T09:46:49.32+00:00
Yoon, Sojin 45 Reputation points
edited a comment 2023-03-22T10:28:44.1133333+00:00
Joost Romijn 0 Reputation points
0 answers

How do I delete rows with certain characters in the data flow?

I want to delete this '〇' row in the image in the data flow. Is there a better way to do this?

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.
2,842 questions
asked 2023-03-22T09:52:28.1966667+00:00
NishimuraChinatsu-9854 501 Reputation points
edited the question 2023-03-22T09:52:44.91+00:00
NishimuraChinatsu-9854 501 Reputation points
1 answer

Please tell me how to retrieve data.

I would like to get the data for the previous 2 weeks from the date specified in the parameter, and I would like to know how to get the data for 2 weeks in one pipeline. The data is stored in GEN2 as AAA/year/mm/day by day. Do I use variables or for each…

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.
2,842 questions
asked 2023-02-27T12:09:41.4366667+00:00
NishimuraChinatsu-9854 501 Reputation points
commented 2023-03-22T09:48:27.2866667+00:00
NishimuraChinatsu-9854 501 Reputation points
1 answer

Getting Azure Synapse Analitics Tables Size - Query on documentation does not return correct data

Hello, I've a Synapase Workspace with a Sql Pool that has a SQL Server version 12.0.2000 . My requirement is to get the phisical space storage for each table in my database. Many peoples pointed me at…

Azure SQL Database
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.
2,842 questions
asked 2023-03-20T14:37:18.55+00:00
F N 20 Reputation points
commented 2023-03-22T09:14:10.5866667+00:00
F N 20 Reputation points
1 answer

How do I view the Dedicated pool as a Azure SQL DB

Hi, I have a Stream analytics job. I need to bring one reference input from a Synapse dedicated pool. Can I view or configure the dedicated pool as a Azure SQL DB so that I can bring the data in my ASA job (as the ASA only allows Azure SQL DB). Thanks…

Azure SQL Database
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.
2,842 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
235 questions
asked 2023-03-16T12:45:27.1066667+00:00
Anonymous
commented 2023-03-22T08:04:16.7733333+00:00
Kanav Sharma 0 Reputation points
1 answer

Rename a column name (containing dot in it) of a table

I want to change a column name of a table . But issue is that column name is containing dot in it . which is creating issue while I am executing below statement.:- I can not drop the table as it contains huge and important data expecting Column name =…

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.
2,842 questions
Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,656 questions
Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
13,500 questions
asked 2023-03-17T10:24:35.3133333+00:00
Gulhasan.Siddiquee 1 Reputation point
commented 2023-03-22T06:58:17.78+00:00
Gulhasan.Siddiquee 1 Reputation point
1 answer

How to fix #Could not connect to cluster"

Hi, How can I fix the following issue: Could not connect to cluster Principal 'msauser=ABC@gmail.com' is not authorized to perform operation 'VersionShowCommand' on 'https://XYZ.synapse-ws-haleh.kusto.azuresynapse.net:443/'.…

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.
2,842 questions
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
264 questions
asked 2023-03-17T11:23:33.92+00:00
Haleh Kafashinamdar 0 Reputation points
commented 2023-03-22T03:34:15.64+00:00
KranthiPakala-MSFT 35,366 Reputation points Microsoft Employee
0 answers

.NET for Apache spark 3.3

Hi All, We are using C# notebooks for our production workloads. As per link https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-33-runtime, looks like there is no longer support for .NET on latest spark version. Is there any…

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.
2,842 questions
asked 2023-03-22T02:07:47.59+00:00
Abhiram Duvvuru 81 Reputation points Microsoft Employee
2 answers

azure subscription

Help me to get more details in subscription as i want to change the address on my profile it's not happeing how do i de.

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
13,500 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
4,879 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.
2,842 questions
asked 2023-03-22T00:54:09.54+00:00
Mukesh.Regmi 0 Reputation points
answered 2023-03-22T01:53:15.2966667+00:00
Mukesh.Regmi 0 Reputation points
0 answers

azure synapse new Link connection error: Failed to enable Synapse Link on the source due to 'The database master key is missing.'.

I am creating a new azure synapse 'Link connection' ... after defining everything including source SQL server ( which lives on NON azure ) and destination Dedicated SQL pool I hit the Start button and get error Failed to enable Synapse Link on the…

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.
2,842 questions
asked 2023-03-20T16:40:18.0666667+00:00
sekhemrekhutawysobekhotep 36 Reputation points
edited a comment 2023-03-21T21:51:06.6833333+00:00
BhargavaGunnam-MSFT 10,071 Reputation points Microsoft Employee
1 answer

how to forcedly restart cluster when notebook activity retry?

Hi I have a synapse pipeline with a notebook activity. Occasionally, the notebook fails. So I change retry option to 2. The notebook does retry when it fails and it runs successfully on the second try. But I find the spark application of first notebook…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,656 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.
2,842 questions
asked 2023-03-20T16:16:05.4733333+00:00
Tian, Xinyong 0 Reputation points
edited an answer 2023-03-21T20:10:12.4533333+00:00
BhargavaGunnam-MSFT 10,071 Reputation points Microsoft Employee
2 answers

How to fix Synapse data flow not updating data in delta lake?

Hi, A dataflow mapping in Synapse writing to a delta sink should update rows based on an Alter row transformation. In the data preview of the debug session I can see that the row should be updated, however after running the pipeline the record is not…

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.
2,842 questions
asked 2023-03-17T09:05:27.8466667+00:00
JaneTeo-1997 0 Reputation points
commented 2023-03-21T18:59:53.1066667+00:00
MartinJaffer-MSFT 25,451 Reputation points Microsoft Employee