Module 'dlt' has no attribute 'table' - databricks and delta live tables

Question

I am new to databricks and delta live tables. I have problem with creating delta live table in python.

How to create delta live table from json files in filestore?

sandro scodelller · Accepted Answer · 2022-05-24T10:21:52.683

2

It is a decorator, so I think you also need a function after. Meaning

@dlt.table(comment="your comment")
def get_bronze():
    df=spark.sql("""select * from myDb.MyRegisterdTable""")
    #If you wanna check logs:
    #print("bronze",df.take(5),"end")
    return df

In silver function then you can read it as:

@dlt.table
def get_silver():
    df = dlt.read("get_bronze")
    [..do_stuff...]
    return df

Also from your screenshots I am not sure, are you running all this as a pipeline or are you trying to run a Notebook? The latter does not work.

edited May 24 '22 at 10:21

answered May 18 '22 at 14:29

sandro scodelller

400
3
8

2

from error it's running from notebook, not pipeline – Alex Ott May 22 '22 at 16:42
Yes, I was running Notebook. I am beginner with Delta Live Tables, Databricks.. Thank you for help. – Jelena Ajdukovic May 24 '22 at 07:21
1

You are welcome :-) And everyone is a beginner with delta live tables, it is a new thing ;-) – sandro scodelller May 24 '22 at 10:22

score 1 · Answer 2 · answered May 21 '22 at 04:34

Sandro’s answer should solve your problem. For ingesting json files with live tables, you can check this article for some use cases https://medium.com/@chaobioz/create-delta-live-tables-dlt-dynamically-with-pyspark-e06a718199c8

Also if for production, better use auto loader as well.

score 0 · Answer 3 · answered Sep 20 '22 at 06:24

Create a Notebook with the scripts
Create a Pipeline (With your Required configs).
Start the Pipeline directly, don't run the notebook Delta Tables will be created directly.

You can check this process mentioned in the documentation itself. https://docs.databricks.com/workflows/delta-live-tables/delta-live-tables-quickstart.html

Read the steps just above the requirement, I guess that would help.

score -1 · Answer 4 · answered May 17 '22 at 12:53

-1

Could you try to install dlt before importing it?

%pip install dlt

answered May 17 '22 at 12:53

K1209

1

The problem ist not 'dlt' modul. It says that dlt module exist but dlt.table doesn't. – Tom Marvolo Riddle May 18 '22 at 09:11
As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community May 18 '22 at 12:04
1

Warning, the above `dlt` package available via `pip install` has nothing to do with Databricks Delta Live Tables – Alain Dec 01 '22 at 18:16

Module 'dlt' has no attribute 'table' - databricks and delta live tables

4 Answers4