Data Management and Governance with Unity Catalog Demo Set up error

rollercoaster43
New Contributor

‎02-12-2025 09:45 AM

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.





Preview file
87 KB
0 Kudos

Alberto_Umana
Databricks Employee
Databricks Employee

‎02-12-2025 01:02 PM

Hi @rollercoaster43,

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

0 Kudos

saisaran_g
Contributor

‎04-04-2025 10:52 AM

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

Happy Learning and solve new errors :
Saran
0 Kudos