Content
Azure Access Needed for Cloud Data Router Project as a Student
Greetings Microsoft Azure Team, I hope you are doing well. I am Aryan Sadana, a B.Tech student at Samrat Ashok Technological Institute, Vidisha. I am contacting you to ask for access to Microsoft Azure services for a cloud data router project that is…

How to update the secret in keyvault from Synapse notebook
Hi, I'M generating a token in the synapse notebook. I want to update my secret stored in keyvault every time I run my Synapse notebook how can I achieve it could you please provide me the Python code so that I can change the secret value every time I run…

Sharepoint online list connector failed to connect
Hi, I am trying to fetch data from sharepoint online list to ADLS using synapse pipelines. For this I tried to follow the documentation as follows: …

Loading data incrementally from Synapse serverless pool External table to Azure SQL by using microsoft standard template pipeline but 'MergeData' script is failing with the error code "2011" and message is "Argument {0} is null or empty.\r\nParameter name
Loading data incrementally from Synapse serverless pool External table to Azure SQL by using microsoft standard template pipeline but 'MergeData' script is failing with the error code "2011" and message is "Argument {0} is null or…
Long running Synapse Pipeline failed with InvalidHttpRequestToLivy exception
I have a long running azure synapse pipeline which will run notebook on spark pool. After 2 hours It failed with below exception. { "errorCode": "6002", "message": "InvalidHttpRequestToLivy: Submission failed…
ADF throwing 403 error while copying
Hi, I have Azure synapse analytics setup with private endpoint and I am running a ADF pipeline but it throws the error: { "errorCode": "2200", "message":…
ADF stored procedure glitch when ran via trigger
I have a database stored procedure with one of below code snippets in it. Now problem is when I call this stored procedure via ADF pipeline stored procedure activity. The Database SP is working as expected when ADF pipeline is ran in debug mode or SP is…
Unable to run Sql queries in Azure Synapse. Error: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.NullPointerException
Hi, I have deployed a Synapse workspace through devops and running some sql queries inside it. I can run simple SQL queries but can not run anything related to Delta Table. Commands like - SHOW TABLES %%sql CREATE DATABASE AdventureWorksLT2019…
Global parameters for Synapse Analytics pipelines
Hi, I need to implement a dwh solution by using Synapse Analytics and I'd like using global parameters as in Azure Data Factory, but it seems that a such feature isn't present in Synapse. Now, is global parameters feature supported in Synapse,…
Cross region Dedicated SQL Pool data consumption
Hi, I have a requirement as below kindly show some light. We have Dedicated SQL pool in one resource group would say for global requirement. For local country requirements, we are using serverless sql pool, azure sql DB in different RG. Both resides in…

select statement on notebook in lookup transformation in ADF
Hi Expert. how to use the select statement on notebook to pass parameter in lookup transformation
ASKs FOR LOG ANALYTICS IN SYNAPSE WORKSPACE
1.- I would like to know how I can view the login, session failure and logout of a user in the synapse workspace log analytics when they enter the synapse studio? 2.-I would like to know why in the SqlSecurityAuditEvents table of the synapse workspace…
How to make the Azure Synapse blob trigger work?
I've been struggling for weeks to activate the blob event trigger in Microsoft Azure. The goal is to initiate an Azure Synapse pipeline whenever a blob is created in the path "requests/inputs/{some_blob}.json." I completed the configuration,…
How can I install a chrome browser in synapse notebooks?
I am using a synapse notebook with pyspark to run Selenium. Using bash code in the notebook (%%sh) I was able to download a google chrome driver but my trusted-service-user username is not able to access the root and use sudo to download the Chrome…
Tableau connection fails intermittently to synapse database
I am having intermittent fails in tableau jobs, please see the job execution summary Observation: •There is no difference in connection parameter for both success and failure. •Both the Jobs are executed from Node-4 and the Driver is also same. •The…
How to use Azure Synapse link to replicate D365 data from power apps platform/ Dataverse to ADLS 2.0?
I need to discontinue to use the "Data export service" from Dynamic 365 to replicate data to ADLS 2.0, and configure the same replication using Azure synapse link. Can someone please share the process?

How to fix error with OPENROWSET view on Delta table?
Error: Query failed because of compute container failures or other transient errors, and retry exhausted. This can be an intermittent issue. Please retry later. OPENROWSET view on Serverless Pool (format = delta) is failing with the above error. All…
Migrating Dedicated SQL Pool to Serverless
Currently the setup is a dedicated sql pool (DW300). The tables are external tables, which have parquets as a source. We would like to migrate this to serverless. How can we do this migration ?
How to point External Tables in Dedicated SQL Pool to Storage Secondary End Point ?
All, What is the procedure to point external tables in the Dedicated SQL Pool to the container secondary endpoint, in case of a disaster recovery scenario when a pool is restored in the secondary region? Which method can be used for this task? Your…
How to get logs from synapse job to send to Azure eventhub via Spark Diagnostic emitter extension
Hi - I am trying have logs sent to an Azure Eventhub via the Azure Synapse Diagnostic Emitter Eventhub. I am able send and receive logs via a notebook by having the pool that the notebook runs configured following the above documentation. import…