Missing ODBC drivers on spark 3.3 & 3.4 version
Hi Team - We are upgrading our Spark version from 3.2 to 3.4 and using the pyodbc module for SQL operations. However, we are encountering the following error when attempting to connect to the Azure SQL Database. Could someone please assist…
Import A website data as a table in ms fabric
i have a website i want to import as table and store in the datalake . its possible in power bi we can see as a table view, please give me a solution for this
How to make manual failover to Azure Gen2 namespace enabled for disaster recovery plan
As a disaster recovery drill test for Azure adls namespace enabled accounts . I could see failover option for blob storage and but for adls namespace enabled accounts the failover option is disabled. Can anyone help in know how to do failover for Azure…
synapse dedicated pool database size
What is the right way to find the database size, table's size, and other objects, the db size that is being billed by azure? Also where can be find the space occupied by the external tables(meta data)?
Getting Azure Synapse Analitics Tables Size - Query on documentation does not return correct data
Hello, I've a Synapase Workspace with a Sql Pool that has a SQL Server version 12.0.2000 . My requirement is to get the phisical space storage for each table in my database. Many peoples pointed me at…
How to copy the files from private github repo to a Azure blob storage
We have incoming files in the GitHub repo and the task is to ingest these files to Azure blob using Synapse. The file ingested to Blob in a container supposes that if we have the same file of the 2 different versions, the final version should only be…
Restore KekIdentity in Synapse Workspace
Hi, We deleted the managed identity for our synapse workspace that was the KekIdentity And now, when we open the workspace, none of the resources will load. I don't see any documentation on how to restore the KekIdentity for the Azure…
PySpark in Azure Synapse notebooks is very slow to do API requests
I am doing api requests in a PySpark notebook in Azure Synapse Analytics. On my local env, in a Python3 kernel, the script is going lightning fast. But in Synapse, the pyspark notebook is very very slow in doing request (like 1 in 20 seconds when i…
Built in SQL server in synapse is unavailable
Hi, Even after changing the firewall settings, the built in SQL server status is unavailable. Someone please assist. Step-by-step solution would be really helpful. Thanks in advance.
How to assign a private IP address to Synapse Analytics studio?
I am facing an issue connecting to a private SFTP server through Synapse Notebook. So, I was thinking of assigning a private IP address to synapse studio and get that IP whitelisted on SFTP server so that I can connect to it from notebook as well as…
Want to migrate from one Synapse workspace to another Synapse workspace
Hi team, Want to migrate from one Synapse workspace to another Synapse workspace. One being Dev environment, another one test environment. Please provide leads. Regards, NagaSri
How to Interpret Dataflow costs
How to interpret 'Azure Synapse Analytics - Dataflow' consumed quantity from monthly usage report? Any scenario based examples to estimate the pricing of Azure Synapse Analytics Dataflow?
Synapse Analytics Event Trigger Activation Error
Storage event trigger activation fails with following error: Forbidden. Role based access check failed for resource <storage-account> Please help.
Data is missing from management API using service principle. ex:resources
I have a requirement to load datasets from management.Azure.com (Management API), for example: Resources, Assessments, Tasks, and Secure Score. I have created a service principal in app registration and have been able to obtain the access token. However,…
check a field value is not null in derived transformation in dataflow
I am checking if a field(column) has data that is not NULL. How do i use NOT ISNULL(field1) in derived transformation ? I want to convert following code in derived transformation example: iif( not isNULL(field1), field1, iif( not isnull(field2), field2,…
Unable to connect Fivetran with public IP to ADLS Gen2 in Vnet with Private end point
Hi, I'm encountering an issue while trying to connect Fivetran to ADLS Gen2 in the UK South region. Here are the details: I have configured ADLS Gen2 as a destination in Fivetran and completed the prerequisites, including creating an SPN with appropriate…
Unable to connect serverless sql from Arcgis Pro client (SQL Server Authentication)
It was stated in https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-ssms, SSMS is partially supported starting from version 18.5, you can use it to connect and query only. I able to use SSMS to connect to serverless sql. But,…
How to upsert records from Azure Synapse dedicated SQL Pool table Dataverse table in Azure Data Factory?
I want to move data regularly from Synapse SQL pool to dynamics 365 dataverse, Everytime I do that I need to truncate the table in dataverse and run the pipeline in ADF, instead of truncating everytime I found we can do upsert to the dataverse…
Reached the maximum number of Synapse workspaces for Azure Students
Reached the maximum number of Synapse workspaces allowed for this subscription. Please contact Microsoft support to request an exception. Subscription: ededc91b-601b-4aa9-bae1-df7da64b1d65. Subscription offer type: AzureForStudents_2018-01-01. Current…
Did Azure stop support or adding features to Azure Synapse Studio?
Hello Azure Support Team and Azure experts, I am writing to express my concern regarding the current state of Azure Synapse Studio. As a dedicated user of this service, I have noticed that there have been no significant updates or new features added to…