The Databricks-academy question

[RengarLee]

I'm learning the  Data Engineeing with Databricks of Course, I have a question.

if I run cmd4, it tells me an error.

Course URL:https://customer-academy.databricks.com/learn/course/62/play/4290/providing-options-for-external-sources;lp=10

Chapter: DE 4.2 - Providing Options for External Sources

Error Info: [SQLITE_ERROR] SQL error or missing database (no such table: users)

I have installed the Postgresql jar.

[Hubert-Dudek · Accepted solution]

• there is possibility that it is not working on community edition
• if you are using commercial edition please contact training support https://help.databricks.com/s/contact-us?ReqType=training (generally from my experience in courses everything should be automatic but 1 time for me it also haven't worked because of broken dependency)

[RengarLee]

Thank you for the answer 

[Kaniz]

Hi @Rengar Lee​ , Please check if the table exists or not or have you misspelled the table's name?

[RengarLee]

Thank you for the answer 

[Kaniz]

Hi @Rengar Lee​ , Just a friendly follow-up. Do you still need help, or @Hubert Dudek (Customer)​ 's response help you to find the solution? Please let us know.

[RengarLee]

I have no problem now  

[Kaniz]

Hi @Rengar Lee​ , Thank you for the update. Appreciate you for choosing the best answer for our community.

[AleksanderJakob]

@Kaniz Fatma​ I have the same issue and none of the methods here are helping. I think there are some dependecy issues here.

[Kaniz]

Hi @Aleksander Jakobsen​, Can you please share the issue more here?

[AleksanderJakob]

@Kaniz Fatma​ I try to run Cmd 4 in the notebook "DE 4.2 - Providing Options for External Sources" following the Data Engineeing with Databricks course. The course material have been gathered from the latest version as of 08th June 2022 from the databricks academy github ( https://github.com/databricks-academy/data-engineering-with-databricks/tree/published/Data-Engineeri...).

Attached is a screenshot of the issue.

[Kaniz]

Hi @Aleksander Jakobsen​, Please file a support ticket here for the same.

[A_GREY_FOX]

This note book needs to be run on a single note cluster, as stated here.

[Kaniz]

Excellent!

Thank you for the response @anthony fox​ .

[RiyazAli]

Yupp, faced the same issue with 4.2 & 4.3 setup %run commands. They fail midway, I have informed these issues to TA available during Databricks Days training as well. Surprised to see these issues exist yet.