Unable to execute Academy Labs - Classroom-Setup issues

[cpmurray]

I'm looking for some assistance in getting the Academy Labs to run. When the Classroom-Setup cell calls the dbacademy library dbgems command/sublibrary, I receive the following error. This is encountered at a minimum in the 11L Advanced Pandas lab, but I know I encountered it elsewhere. Thank you (please excuse the sloppy formatting from copy+paste).

[CONFIG_NOT_AVAILABLE] Configuration dbacademy.deprecation.logging is not available. SQLSTATE: 42K0I

File <command-7996016885884726>, line 1 ---->

1 from dbacademy import dbgems

2 from dbacademy.dbhelper import DBAcademyHelper, Paths, CourseConfig, LessonConfig

4 course_config = CourseConfig(course_code = "inpy",

5 course_name = "introduction-to-python-for-data-science-and-data-engineering",

6 data_source_name = "introduction-to-python-for-data-science-and-data-engineering", (...)

11 supported_dbrs = ["17.3.x-scala2.13", "17.3.x-photon-scala2.13", "17.3.x-cpu-ml-scala2.13"],

12 expected_dbrs = "{{supported_dbrs}}")

File /databricks/python/lib/python3.10/site-packages/pyspark/sql/connect/client/core.py:1995, in SparkConnectClient._handle_rpc_error(self, rpc_error)

1991 d.Unpack(info)

1993 self._handle_rpc_error_with_error_info(info, status.message, status_code) # EDGE ->

1995 raise convert_exception(

1996 info,

1997 status.message,

1998 self._fetch_enriched_error(info),

1999 self._display_server_stack_trace(),

2000 ) from None

2002 raise SparkConnectGrpcException(

2003 message=status.message,

2004 sql_state=ErrorCode.CLIENT_UNEXPECTED_MISSING_SQL_STATE, # EDGE 2005 ) from None

2006 else:

Command skipped

[mmayorga]

hi @cpmurray 

Thank you so much for reaching out, providing these details and for your patience with this issue.

Allow us some time, we are reviewing this Lab and configuration; I'll keep you posted.

Thank you

[mmayorga · Accepted solution]

Hi @cpmurray 

Thank you for your patience. After further review, the lab environment is working as intended. I was able to replicate this issue by using "Serverless".

Please note that the notebook instructions state: “REQUIRED – SELECT CLASSIC COMPUTE.” This lab environment provides a dedicated cluster for that purpose.

Try to attach your notebook with the "labuser[number]" cluster instead of Serverless and let us know.

Thank you! If this resolves your issue we appreciate to accept it as solution.