Getting TokenNotFoundInConfigurationException error when uploading a Python wheel as workspace package in Synpase
Hello Everyone I'm using Azure Synapse to run my Spark pipelines. I've build my pipeline to use a custom library code from utils package of the same project to perform some operation. To access the utils.pipeline file, have packaged my entire project in…
GIT enabled Synapse Workspace: is there any way to get the current branch name via Python?
Hi, I was wondering if there is any method (or some other way) to retrieve the name of the currently selected GIT branch programmatically within a running Synapse Notebook session using Python. To make thinks even more complicated: the Synapse…
Deployment Failed in Azure Synapse: SKU 'name' missing error
"I'm trying to deploy an Azure Synapse Workspace and keep encountering the following error: 'The request content was invalid and could not be deserialized: Required property 'name' not found in 'sku'.' The full error is: { "code":…
Read data from Databricks Delta Sharing to Azure Synapse
Hi, I am trying to read the data from Databricks Delta Sharing and write the data to Azure Synapse by referring this documentation https://docs.databricks.com/en/connect/external-systems/synapse-analytics.html#language-python I have constructed below…
issues in synapse pipelines which accessing the checkpoints key with input parameters
hello team, i am getting synapse analytics pipelines failures with error referring the checkpoint mistaching with the checkpoint in input parameters. tried to check the input as the respective dataflow is fetching data from cosmosDb with CDC approach…
Unable to create synapse workspace - property 'name' not found in 'sku'
I'm trying to create a new synapse workspace and receive the following error. { "code": "DeploymentFailed", "message": "At least one resource deployment operation failed. Please list deployment operations for…
How to fix 500 error on postman API
Hello Team, I am trying to create external APIs for my serverless SQL pool on postman. So I have created required access tokens using this URL (`https://login.microsoftonline.com/
Issue with Corrupted Azure Synapse Workspace During Creation
An issue has arisen with an Azure Synapse Analytics workspace during its creation process. Due to an error or misconfiguration during setup, the workspace became corrupted. As a result, the workspace is in a non-functional state and cannot be deleted or…
How to Execute DROP VIEW Command in Synapse Notebook with SQL Serverless Pool Connection?
How to Connect Synapse Notebook to SQL Serverless Pool for Executing DROP VIEW Command? I’m working with Azure Synapse Analytics and need to connect my Synapse Notebook to a SQL Serverless Pool to directly drop and create views. However, when I try…
Select transformation output schema is empty after renaming columns
I've followed the example from the link: https://learn.microsoft.com/en-us/azure/data-factory/tutorial-data-flow-dynamic-columns It's exactly what I need for my project, but unfortunately, no matter what I do, the output schema of the select…
unable to edit dataflow in synapse after creating it.
I have created dataflows in Pipeline but they are not editable. I am clicking on it to edit but it's not opening for me to edit
How to limit synapse spark to only send WARN/ERROR logs to log analytics workspace ?
I have followed the steps here: https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-log-analytics But now all the internal driver/executor logs are getting sent to log analytics workspace, which is leading to storage…
Session failed. Run the notebook to start a new session.
I've recently created a spark pool in Azure Synapse Analytics. However, when i try to run a notebook, i got this error: Spark_Ambiguous_SparkSubmit_SparkSubmitProcessFailedExitCode1: Livy session has failed. Session state: Dead. Error code:…
How to restore a synapse SQL pool datawarehouse database
Hi All. Working on recovering a deleted synapse analytics workspace which also has a SQL pool, is there a way to recover if its deleted ? At the time, the deletion encountered an error and therefore was not fully deleted. but i was unable to recovery the…
Add Synapse Administrator role assgiment for manged identitiy - 403 authorization error
Hey, I am implementing logic that assigns roles in Azure Synapse Workspace. I have the following setup: Marketplace app that deploys resources to customer subscriptions (it has denied assignments) creates Azure Synapse Workspace creates managed…
Servicenow linked service used connectivity vendor
I am interested in using Servicenow Linked Service to extract data from Servicenow. There are two linked services available; the legacy version and version 2 that uses table API. The documentation mentions a built-in driver for enabling connectivity. Can…
How to read cosmosdb mongodb API objectId field from a synapse analytical collection link
I am linking Synapse serverless sql pool with Cosmosdb with Mongodb API. For background, MongoDb sets its _id and reference ids to objectId(). To do a SQL join on this field, we need to convert the value to string. This is how the data…
Cant find in the metrics about the storage used in dedicated sql pool under Azure Synapse Analytics.
my account have been charged 0.68usd / day when adls gen2 shows me the storage uses 8.7 gb. it does not make sense. are there any way to monitor the exact storage used in Azure Synapse Analytics SQL Storage - Standard - AP Southeast in dedicated sql…
how to update apache spark pool version from3.3 to 3.4 if don't have any spark pools under the synapse workspace
i dont have spark pools configured under synapse analytics workspaces so how can i update syanpse spark pools to 3.4 version. is there any dependency validation required for this?
not being able to create azure free account or even to upgrade to pay as u go
how am i suppose to learn the certification if am not being able to create account. i am really frustrated that am not being able to create account. provide me an efficient way to create account to practice for my certification