- 3675 Views
- 3 replies
- 0 kudos
Having trouble installing my own Python wheel?
I want to install my own Python wheel package on a cluster but can't get it working. I tried two ways: I followed these steps: https://docs.databricks.com/en/workflows/jobs/how-to/use-python-wheels-in-workflows.html#:~:text=March%2025%2C%202024,code%...
- 3675 Views
- 3 replies
- 0 kudos
- 0 kudos
@397973 - Once you uploaded the .whl file, did you had a chance to list the file manually in the notebook? Also, did you had a chance to move the files to /Volumes .whl file?
- 0 kudos
- 3415 Views
- 1 replies
- 0 kudos
Delta Live Table : [TABLE_OR_VIEW_ALREADY_EXISTS] Cannot create table or view
Hi,I have a delta live table workflow with storage enabled for cloud storage to a blob store.Syntax of bronze table in notebook===@dlt.table(spark_conf = {"spark.databricks.delta.schema.autoMerge.enabled": "true"},table_properties = {"quality": "bron...
- 3415 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi Kaniz,Thanks for replying back.I am using python for delta live table creation, so how can I set these configurations?When creating the table, add the IF NOT EXISTS clause to tolerate pre-existing objects.consider using the OR REFRESH clause Answe...
- 0 kudos
- 5835 Views
- 6 replies
- 0 kudos
value is null after loading a saved df when using specific type in schema
I am facing an issue when using databricks, when I set a specific type in my schema and read a json, its values are fine, but after saving my df and loading again, the value is gone.I have this sample code that shows this issue: from pyspark.sql.typ...
- 5835 Views
- 6 replies
- 0 kudos
- 2155 Views
- 1 replies
- 0 kudos
Writing to multiple files/tables from data held within a single file through autoloader
I have a requirement to read and parse JSON files using autoloader where incoming JSON file has multiple sub entities. Each sub entity needs to go into its own delta table. Alternatively we can write each entity data to individual files. We can use D...
- 2155 Views
- 1 replies
- 0 kudos
- 0 kudos
I think using DLT's medallion architecture should be helpful in this scenario. You can write all the incoming data to one bronze table and one silver table. And you can have multiple gold tables based on the value of the sub-entities.
- 0 kudos
- 8931 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 ?...
- 8931 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
- 8736 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
- 8736 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
- 4415 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}"....
- 4415 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
- 2198 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/...
- 2198 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
- 1727 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...
- 1727 Views
- 0 replies
- 0 kudos
- 1330 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...
- 1330 Views
- 0 replies
- 0 kudos
- 1883 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?
- 1883 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
- 4478 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...
- 4478 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
- 3500 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...
- 3500 Views
- 0 replies
- 0 kudos
- 9849 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...
- 9849 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
- 11257 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...
- 11257 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
| User | Count |
|---|---|
| 1616 | |
| 790 | |
| 466 | |
| 349 | |
| 287 |
