Salesforce connector : I am getting TaskCanceledException error while doing full load for Service__c and Service_Step__c entity.
Hello, We have recently transitioned to the Salesforce Bulk API 2.0 Connector in Azure Data Factory (ADF) for our integration processes. As part of our use case, we perform a full data load for all Salesforce entities once a month. However, we are…
Can't login to Azure Databrick account console
Hi, I'm a Global Admin but can't login to the databricks account. Tried with different users, different browsers, can't login to the console. https://accounts.azuredatabricks.net/ Please, any help? ,
Loading data from Databricks pyspark dataframe into Snowflake
Hello, I am trying to load a large dataframe (~ 50 million records) from Databricks into Snowflake. I am using the below code and it takes more than 2 hours to load the data into the target Snowflake table. Is there a different configuration/approach…
How to achieve the transaction replications setup from many on prem sql in azure.server
Currently we are using transactional replication to bring real time data from on prem sql source servers to azure db destination. I need to migrate this setup in azure with real time availability of data. I used the cdc ad event triggered methods but…
ADF pipeline to read the data from UC table to adls gen2 account
Hello Team, We have a requirement to create Azure Datafactory pipeline to read the data from UC table, access on the table is provided ( to Azure Datafactory Managed Identity) and copy the data into adls gen2. Is there a way or article to implement this?…
Notebook IP address blocked by workspace IP ACL
Hello, I have a databricks workspace for which I have defined an IP address ACL so that it can be reached by selected addresses (our corporate network). I am executing some python code on a notebook in the workspace. The code is trying to connect to a…
Databricks Excel ODBC driver bug
Hello! I might have experienced a bug with the ODBC driver. We have an issue where given certain priviledges in databricks, the ODBC driver is unable to show any schemas/tables. When we click the 'expand' button on any catalog in the list (of which we…
Processed HTTP request failed. Failed to connect databricks
I have also verify it through the access token but still on the same error. Please look into it.
Need for volumes in Databricks
Why do we need Volumes when we can access the location using external locations? The doc says it is to add governance, but we can already govern using external locations. So, why add another layer of governance? I am guessing that instead of giving…
Unable to Create Storage Container and Delete Storage Account in Azure Portal (Access Denied Error)
I'm encountering an issue in the Azure portal where I can't create a new storage container or delete an existing storage account.When attempting to create a storage container named "demo," I receive the following error: "Failed to create…
JDBC\ODBC connection to Azure Dataricks fails
Hi, I referred the following links in net and tried all, but still I am not connecting to Azure Databricks database https://docs.databricks.com/integrations/bi/power-bi.html https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html …
How can you access Azure resources using user-assigned managed identities within Azure Databricks?
We're trying to move to using managed identities where we can. Is it possible to use user-assigned managed identities to access resources such as sql server databases, application insights, log analytics etc. through Azure Databricks? We thought added…
Enabling Azure PIM Disables user within DataBricks
We have successfully stood up Azure Databricks in our tenant. We are leveraging SCIM and User Provisioning to grant our users SSO access into DataBricks. We are trying to layer in an additional layer of security to meet our current security standards by…
How to read delta/csv files in ADLS thru Databricks SQL Warehouse
I am trying to read a csv/delta file in ADLS thru Databricks SQL Warehouse. I am trying DSN less connection string option, as per the below article https://stackoverflow.com/questions/65334114/is-there-a-way-to-connect-to-databricks-using-ado-net I have…
differnce between synapse and databricks
What are major difference between synapse and data bricks and under what circumstances one should use synapse and vice versa
Streaming upserts constantly report mysterious log, are very slow
Our streaming batch upserts are very slow and constantly report: 20/12/03 23:38:04 WARN RetryTolerableRenameFSDataOutputStream: Failed to rename temp file…
Parallel Writing of Data to ADLS Delta Storage Causes "The specified path already exists.", 409, PUT" Error
I have a Spark (Spark 3.1.2, Scala 2.12) application that reads json records from a table. The records are distributed across cluster executors. In the application, I have used foreach function to loop through the records in the table. For each record,…
Not able to see Manage Account in databricks worksapce
I am the owner of a databricks workspace. I want to create a metastore but I am not able to see Manage Account in databricks worksapce. I have created a premium workspace and I have a trial subscription.
Azure databricks integration with Github Enterprise
I am having DevOps configured with Azure databricks but now we are migrating from DevOps to Github Enterprise. To point our Azure databricks with Github enterprise repository from Azure databricks workspace post linking the Github encounter the below…
Data Factory Data flow Error Cluster creation failed
I have a data factory pipeline that's been running for a year without any issues then suddenly we received an error Internal Server Error In Synapse batch operation: 'Cluster creation failed due to unexpected error. Please retry' This error came from a…