Microsoft Q&A

Azure Synapse Analytics

3,471 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

3,471 questions with Azure Synapse Analytics tags

Sort by: Updated
0 answers

Userinterface bug / Tabs getting huge after 4 or more tabs / New notification

Since today there is a new notification in the tab bar for Azure Synapse Analytics which makes the tabs huge if you have 4 or more tabs. (for my screen size) The notifcation says : "Other users in your workspace may have acces to modify this item.…

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.
3,471 questions
asked 2023-09-06T10:18:59.9666667+00:00
Stan Heemskerk 0 Reputation points
commented 2023-09-06T15:15:05.8666667+00:00
PRADEEPCHEEKATLA-MSFT 64,386 Reputation points Microsoft Employee
3 answers

Azure Synapse Serverless SQL Session Stuck in Rollback

Hello I have created some views on a Dataverse Lakehouse DB created via Synapse Link in a Serverless SQL Database and connected to them via Power BI. Everything has been going ok until I experienced an error during a Power BI refresh. Now there are…

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.
3,471 questions
asked 2022-04-08T15:38:13.84+00:00
Graeme Cash 46 Reputation points
commented 2023-09-06T15:06:49.1133333+00:00
Darin Searcy 0 Reputation points
1 answer

How perform Upsert/delete in Serverless SQL pool?

I have table in serverless SQL pool backed by parquet file and I want to update records in it. Thanks

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.
3,471 questions
asked 2023-06-23T06:53:00.2266667+00:00
Abdul Rehman 0 Reputation points
commented 2023-09-06T14:13:53.3033333+00:00
David Foster 0 Reputation points
0 answers

How to hide the recent notification at azure synapse workspace tabs.

Hi, We are getting the below alert Other users in your workspace may have access to modify this item. Do not use this item unless you trust all users who may have access to the workspace. How to hide the above notification, The opened tabs were getting…

Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
522 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.
3,471 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,874 questions
asked 2023-09-06T13:56:01.9333333+00:00
Pavan Kumar Gudivada 0 Reputation points
0 answers

Unexpected behaviour using get_metadata in synapse pipelines when getting folder names

We're encountering unexpected behaviour when using a very simple pipeline that loops through folders. It consists of 3 steps, first, it gets all folders from a container, then loops through the folders, and finds the subfolders. So, we have a…

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.
3,471 questions
asked 2023-08-23T12:30:44.0833333+00:00
RickMsBi 76 Reputation points
edited a comment 2023-09-06T13:47:21.0333333+00:00
SatishBoddu-MSFT 18,481 Reputation points
1 answer

Deploying Synapse Workspace Subscription Error

I am having difficulties getting my workspace to deploy. I am using the free trial subscription on my Azure Portal in effort to practice using the various tools in preparation for the DP-500. When I move forward to deploy my workspace I get the following…

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.
3,471 questions
asked 2023-09-05T15:41:52.5466667+00:00
Ryan Clark 0 Reputation points
answered 2023-09-06T12:20:16.62+00:00
Chandra Boorla 0 Reputation points Microsoft Vendor
0 answers

Azure Synapse Analytics to Dynamics 365 Migration Very slow speed copy activity !!!!!!!!!

Hi, My source is Azure Synapse analytics dedicated sql pool, target is Dynamics 365 crm, using mainly copy activity in pipeline, i have 4 batches of pipeline in source sql query [where column_rownum between 1 and 724,005 order by column_rownum ], 2nd…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
1,949 questions
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.
3,471 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,874 questions
asked 2023-09-05T13:48:48.0833333+00:00
Shreyash Choudhary 126 Reputation points
commented 2023-09-06T12:02:29.4433333+00:00
Smaran Thoomu 0 Reputation points Microsoft Vendor
0 answers

Synapse CETAS from parquet file with columns definition is failing

In a Synapse pipeline, I'm trying to use a CETAS script activity from a parquet file that I generate before (from an Azure SQL database). The source database has some tables containing LOB columns (xml type), so the default varchar(8000) type of 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.
3,471 questions
asked 2023-09-05T14:59:17.0166667+00:00
Jean-Christophe Rat Patron 1 Reputation point Microsoft Employee
commented 2023-09-06T11:40:15.5566667+00:00
NIKHILANETHIKUNTA 0 Reputation points Microsoft Vendor
0 answers

The new warning message is creating havoc on the browser

Can we not remove this new warning message about other users in a workspace?? look at 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.
3,471 questions
asked 2023-09-06T01:42:17.3133333+00:00
Leslie 26 Reputation points
edited a comment 2023-09-06T11:12:10.64+00:00
gchenna 0 Reputation points Microsoft Vendor
2 answers

Importing existing resources to azure devops branch from Synapse live mode.

Hi I am trying to import my resources (pipelines) from synapse live mode to azure devops branch. From below screenshot, you could see I am trying to import my resources to main branch, but I am not getting any pop or notification saying it is completed…

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.
3,471 questions
asked 2023-08-24T10:06:36.3266667+00:00
Sangeetha Priya S 105 Reputation points
commented 2023-09-06T09:13:28.2333333+00:00
Sangeetha Priya S 105 Reputation points
1 answer

Azure blob storage trigger doesn't work

