topic Re: Data Management and Governance with Unity Catalog Demo Set up error in Databricks Free Edition Help

Data Management and Governance with Unity Catalog Demo Set up error

rollercoaster43 — Wed, 12 Feb 2025 17:45:51 GMT

I am trying to run classroom setup for Demo:Upgrading Tables to Unity Catalog lab in the above course and get multiple errors. I wasn able to complete previous 2 labs successfully.
Here are some errors while running the classrom set up script "

%run ./Includes/Classroom-Setup-3"

Errors :

"The execution of this command did not finish successfully"

[INSUFFICIENT_PERMISSIONS] Insufficient privileges: User does not have permission CREATE on CATALOG. SQLSTATE: 42501

File <command-3886899660090299>, line 30 21 set_variable_from_view = spark.sql(f'SET VAR user_hive_schema = DA.catalog_name')

Also , I see the table movies did not get created in the user_hive_schema. Please advise.

Re: Data Management and Governance with Unity Catalog Demo Set up error

Alberto_Umana — Wed, 12 Feb 2025 21:02:19 GMT

Hi @rollercoaster43,

Looks like you don't have the correct permission on your catalog. Use "GRANT CREATE ON CATALOG TO `user_email`"

Re: Data Management and Governance with Unity Catalog Demo Set up error

saisaran_g — Fri, 04 Apr 2025 17:52:18 GMT

Hello Mate,

Only few courses are allowing to change the table metadata or type itself for the labsessions. In this case you can download and try in your workspace(if any) that will work easily for the learning purpose.

Thanks for the ask, happy learning.

Saran