The Databricks-academy question

RengarLee
Contributor

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
Databricks MVP
  • 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)

My blog: https://databrickster.medium.com/

View solution in original post

Thank you for the answer 

Thank you for the answer 

I have no problem now  

AleksanderJakob
Databricks Partner

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

@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.

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

RiyazAliM
Honored Contributor

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.

Riz

Panna
Databricks Partner

Same issue occurred to me😅