After some time, viewing pipeline log links lead to wrong page
This is something I consistently experience if I use the same Synapse Analytics Workspace for a decent amount of time: My workflow is: Monitor Pipeline Runs Click on a run of interest This shows me the pipeline that ran and all the individual steps…
ALTER TABLE ADD COLUMN changes made to Synapse Delta tables in a Notebook do not reflect in Lake Database
Running the following spark.sql("ALTER TABLE example_table ADD COLUMN example_column STRING") Successfully adds the column to the Delta table and this can be verified by running %%sql SELECT example_column FROM example_table However when…
![](https://techprofile.blob.core.windows.net/images/d2tvFBHkuECHIdJFwoOShw.png?8DB3F8)
Custom logging in Azure Synapse Datapipeline to to log analytics Workspace - Help Requested
Requirement:- Want to add custom logging in azure synapse pyspark job using python logging module and spark config Getting error while implementing the same in the pyspark job ModuleNotFoundError: No module named 'pyspark.SparkConf pyspark script for…
Is Synapse Serverless Down?
As of ~12:53 CET all of our queries on Synapse Serverless have been timing out with the message: [This query cannot be executed because we can't get enough capacity for optimal performance in time. This can be an intermittent issue. Please retry…
azure synapse
hey i try to get sdk call that return me the info about the Azure Active Directory i cant find the sdk call for this
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
Unable to run an SQL query in Azure Synapse
Hi, I am unbale to run a simple sql query. It keeps throwing this following error. File 'https://storagecontainer/Financial Sample.xlsx' cannot be opened because it does not exist or it is used by another process. I assigned myself with Storage Blob Data…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
How to install com.crealytics.spark.excel to Synapse Spark Pool
Hello, I have spark pool with following properties: According to the instruction mentioned under the Q&A https://learn.microsoft.com/en-us/answers/questions/1185314/how-to-write-data-from-notebook-to-dedicated-sql-p?cid=kerryherger I have…
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
How to send data into displayHTML function in Azure Synapse Analytics
Hi, As mentioned in this link https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization I want to use D3.js to visualize my data. How do I send data from my pyspark dataframe into displayHTML() to visualize it?
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
Do Apache Spark Pools have a Service Tag?
Our company is rolling out more restrictive network security groups and I wanted to see if we could have our Apache Spark Pools' traffic be allowed via a service tag. When I tried to trace the IP address of the pools, the IPs varied widely so a static IP…
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
Issue with running queries on Synapse SQL Endpoint - This query cannot be executed because we can't get enough capacity for optimal performance in time.
Dear Community, I am getting the error ""This query cannot be executed because we can't get enough capacity for optimal performance in time."" when running a query using a SQL Serverless endpoint in Synapse Analytics This error…
Install Packages on Azure Synapse DEP-enabled workspaces
Hi I have a Synapse workspace with DEP enabled. Since PyPI libraries cannot be installed directly in the Spark pool, could you please advise on how to install the azure-mgmt-kusto, azure-kusto-data, and azure-keyvault-secrets packages on the pool? I…
Unable to run query on Synapse Serverless SQL Pool suddenly
I have a few of external table in an Azure Synapse Analytics Serverless SQL Pool which I need to query frequently. I suddenly got this error today. [This query cannot be executed because we can't get enough capacity for optimal performance in time. This…
Azure Synapse Error :This query cannot be executed because we can't get enough capacity for optimal performance in time. This can be an intermittent issue. Please retry later.
Strangely since morning Synapse SQL Serverless on one environment is not able to query external data in a storage account. This was running fine till now [This query cannot be executed because we can't get enough capacity for optimal performance in time.…
![](https://techprofile.blob.core.windows.net/images/QLHHSoRQ60CQmAEoYIXD-A.png?8DA845)
Synapse how to read excel with formula
Hello, in Synapse spark pool we need to read excel file that contains formula inside of cells (sometimes it is simple sum, sometimes complicated formula, sometimes it is reference to another spread sheet and cell). Unfortunately, we observe that some…
Import filenames from Azure Storage container to SQL Table using Azure Data Factory
Hi All, I am trying to import filenames from an Azure Storage container into a table in a Dedicated SQL Pool (formerly SQL DW) using Azure Data Factory. For example, I have around 2,000 JSON files in an Azure Storage container, and I would like to…
Azure synapse link creates model.json with no partitions
Hi, I am following this link below to copy dataverse data to Azure SQL DB using azure data factory pipelines. The model.json file created by my synapse link for dataverse is correctly creating the schema and attribute names for all the tables/entities.…
CopyData in ForEach
Dear all, I want to use the copydata activity in my pipeline. I have a csv file in my storage account, which has the list of the data i want to pass into the copy activity. I create a lookup activity first and then I try to use ForEach and put the copy…
High availability of Synapse dedicated SQL pool within a region
We have provisioned a Synapse dedicated SQL pool for our business. We need to make sure that the service is highly available within the region. This means we cannot have the data be moved to another region but need to make sure that the DWH is available…
Unable to use Synapse workspace features in Synapse Link for Dataverse when Synapse network is in private mode
Hi Team, We are using Synapse Link for Dataverse for syncing data from d365 to ADLS Gen2, which can be used for analytics in ADLS Gen2. As our Synapse analytics environment network is publically disabled and using private end points, we cannot enable…
Azure Synapse analytics with CosmosDB query is giving null values
Hi Team, we are storing data in Azure cosmos db for mongo and trying to query from Azure synapse serverless pool.when we query with Query items with full fidelity schema we are getting the values else we are getting string:value. can you please help us…