Question

A data engineering team lead wants to allow a group of ETL developers to create new tables within an existing schema named 'sales.reporting' in Unity Catalog. The developers already have USE CATALOG on the 'sales' catalog. Which additional privileges must be granted so the developers can successfully create tables in that schema?

Accepted Answer

USE SCHEMA and CREATE TABLE on the 'sales.reporting' schema

Answer

ALL PRIVILEGES on the 'sales' catalog only

Answer

CREATE SCHEMA on the 'sales' catalog

Answer

MODIFY and SELECT on the 'sales.reporting' schema