ReachedPerSubscriptionWorkspaceLimit
When I create a synapse workspace, I have this error: { "code": "DeploymentFailed", "target":…
Azure Synapse Analytics
Access Control in Synapse Dedicated SQL Pool and Impact of Notebooks
Hello, I am looking for some critical information related to data security aspect within the Synapse. Below is our current scenario, We have a Synapse dedicated sql pool in the production environment. The dedicated sql pool has multiple schemas of which…
Azure Synapse Analytics
Intermittent Spark Pool Failures and Increased Startup Time After Upgrading to Spark 3.5 in Azure Synapse
We recently upgraded our Synapse Spark pools from version 3.4 to 3.5. As part of the upgrade process, we followed these steps: Removed custom packages from the pools Upgraded the Spark pool version to 3.5 Re-attached the required packages After the…
Azure Synapse Analytics
Unable to Create Synapse Workspace Due to SQL Server Provisioning Restriction
Description: I am trying to create an Azure Synapse Analytics workspace in my subscription: Subscription ID: <<Removing due to security compliance>> Resource Group: <<Removing due to security compliance>> Region Attempted:…
Azure Synapse Analytics
Error when deploying Synapse
I keep getting the below error when trying to deploy Synapse in Azure. I have tried to change regions and I have unregistered and re-registered services multiple times.. Please help Location 'xxxx' is not accepting creation of new Windows Azure SQL…
Azure Synapse Analytics
Synapse PySpark Notebook issue with Storing Streaming data to ADLS
In Synapse PySpark notebook I am reading data from Event Hub and trying to write/save to ADLS using spark structured streaming as below:- json_schema = StructType([ StructField("id", IntegerType()), StructField("temp",…
Azure Synapse Analytics
How can I connect a Fabric Trial to Dataverse?
I am trying to connect Dataverse to Azure Synapse Analytics in a Fabric Trial. The Power Apps wizard asks for Subscription ID and Resource Group. The problem is that the Fabric trial does not appear in my list of Azure Subscriptions. (I have the Global…
Azure Synapse Analytics
Optimized Apache Spark pools cluster to run parallel notebook in Synapse
I have a cluster(apache spark pool) in azure synapse analytics of the below size With the above cluster configuration when I am using this same cluster in my synapse pipeline to run notebooks I am only able to run 8 notebooks in foreach parallelly. …
Azure Synapse Analytics
How to collect information of Users running Insert/Update/Delete Command on the Synapse Pool?
I am looking for a solution which collects information of users who have executed Insert/Update/Delete command on synapse. Tried the Log Analytics Route but the table SynapseSQLPoolRequests only contains Statement type and not Login ID, DMVs store 10,000…
Azure Synapse Analytics
Azure Synapse Link in Power Apps stopped sending new files after Oct 16 – now appending to existing files
We have an Azure Synapse Link configured with a Data Lake in Power Apps.Previously, we received new folders with date and timestamp every hour, each containing fresh data. However, since October 16th, no new timestamped folders have been created.…
Azure Synapse Analytics
How do I monitor a pipeline deployed on Azure Synapse and send email if it fails?
I want to monitor the pipelines that are deployed in Azure Synapse workspace and I want an email if it fails. How do I do this? Logic app doesn't have built-in email notification.
Azure Synapse Analytics
Can only deploy synapse to a single region
I have found that we can only deploy azure synapse to a single region. The Microsoft.Sql resource is registered and we have two synapse resources deployed to centralus already, but cannot deploy to any other region. We are getting the error…
Azure Synapse Analytics
Azure Synapse Copy Activity REST sink HTTP compression is corrupting the payload
I believe there is a bug in azure synapse that is causing the payload to be corrupted on a REST sink with http compression turned on. When http compression is set to GZIP the payload is either empty or corrupt, it's hard to say. Is this a known issue?…
Azure Synapse Analytics
Not able to enumerate SQL Serverless Synapse database from purview
Our purview instance is in a different Subscription (Prod Subscription) and the synapse workspace that we are trying to connect is in a different subscription (Dev Subscription). We followed this documentation and set up all the permissions…
Azure Synapse Analytics
Synapse Serverless SQL pool connection with OPENROWSET to Cosmos DB fails
We have Azure environment with Synapse Analytics that should use Serverless SQL pool to get data from Cosmos DB. Connections are done with private endpoints. And I can see the Cosmos database and container correctly in linked section of Synapse. But if I…
Azure Synapse Analytics
Need to integrate Netsuite with Azure service azure synapse analytics . basically copying the data from netsuite to Azure blob or Azure sql
Need to integrate Netsuite with Azure service azure synapse analytics . basically copying the data from netsuite to Azure blob or Azure sql
Azure Synapse Analytics
Frequent connection issues to Synapse from Qlik Replicate application after Windows patches in early September
Hi, Our client has an application called Qlik Replicate that writes data to Azure Synapse Analytics which has been functioning fine till a bit over month ago, when Windows patching was applied. The connection to Synapse would drop very frequently at…
Azure Synapse Analytics
User gets "Login failed for user '<token-identified principal>'" when creating a DB in Synapse serverless SQL pool, despite having admin roles
Hi everyone, I have an Azure Synapse Analytics workspace, and I’m trying to give another user access to create a database in the Built-in serverless SQL pool. Here’s what I’ve done so far: In the Synapse workspace, under Manage → Security → Access…
Azure Synapse Analytics
How to connect dynamics F&O with power bi
Hi , i need to connect dynamics 365 f&o with power bi to analyze data , but i need a better way than ODATA feed as it takes a long time to , how can i achive that ?
Azure Synapse Analytics
Azure synapse - Issue with quotas increase
Hello, I have a problem with some Azure Synapse Analytics: I currently have 2 Synapse My quota is set to 250 When I try to create another one, I have the following error: Reached the maximum number of Synapse workspaces allowed for this subscription.…
Azure Synapse Analytics