Unexpected Azure Databricks VM Pricing – Matches RI Cost Without RI Purchase
I have an Azure Databricks customer with both Dev and Prod environments. The concern is regarding the VM cost associated with Databricks. The VM type is D4ads_v5 Linux, located in Southeast Asia. According to the Azure Pricing Calculator, the expected…
I’ve been using the following code for years to determine the latest table version using Databricks’ Time Travel feature without any issues. However, after adding a new row to the table recently, I encountered the following error:
Cannot time travel Delta table to version 1. Available versions: [3, 23]. This behavior is unexpected, as the code has worked reliably until now. Here is the code I’m using: from delta.tables import DeltaTable import pyspark.sql.functions dt =…
How to set up secrets in Azure Databricks Cluster configs?
Hi there, I am currently working on setting up Spark configurations within our Databricks cluster to access Azure Data Lake Storage (ADLS) using OAuth and a service principal. Our goal is to configure these settings at the cluster level, so that we can…
Automate Lineage into azure purview from Azure Databricks Unity Catalog
Hi Team, In my last question someone from Microsoft team suggested to create lineage tables separately and scan the databricks unity catalog source and then lineage automatically came to azure purview. But when I tried this solution, I'm not able to get…
Unexpected Azure Databricks VM Pricing – Matches RI Cost Without RI Purchase
I have an Azure Databricks customer with both Dev and Prod environments. The concern is regarding the VM cost associated with Databricks. The VM type is D4ads_v5 Linux, located in Southeast Asia. According to the Azure Pricing Calculator, the expected…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
Troubleshooting Azure Databricks to On-premise MS SQL Server VPN tunnel instability
We have a VPN tunnel that connects Azure Databricks to an on-premise server. The tunnel is however instable, and the phase 2 selector goes down daily at random times. We did an audit and it does seem to be mostly after working hours, varying from 7pm to…
Azure Databricks - Database Error
I created the following database in Azure Databricks - CREATE DATABASE IF NOT EXISTS f1_processed LOCATION "/mnt/<Container_Name>/<Folder_Name>" Database got created under "hive_metastore" Then I'm trying to create a…
Pyspark dataframe is taking too long to save on ADLS from Databricks.
I'm running a notebook on Azure databricks using a multinode cluster with 1 driver and 1-8 workers(each with 16 cores and 56 gb ram). Reading the source data from Azure ADLS which has 30K records. Notebook is consist of few transformation steps, also…
Can't access the Azure Databricks Accounts Console
Hi there, When I tried to log on to https://accounts.azuredatabricks.net/login, I encountered an error. It says: Selected user account does not exist in tenant 'Microsoft Services' and cannot access the application…
Getting error while creating database
In Azure Databricks, I'm getting error while creating Database with the following syntax : - CREATE DATABASE IF NOT EXISTS <DB_Name> LOCATION "/mnt/<Container_Name>/<Folder_Name>" error is 1 "CREATE SCHEMA in Unity…
Unable to Find 'Manage Accounts' Menu for Unity Catalog Metastore Setup
I'm trying to set up the Unity Catalog Metastore, but I can't find the 'Manage Accounts' menu in the 'Accounts' section, so I can't access the account console. Can anyone help me with this issue?"
Is Azure Synapse being discontinued?
Hello everyone! I recently heard that Microsoft might be discontinuing the development of Azure Synapse, and I’d like to know more about it if that’s the case. If it is being deprecated, is there an alternative to Serverless SQL Pool? I know Databricks…
How to specify a custom catalog name for Azure Databricks Delta Lake Dataset in ADF
Hello, I am creating an Azure Databricks Delta Lake Dataset in ADF and I am only able to choose the database name that links to Databricks's hive_metastore. How can I specify a custom catalog name that I created in Databricks instead of…
Unable to connect to Azure Databricks repo with Azure DevOps server 2020
We are establishing the connection with Azure Databricks repo with the On-premise Azure DevOps Server 2020. We created a service principal and added to the databricks. we created a PAT from On-premise Azure DevOps server and added in the linked…
Vnet Injected Databricks Workspace with IP ACL gives 403 while executing notebook using compute cluster
I have an IP access list enabled on my Vnet injected databricks workspace in Azure. I can access my workspace as my VPN ip is enabled on the workspace IP list. However, when I try executing my notebook by attaching a cluster, it gives below error- 403:…
Azure Databricks and Key vault key versioning
We are building a Data encryption solution and are using pyspark AES encrypt and AES Decrypt function to encrypt the PII columns in the Databricks tables on Unity catalog. We have created views on top of these tables and using the same encryption key we…
How to use databricks ai to auto generate data definitions for all the tables in my database?
I know we can go to the catalog in databricks and generate data definitions for columns inside of our database using ai, but is there a way of automatically generating these definitions without have to manually generate them and click accept on every…
how to connect azure cache redis to azure databricks through service principal
I need to connect azure redis to databricks using service principal . but I am getting this error Failed to connect to Redis: invalid username-password pair
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Error with Create Table USING DELTA LOCATION in training exercise
In the exercise https://microsoftlearning.github.io/mslearn-databricks/Instructions/Exercises/03-Delta-lake-in-Azure-Databricks.html the line of code spark.sql("CREATE TABLE AdventureWorks.ProductsExternal USING DELTA LOCATION…
How to check exact IP address of ADB workspace env .
i just want to know my IP address of Azure data bricks workspace env, I have vnet and subnet configured. How can i get exact IP address of ADB workspace. As i have more than 100 NIC to check the exact IP. Is their any easiest way to get exact ip…
![](https://techprofile.blob.core.windows.net/images/NHGWhQflYkuz6hEKD4wlkQ.png?8DCB25)