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
Last updated on