topic Re: ADE 2.1 Unable to run Classroom-Setup-3.1 in Data Engineering

ADE 2.1 Unable to run Classroom-Setup-3.1

sumit2jha — Tue, 25 Jul 2023 03:39:09 GMT

%run ../Includes/Classroom-Setup-3.1

After running the above command, getting this error message, attached error screenshot.

AnalysisException: You are trying to read a Delta table `spark_catalog`.`dbacademy_sumit_s_jha_hk_ey_com_adewd_3_1`.`date_lookup` that does not have any columns. Write some new data with the option `mergeSchema = true` to be able to read the table.

Re: ADE 2.1 Unable to run Classroom-Setup-3.1

Tharun-Kumar — Tue, 25 Jul 2023 05:03:25 GMT

@sumit2jha

I would recommend to first run the 01 - Getting Started notebook to install the datasets. This would help in installing the datasets and will help you overcome this error.

Re: ADE 2.1 Unable to run Classroom-Setup-3.1

sumit2jha — Tue, 25 Jul 2023 06:46:31 GMT

@Tharun-Kumar

Thanks for your reply. I tried to run all previous file but still getting the same error while calling the function "

create_date_lookup()" from the file Classroom-Setup-3.1 and getting same error from all rest of the files while running.

Re: ADE 2.1 Unable to run Classroom-Setup-3.1

dbricuser — Thu, 27 Jul 2023 11:19:59 GMT

Hi.....is this issue resolved? I'm getting the same error and trying to resolve it

Re: ADE 2.1 Unable to run Classroom-Setup-3.1

dbricuser — Fri, 28 Jul 2023 08:19:38 GMT

Indeed the issue gets resolved once the getting started notebook is executed. It is working now.

Re: ADE 2.1 Unable to run Classroom-Setup-3.1

sumit2jha — Fri, 28 Jul 2023 09:33:16 GMT

First run this file before starting. Problem will be solved

Re: ADE 2.1 Unable to run Classroom-Setup-3.1

ManuSolorio — Sat, 11 Nov 2023 17:51:01 GMT

Hi sumit

I don't see that Notebook any where. Where can I find the link to import it?

thanks

Re: ADE 2.1 Unable to run Classroom-Setup-3.1

abhipragy — Thu, 04 Dec 2025 15:19:39 GMT

where we can find 01 - Getting Started notebook