Data Management and Governance with Unity Catalog Demo Set up error

[rollercoaster43]

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.

[Alberto_Umana]

Hi @rollercoaster43,

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

[saisaran_g]

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