MicrosoftLearning / MicrosoftLearning/DP-750T00-Implement-Data-Engineering-Solutions-using-Azure-Databricks
Permissions error
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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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