Content
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 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…
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
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…
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…
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 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…
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…
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
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 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,…
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…
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…
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…
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(…
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
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…
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…
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…