The dedicated sql pool memory usage is constantly 95%-96% without any activity. It's running on DW300c service level. Is there a way to find out what exactly is utilizing this much memory?
The dedicated sql pool memory usage is constantly 95%-96% without any activity. It's running on DW300c service level. Is there a way to find out what exactly is utilizing this much memory? I'm trying to avoid increasing the service level without finding…
Azure Synapse Analytics
There are not enough vcores resources available in the workspace while running the synapse dataflows
Hi Team, we are getting the below error dataflow while running in for each activity, Could you please help us to fix this **There are not enough resources available in the workspace, details: 'Your job requested 8 vcores. However, the workspace…
Azure Synapse Analytics
I need to get the Synapse workspace Outbound IP address for my workspace
I need to get the Synapse workspace Outbound IP address for my workspace
Azure Synapse Analytics
Azure Synapse Runtime for Apache Spark 3.5 Java Version
The recently released Azure Synapse Runtime for Apache Spark 3.5 mentions support for Java 17. However, the Github page for this runtime specifies Java version 11.0.27…
Azure Synapse Analytics
Create DB identity in synapse notebook
Hi, I want to create a Synapse notebook where can read data from Azure SQL server DB. So I need to connect the DB via jdbc and enter the user name and password like code below. Is there a way where I can store this username and password somewhere so that…
Azure Synapse Analytics
Issue using linked service v 2.0 on notebook
Hi, I am accessing the DB in Synapse notebook with linked service version 1. It is working ok but when I changed to version 2, error occurs. Is there any additional setting I need to set in Notebook ? Thank you!
Azure Synapse Analytics
Getting Error: Failed to save Arm Templates. Error: { "message": "Sorry, your input was too large to process.
We merged Pull requests which contained many changes in Synapse pipelines and then we were trying to publish the changes and generate a ARM template. Publish was successful The generation of ARM template got failed. Generating templates Failed to…
Azure Synapse Analytics
Activating Inactive Data Explorer Database from 'Add Resources'
The Data Explorer database from the 'Add Resources' section appears to be inactive in the drop-down menu. What steps are needed to activate it?
Azure Synapse Analytics
Using filepath() in synapse
I created an extrenal table in synapse and try to use filepath function on it, but got below error: Here is my table: CREATE EXTERNAL TABLE bronze.trip_data_green_csv ( VendorID INT, lpep_pickup_datetime datetime2(7), …
Azure Synapse Analytics
Not able to create an azure synaps analytics workspace in west europe
I'm trying to create an Azure Synapse Analytics workspace located in westeurope but when I try, I recieve the error: {"code":"ValidationFailed","message":"Workspace request validation failed, check error details for…
Azure Synapse Analytics
Does Synapse Dedicated SQL Pool support wildcards in the LOCATION of external tables?
Does Synapse Dedicated SQL Pool support wildcards in the LOCATION of external tables like below: CREATE EXTERNAL TABLE db_public.trip_data_green_csv ( VendorID INT, lpep_pickup_datetime datetime2(7), lpep_dropoff_datetime…
Azure Synapse Analytics
User Name and Password for Dedicate SQL Pool
I created a dedicated sql pool in my synapse work space and try to connect to it using DBeaver, but I don't know my user name and password, I didn't remember I set them when I created the dedicated sql pool.
Azure Synapse Analytics
How to find the reason behind org.apache.spark.sql.delta.DeltaErrorsBase.invalidCommittedVersion
I have a notebook that for several tables fetch a new version of the table from landing (ASDLGen2) and overwrite the existing DeltaTable (external) with the new version.…
Azure Synapse Analytics
Dataverse Synapse Link to Lake Database pulling Date and Datetime fields.
Our Dynamics Dataverse is using the Synapse Data Link to move data to Azure Data Lake gen 2. We then use a Synapse Analytics Data flows to transform the data to a Lake Database parquet file. Up until last week this was working great, but recently any…
Azure Synapse Analytics
Logic app to retrieve the latest file from a blob folder
How can I create a logic app that retrieves the latest file from a blob folder when a Http request is received, where there are multiple files, and sends it as an attachment? Are there any specific steps or configurations required for this process?
Azure Data Lake Storage
Azure Blob Storage
Azure Logic Apps
Azure Synapse Analytics
Azure Data Factory
Can't ask for bigger limit for Synapse workspaces on subscription
When I try requesting a bigger limit, I'm faced with the following: So, no value is ever gonna be accepted. Also, the limit I'm told I actually have when I try creating a new workspace is 20. Couldn't open an actual support request, because it…
Azure Synapse Analytics
Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length
Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…
Azure Synapse Analytics
SQL Server Analysis Services
Unable to create a managed private endpoint in synapse (because it already exists)
If i try to create a managed endpoint in synapse i get the following error message: Failed to save AzureSynapseAnalytics695. Error: {"CorrelationId":null,"StatusCode":409,"Message":"Resource already exists:…
Azure Synapse Analytics

Random internal server errors: Cluster creation failed due to unexpected error
I keep getting this error in random pipelines I'm running. How can I retry it automatically? { "errorCode": "145", "message": "Internal Server Error in Synapse batch operation: 'Cluster creation failed due to…
Azure Synapse Analytics
Azure Synapse: Failure happened on 'Sink' side, when copying data from ADLS2 to Cosmos database
Only for one specific dataset, copying data from ADLS2 to Cosmos database is failing. This is a consistent repro. But error details not providing any information on the reason for this issue. I see input data is working as expected. Error: {…