topic Re: The Databricks-academy question in Data Engineering

The Databricks-academy question

RengarLee — Sat, 19 Mar 2022 07:05:18 GMT

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.

Re: The Databricks-academy question

Hubert-Dudek — Mon, 21 Mar 2022 10:19:12 GMT

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)

Re: The Databricks-academy question

RengarLee — Fri, 29 Apr 2022 03:09:35 GMT

Thank you for the answer

Re: The Databricks-academy question

RengarLee — Fri, 29 Apr 2022 03:09:41 GMT

Thank you for the answer

Re: The Databricks-academy question

RengarLee — Fri, 29 Apr 2022 03:10:02 GMT

I have no problem now

Re: The Databricks-academy question

AleksanderJakob — Tue, 07 Jun 2022 13:42:28 GMT

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

Re: The Databricks-academy question

AleksanderJakob — Wed, 08 Jun 2022 06:10:23 GMT

@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-Engineering-with-Databricks ).

Attached is a screenshot of the issue.

Re: The Databricks-academy question

RiyazAliM — Wed, 08 Jun 2022 09:30:26 GMT

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.

Re: The Databricks-academy question

Panna — Mon, 20 Jun 2022 22:44:40 GMT

Same issue occurred to me😅

Re: The Databricks-academy question

A_GREY_FOX — Wed, 13 Jul 2022 15:36:44 GMT

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