cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Hubert-Dudek
Esteemed Contributor III
  • 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)

View solution in original post

15 REPLIES 15

Hubert-Dudek
Esteemed Contributor III
  • 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)

Thank you for the answer 

Kaniz
Community Manager
Community Manager

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

Thank you for the answer 

Kaniz
Community Manager
Community Manager

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.

I have no problem now  

Kaniz
Community Manager
Community Manager

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

AleksanderJakob
New Contributor II

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

Hi @Aleksander Jakobsen​, Can you please share the issue more 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.

Kaniz
Community Manager
Community Manager

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

A_GREY_FOX
New Contributor II

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

Kaniz
Community Manager
Community Manager

Excellent!

Thank you for the response @anthony fox​ .

RiyazAli
Valued 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.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!