Azure cost optimization by Azure AI
Hi friends, Azure charges per hour ,but if I use the service for only 30 mins will I am charge for 1 hour? How does this costing mechanism works? And my requirement is to identity idle resources such as VMs and Databricks clusters , I need to use Azure…
coalesce and broadcast join
HI, what exactly happen between coalesce and broadcast join in backend on databricks level
partition in db
HI , what hppend in databricks backend when partion is applied to table level
How can i dynamically Flatten A Complex Nested JSON Structure in ADF
I am in the process of designing a solution. I need to load Rest API based complex JSON data into a flat file. I want to use the same pipeline for fetching different API result objects. My question is how can i dynamically flatten variant JSON files…
how to extend using Init script on DBFS
is there a way for me to extend the life of using current set-up of init scripts on DBFS? reason is I am getting errors now and i have not migrated my init scripts to UC/Workspace or Cloud storage and nothing runs now.
An error occurred when using odbc and managed identity to link azure databricks in the. net core
Environmental description: The app service has already been configured with managed identity, and the relevant permissions for this managed identity have been configured in Azure databricks. When the app service uses code to access Azure databricks, the…
LIST error
All, When I run "LIST 'abfss://containertables@sa.dfs.core.windows.net/';" against the EXTERNAL LOCATIONS I get the result in the first image. If I append __unitystorage and run "LIST…
Azure Databricks Lakehouse Monitoring queries
Hi Team, I was exploring on Azure Databricks Lakehouse monitoring. I have few queries on this: When I am running a "refresh metrics" irrespective of an automated schedule or manual refresh, which compute does it run? There is no mechanism to…
execution plan in databricks
How to check execution plan in data bricks select * from cte
How to read nested xlsx files in Azure Data Factory
How we can read these types of nested xlsx files in ADF
How to query Databricks audit logs?
Hi, I would like to ask where the Databricks Audit Log files are stored on the DBFS. And is there any way that I can query log files? Thanks.
Databricks jobs are failing with the insufficient privileges error
When running the jobs in databrick user is getting the insufficient privilege error, but user do have all the privileges like select, read_metadata, modify, create and owner as well on the respective database.
How can I delete my Azure Databricks workspace when the workspace resource has already been removed?
As the title says I have an Azure Databricks Workspace where I have deleted the Workspace resource in Azure. However, the workspace still appears in the Account Console. From here I can log into the workspace but not create clusters etc. When I click on…
I am getting error while displaying the dataframe in azure databricks
df.show() is working but display(df) is not working df=spark.read.csv("abfss://demo@anshadls2001.dfs.core.windows.net/data/",header= "True") display(df) (1) Spark Jobs Failed to store the result. Try rerunning the command.Failed to…
Sync the tables from one azure databricks workspace to other databricks workspace or to adls gen2
Hello Team, We have two UC enabled databricks workspace. And we have to sync tables created in one Azure databricks workspace to other databricks workspace using PAT/any other reliable way or to adls gen2 account. Request you to let me know is there a…
Raising the limit in Azure Databricks identities
Context: The Azure Databricks documentation states that "You can have a maximum of 10,000 combined users and service principals and 5,000 groups in an account. Each workspace can have a maximum of 10,000 combined users and service principals and…
How to use AWS Databricks note book in ADF..?
Hi Team, I want to create Linked service in ADF with AWS Databricks notebook. Can you guys help me with list of steps that i need follow. Regards, Naveen.
Custom text single label classification - Model API Consumption within Databricks
Hello together, i trained a model within Azure Language Studio , Custom text single label classification - and i want to consume Model API within Databricks Notebook. I get always below given error, kindly asking for your help. Thanks. Error: HTTP…
How to fix timeout error when clreating compute cluster on azure databricks.
Azure error message: [id: InstanceId(e8b82690e17a4624a152afb20dce5339), status: INSTANCE_LAUNCHING, workerEnvId:WorkerEnvId(workerenv-3367469989580530), lastStatusChangeTime: 1713836219115, groupIdOpt Some(0),requestIdOpt…
How to ingest CDC data from SQL DATA SYNC to Event hub?
Hi we have a scenario to implement real-time CDC from SQL DATA SYNC to Azure SQL DB. Which tools are good for near real-time processes and prices as well. By using data bricks we can merge stream data into delta lake. But How to ingest real-time…