View

Configuration can be provided to Snowflake Object Lifecycle Engine for the following operation with View:

• Manage Grants of View

Supported Parameters

The engine supports the parameters listed below.

• MANAGE_MODE: Configures what properties to manage for the View.
  • Configuration key: manage_mode
  • Data Type: String
  • Possible Values:
    • none
    • grants
    • all(Default)
• SHARES: List of SHARES to which privileges are granted.
  • Configuration key: shares
  • Data Type: Map
• GRANTS: List of Privileges and Roles to which privileges are granted to on the current view.
  • Configuration key: grants
  • Data Type: Map

Basic syntax

view:  <view-name>:    shares:      <privilege>:        - <share-name>        - <share-name>    grants:      <privilege>:        - <grant-name>        - <grant-name>

Supported View Grants to Roles

Following is the list of Privileges Grant to Roles that can be specified in the View definition

• ALL PRIVILEGES
• SELECT
• OWNERSHIP

Supported View Grants to Shares

Following is the list of Privileges Grant to Shares that can be specified in the View definition

• SELECT

Examples

view:  DEV_VIEW:    grants:      SELECT:        - HR_ROLE        - ACCOUNTADMIN    shares:      SELECT:        - DEV_SHARE