Required Privileges
Flattened tables require the following privileges:
- To view flattened table data: READ privileges. No privileges are required on queried tables.
- To add
SET USING
orDEFAULT
columns that query other tables: SELECT privileges on the queried tables, CREATE privileges on the flattened table. - To load data: SELECT privileges on queried tables.
Running REFRESH_COLUMNS
requires the following privileges on the flattened table:
- MODIFY privilege on the table, USAGE privilege on its schema
- For each
SET USING
column that queries another table or view: SELECT privilege on the queried table, USAGE privilege on its schema.