Executing mutiple queries in a single transaction of a notebook on databricks
I'm working on executing multiple queries within a single transaction on Databricks using Golang. However, I'm encountering a 'not implemented' error. Upon reviewing the library code, I found the following: // Not supported in Databricks. func (c…
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…
Create views in Azure Databricks Unity catalog using service principal
Hello Team, Is there a possibility to Create views in Azure databricks Unity Catalog using service principal. and if there is how to update views based on tables added or deleted in schema. For e.g. I would like to create each views per tables in the…
Retrieving 'Person or Group' Fields from SharePoint List in Azure Data Factory or Synapse
I'm able to retrieve data from a SharePoint list using Azure Data Factory > Copy Data (via the SharePoint Connector), but the list contains 'Person or Group' type fields that return only 'Id' values in the results. These 'Id' values are not useful,…
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) .
Connect to metastore table in databricks from other databricks notebook using service principal
I want to read table present in other databricks account in my databricks account using service principal. I am not able to find service principal related guide to connect to other databricks workspace. I can only see storage account related service…
'manage account' > 'account console' option
db-q-1.JPGHello Team, I do have an access as Global Administrator, but I am not getting 'manage account' > 'account console' option in Azure Databricks @ top right corner. I need to create Unity Catalog metastore. Thanks
Databricks vs Batch pool
Hi, I have Googled the difference between using Azure Databrick and Batch pool to run python pipelines and ETL. But I haven’t found a clear difference between them two. Based on what I have Googled, Databrick can become very expensive, so cost matters a…
Azure Databricks Workspace: Users are being added to the admins group on their own
We have an Azure Databricks workspace with Unity Catalog enabled. We are using SCIM provisioning to sync some Entra security groups to the workspace so that we can control access to the catalog items. We have noticed that some users are being added…
Configured privacy settings disallow access for workspace <workspace-id> over your current network.
Hi All, We have a couple of Databricks workspaces that are deployed with secure access - basically you can only log in when you are within the network, However, I am running into a problem where I sometimes get this error: “Configured privacy settings…
understanding how to use mergeSchema=True
In COPY INTO under FORMAT_OPTIONS generally i use mergeSchema=True but in few queries i am seeing that it is also metioned under copy_options why ? and I have also seen mergeSchema=true given under options while read or readStream, i have seen that in…
getting error while creating mount point in data bricks
Hi, I am getting the following error when trying to create mount point. py4j.security.Py4JSecurityException: Method public com.databricks.backend.daemon.dbutils.DBUtilsCore$Result…
is there a spark connector for Azure Cosmos DB MongoDB API RU?
I'm using Azure Databricks to develop a proof of concept. Is there support for a Spark Connector for Azure Cosmos DB MongoDB API? If yes, what versions are supported. Is both batch and stream operations supported?
I dont see Account Console in Databricks. Please advise
I have personal account and when I log into databricks I dont see account console to admin stuff
How to read zip file in Azure Synapse Notebook with extension of .zip.
Hi Team, Could you please advise the pyspark code, how to read zip files in synapse notebook. Example: File_Name - samplefile.zip Note: In the samplefile.zip we have multiple csv files, please let us know. The file Extension is only with .zip. …
How to list secret scopes and identify key vaults
What is the best way to view all existing secret scopes within a Databricks workspace? Additionally, how can we identify the specific Azure Key Vault linked to each of these secret scopes? I’d like to understand the steps or API calls needed to retrieve…
Want to know my subscription and billing details for azure account
Hi, I had created azure free trail subscription account on sep, 6th, 2024 and cancelled the subscription as well but today i got a mail regarding billing. when i proctored the billing information in the account there were no subscriptions listed. i…
Availability of Serverless Compute in South African North region
Are there any plans and dates to bring Databricks of Serverless Compute to the South African North region? Thanks, Andreas.
copy tables from sql server on-prem to .parquet format in delta lake
Currently our copy process for 10 tables is running in pipeline in ADF, our source is ON-PREM SQL Server and target is in BLOB Storage GEN2. it copies data(tables) in parquet file format in HOT storage Account --- StorageV2 (general purpose v2) but I…