- 11799 Views
- 6 replies
- 1 kudos
Resolved! Seeing history even after vacuuming the Delta table
Hi,I'm trying to do the vacuum on a Delta table within a unity catalog. The default retention is 7 days. Though I vacuum the table, I'm able to see the history beyond 7 days. Tried restarting the cluster but still not working. What would be the fix ?...
- 11799 Views
- 6 replies
- 1 kudos
- 1 kudos
No, that's wrong. VACUUM removes all files from the table directory that are not managed by Delta, as well as data files that are no longer in the latest state of the transaction log for the table and are older than a retention threshold.VACUUM - Azu...
- 1 kudos
- 9786 Views
- 4 replies
- 5 kudos
IP address fix
How can I fix the IP address of my Azure Cluster so that I can whitelist the IP address to run my job daily on my python notebook? Or can I find out the IP address to perform whitelisting? Thanks
- 9786 Views
- 4 replies
- 5 kudos
- 5 kudos
Depends on the scenario. You could expose a single ip address to the external internet, but databricks itself will always use many addresses.
- 5 kudos
- 5711 Views
- 4 replies
- 0 kudos
@dlt.table throws error AttributeError: module 'dlt' has no attribute 'table'
Hi Everyone,I am new to DLT and am trying to run below code to create table dynamically. But I get error "AttributeError: module 'dlt' has no attribute 'table'". code snippet:def generate_tables(model_name try: spark.sql("select * from dlt.{0}"....
- 5711 Views
- 4 replies
- 0 kudos
- 0 kudos
Thank You, @DE_K. I see your point. I believe you are using the @dlt.table instead of @dlt.create_table to begin with, since want the table to be created and not define and existing one. (https://community.databricks.com/t5/data-engineering/differenc...
- 0 kudos
- 3157 Views
- 1 replies
- 0 kudos
Spark Driver failed due to DRIVER_UNAVAILABLE but not due to memory pressure
Hello,I have a job cluster running streaming job and it unexpectedly failed on 19th March due to DRIVER_UNAVAILABLE (Request timed out, Driver is temporarily unavailable) in event log. This is the run: https://atlassian-discover.cloud.databricks.com/...
- 3157 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @duliu , Hope you are doing well! Would you kindly see if the KB article below addresses your problem? https://kb.databricks.com/en_US/jobs/driver-unavailable Please let me know if this helps and leave a like if this information is useful, followu...
- 0 kudos
- 2215 Views
- 0 replies
- 0 kudos
Issue while writing data to unity catalog using JDBC
While writing the data to a pre-existing table in the unity catalog using JDBC. it just writes the Delta of the data. Driver used: com.databricks:databricks-jdbc:2.6.36Lets say I have the table has rows:+-+-+ |a|b| +-+-+ |1|2| |3|4| and I am appendi...
- 2215 Views
- 0 replies
- 0 kudos
- 1741 Views
- 0 replies
- 0 kudos
[Delta Sharing - open sharing protocol] Token rotation
Hi, Do you have any experience of rotating Tokens in Delta Sharing automatically?There is an option to do that using CLI (Create and manage data recipients for Delta Sharing | Databricks on AWS). But what to do next? Sending new link to the token via...
- 1741 Views
- 0 replies
- 0 kudos
- 2586 Views
- 1 replies
- 1 kudos
Materialized View to External Location
As I learned the Materialized View is actually a Delta Table stored internally to Databricks (managed table ?)Is it possible to move the location of the Materialized View and the Delta Table under hood to an external location like BLOB?
- 2586 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @QPeiran For now there is no way to move the materialized view as it's being maintained by Databricks only
- 1 kudos
- 7276 Views
- 3 replies
- 0 kudos
The spark context has stopped and the driver is restarting. Your notebook will be automatically
I am trying to execute a scala jar in notebook. When I execute it explicitly I am able to run the jar like this :but when I am trying to run a notebook through databricks workflow I get the below error : The spark context has stopped and the driver i...
- 7276 Views
- 3 replies
- 0 kudos
- 0 kudos
Could you share the code you have in your JAR file? how are you creating your Spark context in your JAR file?
- 0 kudos
- 4084 Views
- 0 replies
- 0 kudos
JDBC drivers for Microsoft Dataverse IO
I want to run Databricks ETLs on on-prem Unix, Azure and on AWS (in future). I am trying to find suitable JDBC drivers but couldn't find anything except CDATA which is very costly.Can someone please help me? Also, what could be other viable solutions...
- 4084 Views
- 0 replies
- 0 kudos
- 12522 Views
- 7 replies
- 3 kudos
Resolved! In Azure Databricks CLI, how to pass in the parameter notebook_params? Error: Got unexpected extra argument
I am trying to call run-now with notebook_params in Azure Databricks CLI, following https://learn.microsoft.com/en-us/azure/databricks/dev-tools/cli/jobs-cliandescapse the quotes as stated in the documentationhttps://learn.microsoft.com/en-us/azure/d...
- 12522 Views
- 7 replies
- 3 kudos
- 3 kudos
I have the latest Databricks CLI setup and configured in my Ubuntu VM. When I tried to run a job using the json template I generated using databricks jobs get 'xxxjob_idxxx' > orig.json it throws an unknown error.Databricks CLI v0.216.0databricks job...
- 3 kudos
- 12530 Views
- 1 replies
- 1 kudos
Hive vs Delta
I'm curious about your experiences with Hive and Delta Lake. What are the advantages of using Delta over Hive, and in what scenarios would you recommend choosing Delta for data processing tasks? I'd appreciate any insights or recommendations based on...
- 12530 Views
- 1 replies
- 1 kudos
- 1 kudos
Delta Lake offers several advantages over Hive. One of the key benefits is its design for petabyte-scale data lakes with streaming and fast access at the forefront. This makes it more suitable for near-real-time streams, unlike Hive. Delta Lake also ...
- 1 kudos
- 3798 Views
- 2 replies
- 0 kudos
Drop array in a struct field
Hi guys,look my table definitionwell, I need to remove 'med array' inside that 'equip' field.have any idea ?Thank you
- 3798 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi William,There is array_remove method that can help to remove the elements from an array. Here med array is an element in equip array.If it not helpful, please share some sample data so that we can solve it together.Reference: array_removeThanks
- 0 kudos
- 4464 Views
- 2 replies
- 1 kudos
Resolved! Getting errors while reading data from URL
I'm encountering some issues while trying to read a public dataset from a URL using Databricks. Here's the code snippet(along with errors) I'm working with: I'm confused about Delta format error here.When I read data from a URL, how would it have a D...
- 4464 Views
- 2 replies
- 1 kudos
- 1 kudos
@sharma_kamal Please disable the formatCheck in notebook and check if you could read the data The configuration command %sql SET spark.databricks.delta.formatCheck.enabled=false will disable the format check for Delta tables in Databricks. Databrick...
- 1 kudos
- 3268 Views
- 2 replies
- 1 kudos
Can I use Git provider with using Service Principal in job
Hi everyone,I'm trying to use Git provider in Databricks job.First, I was using my personal user account to `Run as`.But when I change `Run as` to Service Principal, it was failed because of permission error.And I can't find a way to solve it.Could I...
- 3268 Views
- 2 replies
- 1 kudos
- 1 kudos
The documentation is lacking in this area which should be easy to set up. Instead we are forced to search among community topics such as these.
- 1 kudos
- 4974 Views
- 0 replies
- 0 kudos
[ Databricks - Delta sharing ] Issue with Delta Sharing in Databricks: Unable to Query Shared Views
Hi guys, I've encountered an issue while attempting to query shared views via Delta Sharing in Databricks. We are using Delta Sharing Databricks-to-Databricks protocol to share data from a databricks environment deployed on azure to another databrick...
- 4974 Views
- 0 replies
- 0 kudos
| User | Count |
|---|---|
| 1644 | |
| 793 | |
| 581 | |
| 349 | |
| 287 |
