A new data engineering team team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to…

To grant full privileges on a table such as 'sales' to a group like 'team', the correct SQL command in

Databricks is:

GRANT ALL PRIVILEGES ON TABLE sales TO team;

This command assigns all available privileges, including SELECT, INSERT, UPDATE, DELETE, and any

other data manipulation or definition actions, to the specified team. This is typically necessary when

a team needs full control over a table to manage and manipulate it as part of a project or ongoing

maintenance.

Reference:

Databricks documentation on SQL permissions: SQL Permissions in Databricks