Materialized View
Configuration can be provided to Snowflake Object Lifecycle Engine for the following operation with materialized view:
- Manage Grants of Materialized View
Supported Parameters
The engine supports the parameters listed below.
- MANAGE_MODE: Configures what properties to manage for the Materialized View.
- Configuration key:
manage_mode
- Data Type: String
- Possible Values:
none
grants
all
(Default)
- Configuration key:
- GRANTS: List of Privileges and Roles to which privileges are granted to on the current Materialized View.
- Configuration key:
grants
- Data Type: Map
- Configuration key:
- SHARES: List of SHARES to which privileges are granted.
- Configuration key:
shares
- Data Type: Map
- Configuration key:
Basic syntax
materialized_views:
<materialized-view-name>:
shares:
<privilege>:
- <share-name>
- <share-name>
grants:
<privilege>:
- <grant-name>
- <grant-name>
Supported Materialized View Grants to Roles
Following is the list of privileges grant to Roles that can be specified in the Materialized View definition
- ALL PRIVILEGES
- SELECT
- OWNERSHIP
Supported Materialized View Grants to Shares
Following is the list of privileges grant to Shares that can be specified in the Materialized View definition
- SELECT
Examples
materialized_views:
DEV_VIEW:
grants:
SELECT:
- HR_ROLE
- ACCOUNTADMIN
shares:
SELECT:
- DEV_SHARE