Question

A data engineer manages a Unity Catalog schema named sales.reporting that currently contains 12 tables, with more tables added weekly by an automated pipeline. The analytics team needs read access to all current and future tables in this schema without requiring the engineer to run a new grant each time a table is created. Which single GRANT statement accomplishes this most efficiently?

Accepted Answer

GRANT SELECT ON SCHEMA sales.reporting TO `analytics_team`

Answer

Run GRANT SELECT ON TABLE for each of the 12 existing tables individually

Answer

GRANT SELECT ON CATALOG sales TO `analytics_team`

Answer

GRANT ALL PRIVILEGES ON SCHEMA sales.reporting TO `analytics_team`