unity catalog issue, i build 2 databricks workspace, but can not manage accounts
I created two workspaces in Azure Databricks, but I cannot find the 'Manage Accounts' option in my account. How can I access this service?" I can not use unity catalog service , any action I can fix this issue? thank you
How can I reliably automate granting admin consent for an Azure Databricks SCIM app using Terraform and Azure CLI without manual intervention?
I am trying to automate the creation of an Azure AD application (specifically, an Azure Databricks SCIM app) and grant admin consent for its API permissions using Terraform. The required API permissions include Application.ReadWrite.All,…
Read AppServiceConsoleLogs and push to Blob Storage container/table
Hello Team, we have a webapp python Django based. We are generating custom logs for user actions using code below. Settings.py: LOGGING = { "version": 1, "disable_existing_loggers": False, "formatters": { …
Passing Boolean from Data Factory to Databricks Notebook
I have a pipeline in Azure Data Factory that includes an activity to call a Databricks notebook. I want to pass a Boolean parameter from Data Factory and use it in the notebook for conditional logic. To achieve this, I passed a string parameter with the…
Create global temporary stored procedure or global temporary table
Hi, In ADF I am using self-hosted to create linked service. In SSIS, I know we can create global temporary stored proc & table. I want to know can we do similar to that in ADF too. When a pipeline executes, it needs to create global temporary stored…
How to fetch CRM Dynamic Application Audit Logs from MS Purview through Azure Databricks?
Hi, We are looking to fetch AuditLogs of Dynamics CRM from MS Purview through Azure Databricks. I know we can fetch through 'Microsoft Graph Rest API beta version' but in the page linked below it said it is not supported for Production…
Using Azure Databricks Clusters with Unity Catalog and Managed Identity Support.
We are leveraging Azure Databricks for our Data Engineering project and intend to utilize Databricks clusters that support both Unity Catalog and Managed Identity. However, according to the Databricks documentation…
How to extract ProcessInstanceHistory object records using new Salesforce connector from ADF
We are trying to extract the data from Salesforce for the ProcessInstanceHistory object through the new Salesforce connector. There is a limitation for the new connector as it doesn't allow inner SOQL query for Bulk API. We have tried using REST API but…
Lineage was extracted from unity but duplicate process created for same table In Purview
Hi Microsoft Team, I have registered and scanned databricks unity catalog in azure purview and then all tables,views metadata came into purview and that time lineage is not pulled into azure purview and now i have enabled access schema in unity catalog…
All Azure services cost report
Hi friends, I need to develop a report that shows the cost accrued to each Azure service such as ADF, Databricks, and other services. The report should include high-level and granular costs against Azure services. I understand Azure cost management does…
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,…
Databricks Libraries Installation SSL Error
HELP ME TO SOLVE THIS ERROR- PLEASE ELABORATE IN DETAIL... Library installation attempted on the driver node of cluster 0606-104958-63c5i7so and failed. Please refer to the following error message to fix the library or contact Databricks support. Error…
Query Regional Core Usage by Resource
I very frequently run in to the "Operation could not be completed as it results in exceeding approved Total Regional Cores quota" error. I understand what this means and how to increase my subscription's limit, but first I would like to…
Merits and Demerits of Handling Large Data set from Azure Data bricks in Integration with Power BI
Hi, I would like to know about what are the various factors to consider when handling Larger Data set from Azure Data bricks in Integration with Power BI. The complete list of Merits and Demerits of Azure Data Bricks with Power BI. Thanks
Can I take the Azure Data Engineer exam from US, while I booked it from other region?
Hi, I have purchased Azure Data Engineer from India, but had to move to US for work. Can I attempt it from US as per the time zone I booked the exam ?
Azure Databricks Usage Cost
Hi Team, We have an Azure Databricks subscription with reservations, and multiple workspaces for different projects. We want to monitor our cost usage in the best way possible. I've explored two options: Creating a consumption dashboard in the Account…
Constantly Running Interactive Clusters Best Practices
Hello there, I’ve been creating an ETL/ELT Pipeline with Azure Databricks Workflows, Spark and Azure Data Lake. It should process in Near Real Time changes (A Change Data Capture process) from an Azure SQL Database. For that purpose, I will have…
Delta Table Partitioning - why only for tables bigger than 1 TB
Hello there, I’ve been creating an ETL/ELT Pipeline with Azure Databricks Workflows, Spark and Azure Data Lake. It should process in Near Real Time changes (A Change Data Capture process) from an Azure SQL Server Database. I have a bunch of big tables…
Getting Different results when I am running the Global Templary table (Transform Query)
Hi Team, We are running a logic in an Azure Databricks notebook using PySpark. Initially, we read data from ADLS and load it into a global temporary table to perform data quality checks. We then recreate the same temporary table. Afterward, we use these…