Create Materialized Views via DLT Pipelines
I am attempting to create materialized views via DLT pipelines in the "abc" catalog and "gold" schema based on different catalog and schema ("fmv"), which contains 20 tables. Workspace binding , NSG connections and access…
Unable to launch my databricks workspace after i started a new pay as u go subscription
Hello Guys, I had previously used pay as u go during 1 free month as i had credits then, after 15 it expired. Now today i have started a new pay as u go subscription and was trying to launch databricks workspace just by filling these basic details and…
Databrick pyspark partition query
I am writing login in azure databrick Pyspark. Please see attached input data and expected output. Id will be used as a partition For every id we need to choose one record with latest date but if any id ( e.g Id = 3) contain multiple record with same…
ADF Azure Databricks Linked Service job cluster using policyId that specifies pool id
Hi, how can I set up an Azure Databricks linked service using a job cluster, using a job policy that specifies the driver and worker pool ids? In the linked service definition, I have selected "New job cluster", which requires me to supply a…
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": { …
Still being billed for Azure after I cancelled it
I signed up for the free Azure and then I cancelled the subscription, but I'm still receiving bills. How do I go about removing everything off my name?
Integrate storage, database, webapp, and databricks into one VNET
We are hardening our ML platform in Azure. Basically, we want to put all the Azure services ( ADLS, PostgreSQL DB, Web App, and Databricks cluster) in one virtural network so all the traffic will be inside the Azure network whenever possible (except the…
Failure starting repl. Try detaching and re-attaching the notebook.
I am using Azure Databricks for a couple of months already. I didn't change any code or configuration recently but all notebook are failed to run. The error is : Failure starting repl. Try detaching and re-attaching the notebook. It failed for simple…
Spark config through Databricks
Hi, I am trying to access storage account through databricks (thru notebook) with storage access key. I keep encountering error when I do spark.config.set spark.conf.set( …
How to extract 7z file on azure databricks
How to extract 7z file on azure databricks..
Auto loader
Hi, How to add new column automatically when it is not present in delta table
Managing PCI-DSS Compliance and Access to Serverless Features in Azure Databricks
Hello Azure Community, I am currently using Azure Databricks with PCI-DSS compliance enabled in our workspace, as maintaining stringent security standards is crucial for our organization. However, I've discovered that once PCI-DSS compliance is turned…
I am not able to access the delta path after creating the delta table in the Azure databricks.
I am using Pay-as-you-go subscription and I am working on Azure databricks. In Databricks, when Delta table crated , we could see the storage location from the catalog explorer. But, when trying to see the details by accessing path, I am coming across…
Init scripts stored in volumes are not getting executed via Job Shared cluster via ADF
Hello Team, We have stored our init script in Azure databricks managed volumes path and we want to execute notebook via Job Shared cluster, the pipeline we are triggering is via ADF but the job cluster gives an error as We are using Assigned Manged…
How to Spark Stream into azure PostgreSQL
I am trying spark stream data into postgresql via databricks, with delta tables and change data feed enabled. As far as I understand I can use JDBC or the databricks connector as seen here:…
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…
Resolving GPU memory errors in databricks with PyTorch on g4dn.2xlarge instances
I'm encountering persistent memory issues while training and testing a PyTorch model on Databricks. In my Databricks job configuration, I’ve specified node_type_id and driver_node_type_id as g4dn.2xlarge. According to the documentation, this instance…
Table Access control option is not available in Azure Databricks Compute cluster
Hi, I am trying to enable Table Access control in one of my Azure Databricks Compute Cluster, the cluster was created around 02 years back with pricing tier selected as Standard, now we have upgraded the same cluster to Premium tier in order to…
How to downgrade from TLS 1.3 to 1.2 in Azure Databricks env
Hi, As part of troubleshooting a current intermittent issue with connecting to an external API, I am being asked to downgrade the TLS version from 1.3 to 1.2. I am running a python notebook in our Azure Databricks environment and believe that TLS 1.3 is…
How can i migrate jobs from one workspace to other workspace (Dev to QA)
How can i migrate jobs from one workspace to other workspace (Dev to QA) .