I'm trying to create a event trigger for a pipeline. The trigger should be whenever the files in the below folder are created, and they are updated mostly everyday. all the files in the folder have the same name except the endings are like 0-1, 0-10,…

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
1,904 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.
3,471 questions
asked 2023-09-01T22:06:19.16+00:00
Mike Xu 0 Reputation points
edited an answer 2023-09-06T08:04:34.9833333+00:00
Ramya Harinarthini_MSFT 3,336 Reputation points Microsoft Employee
0 answers

Unable to access external tables in lake database with Synapse SQL admin user credentials from SSMS.

Using Azure Synapse Link, we were able to integrate Projects Operations environment with Azure Data Lake (https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-synapse). Lake database is created in synapse workpsace. We can…

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.
1,103 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.
3,471 questions
asked 2023-09-06T05:34:07.3966667+00:00
Sivaram Talluri 0 Reputation points
commented 2023-09-06T07:55:20.2133333+00:00
AnnuKumari-MSFT 26,471 Reputation points Microsoft Employee
1 answer

Pipeline for few incremental tables & few flush and load tables.

Hi there, How to design ADF pipeline where few tables are incremental from source to target and few other tables are flush and load. I'm thinking I need to create separate pipelines 1 for incremental tables and other for flush and load. 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.
3,471 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,874 questions
asked 2023-08-31T21:09:43.0366667+00:00
RJ 106 Reputation points
answered 2023-09-06T06:49:09.9766667+00:00
AnnuKumari-MSFT 26,471 Reputation points Microsoft Employee
1 answer

File uploading error - from Azure blob storage to Azure Fileshare using azure.storage.fileshare. Error Message - ResourceNotFoundError: This request is not authorized to perform this operation.

I am getting below mentioned error while moving Files from Azure Blob storage (Source Storage account) to the Azure FileShare location (Target Storage account) using azure-storage-file-share 12.13.0. In this File movement Source and destination storage…

Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
954 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,066 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.
3,471 questions
asked 2023-08-16T13:10:06.94+00:00
Dev, Surya 0 Reputation points
commented 2023-09-06T06:23:59.54+00:00
Ramya Harinarthini_MSFT 3,336 Reputation points Microsoft Employee
0 answers

How to call Synapse Notebook via REST API avoiding Spark Session creation time

We are preparing some Web APP UI using Azure App services. We have written some lightweight Spark Notebooks in Databricks to perform some small operations like: Converting Source(RDBMS) Schema to Spark Schema Getting Spark Schema from small files(…

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.
3,471 questions
asked 2023-09-05T11:14:04.7033333+00:00
Narender Kumar 20 Reputation points
commented 2023-09-06T05:42:10.8166667+00:00
KranthiPakala-MSFT 42,672 Reputation points Microsoft Employee
1 answer

I'm attempting to use Data Factory to transfer a CSV file from my computer to Azure Data Lake. I'm unable to select the path to the file I want to migrate from my local computer when I try to link the file system in the data factory's source tab.

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.
1,103 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.
3,471 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,874 questions
asked 2023-03-09T19:43:27.6566667+00:00
Abhijith Yamsani 0 Reputation points
edited a comment 2023-09-06T05:16:52.17+00:00
Gustavo Henrique Bavia 0 Reputation points
1 answer

Calling a Synapse/ADF pipeline from an Azure Function

Hi, I need to implement a Synapse Analytics/ADF pipeline that an end user has to call by a web interface created by an Azure Function. So, is it possible to call a Synapse pipeline from an Azure Function? Thanks

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
3,390 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.
3,471 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,874 questions
asked 2023-08-22T22:07:33.42+00:00
pmscorca 177 Reputation points
commented 2023-09-06T02:41:16.9133333+00:00
JananiRamesh-MSFT 10,241 Reputation points
0 answers

Merge operation fails on Azure Synapse

I was trying to merge two tables with 634 columns each but was receiving “CREATE TABLE failed because column 'Column388' in table 'QTable_7d03ea86ac8f410d8456ac0783b25172_17' exceeds the maximum of 1024 columns.'” error. And it seems like there is a…

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.
3,471 questions
asked 2023-08-18T09:51:53.8633333+00:00
Atseg R 0 Reputation points
commented 2023-09-06T00:35:16.7066667+00:00
SatishBoddu-MSFT 18,481 Reputation points
1 answer

nvarchar(max) issue while incremental load

Hi, From salesforce to azure syanpse ded pool, full load is completed using autocreate table option. The data loaded and the nvarchar(max) updated in synapse. while incremental load the large data not supported because of nvarchar limit is 4000. Is there…

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.
3,471 questions
asked 2023-08-31T03:51:12.7933333+00:00
Ram Babu 20 Reputation points
edited the question 2023-09-05T23:50:33.12+00:00
SatishBoddu-MSFT 18,481 Reputation points
1 answer

Why managed virtual enpoints disapears after connect to azure git repo?

Hi folks, I created a synapse workspace (now only dev environment, but I will also have prod for CICD deployments). I am using Managed Virtual Network and private endpoints, after the creation everything looks good as you can see: Until now, so far so…

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.
3,471 questions
asked 2023-09-01T18:37:29.8633333+00:00
Federico Sardo 86 Reputation points
answered 2023-09-05T19:26:05.9033333+00:00
Federico Sardo 86 Reputation points