Connecting Spark to Azure SQL
Hi, I'm following this article to connect Spark to Azure SQL https://learn.microsoft.com/en-us/azure/azure-sql/database/spark-connector?view=azuresql&source=docs It says that I need to get the Spark connector and it has a link to a maven repo that…
How can I make sure that a table and csv file can merge in an azure databricks query?
I am currently trying to copy data from a csv file into my table in azure databricks and am getting the following error. [DELTA FAILED TO MERGE FIELDS] Failed to merge fields ‘transfer_month’ and ‘transfer_month’ I am unable to solve the error. I can…
How do I use the azure databricks dlt pipeline to consume azure Event Hub data
Hi there, How do I use the azure databricks dlt pipeline to consume azure Event Hub data? EH_NAME = "myeventhub" TOPIC = "myeventhub" KAFKA_BROKER = "{EH_NAMESPACE}.servicebus.windows.net:9093" GROUP_ID =…
Need to connect to IMB DB2 from Azure databricks workspace
Need to connect to IMB DB2 (DB version IBM DB2 for i 7.3) form azure databricks workspace, the DB2 is hosted is AS400 server and DB port 8471. Please suggest on the step by step procedure to connect to DB and query a table, like installing required…
How to create a Materialized View in Azure Databricks stored in a Managed Catalog, based on data loaded from a foreign catalog
I am currently facing a problem with creating a materialized view in Catalog_2.Schema_B (Managed_Catalog) based on data I have connected from postgre SQL external source loaded into Catalog1_Schema_A (Foreign_Catalog). The error I get only says…
Azure Databricks
We have our production Azure Databricks resources configured with two subnets: one for the host and one for the container, both using a /27 CIDR block. As we plan to execute multiple jobs and only have 16 IPs remaining, we have decided to expand the…
manage account in azure databricks
Hi Guys hope you are fine. I am trying to login to https://accounts.azuredatabricks.net/login with my intra id and giving it same password of my azure portal acount but it is giving me the error that password is not correct. although it is working fine…
How do I add users from different domains to azure databricks
Hi there, How do I add users from different domains to azure databricks? Thanks&Regards, zmsoft
How to become azure databricks expert?
How to become azure databricks expert? Any Microsoft offered courses apart from microsoft learn
Users in a specific region are experiencing connection issues to Databricks workspaces
We have users that are experiencing issues with connecting to both our production and development environments of databricks through our Azure subscription. Everything else in Azure is working fine for them, though. We have other users in different…
No Support for reading zip files store in Azure Datalake storage using abfss protocol url via python notebook.
Hi, This is so strange that microsoft have created the abfss protocol but have zero support to read zip files using abfss protocol via python notebook. For example I have this sample code that gives me hard time identifying a zip file as a zip…
What are the differences between notebooks (written in SQL) and queries in Azure Databricks?
What are the differences between notebooks (written in SQL) and queries in Azure Databricks? I am particularly interested in what the differences are in terms of performance, billing and maintenance. If there are no significant functional differences, is…
How to disable Azure Databricks Personal Compute policy?
Hello, can you please provide details how to disable Azure Databricks Personal Compute policy for a) all users b) non-admin users Thanks!
Databricks Cluster Deployment Error: BOOTSTRAP_TIMEOUT (SERVICE_FAULT)
Assistance is needed with an issue encountered while deploying a cluster in Databricks UAT. The following error message is received: run failed with error message cluster 305161200-quoa9grg was terminated. Reason: BOOTSTRAP_TIMEOUT (SERVICE_FAULT)
Azure Databricks Workspace will not open and generates a blank webpage. Console says Error 429
Access to the workspace was fine last Friday, but today the webpage fails to load. I've cleared my cache, tried multiple browsers, restarted my computer and still face the same error. When I open the console in the browser I see a host of 429 errors (Too…
How can I enable the 'SHAREPOINT' type connection in Azure Databricks?
I tried to connect SharePoint using Azure Databricks Lakehouse Federation. First, I select Connection type "Microsoft SharePoint" to create a Lakehouse Federation. Next, I input authentication info and sign in with Microsoft SharePoint. Then,…
Creating an Azure Databricks service but get Admin error when I'm an Owner?
Hi Forum, I have an Azure account and I want to do some work with Azure Databricks using my personal email to set it up. I created a pay as you go Azure Databricks workspace in Azure and all is good until I click on Launch. I get a note saying I should…
How can I prohibit ordinary users to execute notebooks of shared folder in Azure Databricks?
Hello, How can I prohibit ordinary users to create, modify, and execute notebooks of shared folder in Azure Databricks? For security reasons, I want to prevent ordinary users from accidentally sharing the results of SELECT sensitive data in the Shared…
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. …
Is there any way to export/download queries in order to move queries from one subscription to another??
I have been using Azure Databricks on one subscription and have queries in a workspace. Now I want to move them to another databricks workspace in a different subscription. Is there any way for me to export or download queries? My current solution is to…