- 13940 Views
- 1 replies
- 2 kudos
Universal Azure Credential Passthrough
At the moment, Azure Databricks has the feature to use AzureAD login for the workspace and create single user clusters with Azure Data Lake Storage credential passthrough. But this can only be used for Data Lake Storage.Is there already a way, or are...
- 13940 Views
- 1 replies
- 2 kudos
- 2 kudos
I have exactly the same issue. I have the need to call a protected API within a notebook but have no access to the current user's access token. I've had to resort to nasty workarounds involving installing and running the Azure CLI from within the not...
- 2 kudos
- 3293 Views
- 1 replies
- 0 kudos
pytesseract.pytesseract.TesseractNotFoundError in databricks notebook
I'm trying to extract the text data from image file in Databricks notebook I have installed below libraries using pip command: %pip install pytesseract tesseract pillow --upgradebut it didn't work and threw below error pytesseract.pytesseract.Tessera...
- 3293 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @neha_ayodhya - can you please try the following via an init script to the Databricks cluster sudo apt-get update -y sudo apt-get install -y tesseract-ocr sudo apt-get install -y libtesseract-dev /databricks/python/bin/pip install pytesseract a...
- 0 kudos
- 1156 Views
- 1 replies
- 0 kudos
Delete S3 files after vacuum
Hi,I'm trying to purge a table of stale data. My databricks host is on cloud.databricks.com.I've set delta.deletedFileRetentionDuration=interval 7 days, deleted many (billions) rows, and followed up with VACUUM tablename RETAIN 168 HOURS, however my ...
- 1156 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi Bill - Based on the delta delete file retention period, the files will no longer be there after 7 days . Thanks, Shan
- 0 kudos
- 1982 Views
- 3 replies
- 0 kudos
Resolved! Refresh the Spark UI automatically
Hello!I'm using Databricks with Azure. On a daily basis, I check the status of numerous jobs through the Spark UI. At the moment, the Spark UI does not refresh by itself. I have to refresh the webpage to get the latest status. I wonder if there is a ...
- 1982 Views
- 3 replies
- 0 kudos
- 1426 Views
- 3 replies
- 1 kudos
I have to optimise our initial load, for that I want to perform batch inserts while loading data.
No
- 1426 Views
- 3 replies
- 1 kudos
- 4814 Views
- 4 replies
- 1 kudos
Resolved! Databricks Auto Loader cloudFiles.backfillInterval
Hello, I have been reading databricks Auto Loader documentation about cloudFiles.backfillInterval configuration, and have a question about a specific detail on how it works still. I was only able to find examples of it being set to 1 day or 1 week. ...
- 4814 Views
- 4 replies
- 1 kudos
- 1 kudos
Hey @therealchainman The last backfill (lastBackfillFinishTimeMs) will be recorded as part of the checkpoint -> offset files, this helps the autoloader to know when the last backfill is triggered and to trigger the next periodic backfill.Hope this an...
- 1 kudos
- 1210 Views
- 1 replies
- 0 kudos
alter function owner in UC
I have a number of functions in a schema in a catalog in Unity Catalog, is there a coding way to be able to change the owner of the functions created without having to do it manually via the gui?
- 1210 Views
- 1 replies
- 0 kudos
- 0 kudos
Check this notebook out, I assume you can change it a bit to do what you want. https://docs.databricks.com/en/_extras/notebooks/source/set-owners-notebook.htmlI assume you can loop through the rows in the resulting df (that has the ALTER statements),...
- 0 kudos
- 1389 Views
- 1 replies
- 0 kudos
Hostname could not be verified
Hi all,We have a job that combines historical tables with live tables to give us up to date information. It works for almost all of the tables in our source postgres database, but there's one table that keeps giving the following error. Any ideas why...
- 1389 Views
- 1 replies
- 0 kudos
- 0 kudos
Could you share the full error stack trace please? Also try to test your connectivity by doing "%sh nc -zv {hostname} {port}"
- 0 kudos
- 2005 Views
- 1 replies
- 0 kudos
Error when running Spark-DL notebooks
I try several Spark Deep Learning inference notebooks on Windows. I run Spark in standalone mode with 1 worker with 12 cores (both driver-memory and executor-memory are set to 8G). I always get the same error when applying the deep learning model to ...
- 2005 Views
- 1 replies
- 0 kudos
- 0 kudos
This is a connectivity issue. Check your connectivity by doing "%sh nc -zv {hostname} {port}" from your notebook
- 0 kudos
- 1329 Views
- 1 replies
- 0 kudos
Issue importing library deltalake
Hello,I'm currently seeing a rather cryptic error message whenever I try to import the deltalake library into Databricks (without actually doing anything else).import datalake"ImportError: /local_disk0/.ephemeral_nfs/envs/pythonEnv-cbe496f6-d064-40ae...
- 1329 Views
- 1 replies
- 0 kudos
- 0 kudos
Are you trying to import this library to a Databricks notebook? are you using open source spark in your local machine?
- 0 kudos
- 1244 Views
- 1 replies
- 0 kudos
Getting "Job aborted" exception while saving data to the database
Hi!We have job, that runs every hour. It extracts data from the API and saves to the databricks table.Sometimes job fails with error "org.apache.spark.SparkException". Here is the full error:An error occurred while calling o7353.saveAsTable. : org.ap...
- 1244 Views
- 1 replies
- 0 kudos
- 0 kudos
Do you have any NULL values in your data? Please verify that you data is valid
- 0 kudos
- 5733 Views
- 11 replies
- 3 kudos
Resolved! Replay(backfill) DLT CDC using kafka
Hello,We are receiving DB CDC binlogs through Kafka and synchronizing tables in OLAP system using the apply_changes function in Delta Live Table (DLT). A month ago, a column was added to our table, but due to a type mismatch, it's being stored incorr...
- 5733 Views
- 11 replies
- 3 kudos
- 3 kudos
Thank you @532664 for your detailed response! That's seems to me a very good solution, and it also helps me with my doubts
- 3 kudos
- 6713 Views
- 4 replies
- 0 kudos
Error in SQL statement: UnsupportedOperationException: Cannot perform Merge as multiple source rows matched and attempted to modify the same
My code:- CREATE OR REPLACE TEMPORARY VIEW preprocessed_source ASSELECT Key_ID, Distributor_ID, Customer_ID, Customer_Name, ChannelFROM integr_masterdata.Customer_Master;-- Step 2: Perform the merge operation using the preprocessed source tableM...
- 6713 Views
- 4 replies
- 0 kudos
- 0 kudos
Hey as previously stated you could drop the duplicates of the columns that contain the said duplicates(code you can find online pretty easily), I have had this problem myself and it came when creating a temporary view from a dataframe, the dataframe ...
- 0 kudos
- 3958 Views
- 4 replies
- 0 kudos
Unable to read from azure blob using SAS token\\
I have tried many times all the answers from the internet and stackover flowI have already created the config section before this steps, it passed but this below step is not executing.
- 3958 Views
- 4 replies
- 0 kudos
- 0 kudos
We were getting this problem when using directory-scoped SAS tokens. While I know there are a number of potential issues that can cause this problem, one potential explanation is that it turns out there is an undocumented spark setting needed on the ...
- 0 kudos
- 1228 Views
- 0 replies
- 1 kudos
connect azure databricks to reverso using API
Hi Databricks community,Reverso is a language translation tool that converts texts from one language to another. I need to convert hundreds of text but its time consuming. Hence, I want to use its API to automate the process.How can I achieve this in...
- 1228 Views
- 0 replies
- 1 kudos
| User | Count |
|---|---|
| 1611 | |
| 768 | |
| 348 | |
| 286 | |
| 252 |
