Skip to main content

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