Skip to main content

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)
  • GRANTS: List of Privileges and Roles to which privileges are granted to on the current Materialized View.
    • Configuration key: grants
    • Data Type: Map
  • SHARES: List of SHARES to which privileges are granted.
    • Configuration key: shares
    • Data Type: Map

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