MicrosoftLearning / MicrosoftLearning/DP-750T00-Implement-Data-Engineering-Solutions-using-Azure-Databricks

Permissions error

Open Beginner friendly
#32 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Jupyter Notebook
Stars
33
Forks
41
PR merge metrics
No merged PRs in 30d

Description

We've come across a potential issue while testing "DP-750 Lab 09 - Implement and manage data quality constraints with Unity Catalog".

When running the Lab 09 setup notebook from top to bottom as instructed, the insurance_lab catalog is created successfully. However, the following cell then fails when attempting to create the bronze, silver, and gold schemas:

PERMISSION_DENIED: User does not have USE CATALOG on Catalog 'insurance_lab'.

The failure occurs when running:

CREATE SCHEMA IF NOT EXISTS insurance_lab.bronze;CREATE SCHEMA IF NOT EXISTS insurance_lab.silver;CREATE SCHEMA IF NOT EXISTS insurance_lab.gold;

From reviewing the Lab 09 instructions, this appears to be intended as a self-contained setup and doesn't seem to depend on completing Lab 08 or another previous lab, other than the initial workspace provisioning.

Could you confirm whether there are any additional Unity Catalog permissions that should be assigned to the student before starting Lab 09, or whether the setup notebook needs updating to grant the required permissions after creating the catalog?

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the Lab 09 setup notebook and run it from top to bottom, focusing on the cell that creates the bronze, silver, and gold schemas. Check whether the student has USE CATALOG on insurance_lab after catalog creation. Done means the notebook completes successfully with the required permissions or clearly documents the necessary provisioning step.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, jupyter-notebook
Domain
authorization, data-engineering, databases
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
68/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.