Skip to content

Materialized View

You can provide configuration to Snowflake Object Lifecycle Engine for the following operation with a materialized view:

  • Manage grants of materialized view

Usage

- materialized_view:
    name: <materialized-view-name>
    database: rel(database.<database-name>)
    schema: rel(schema.<schema-name>)
    shares:
      <privilege>:
        - rel(share.<share-name>)
        - rel(share.<share-name>)
    grants:
      <privilege>:
        - rel(role.<grant-name>)
        - rel(role.<grant-name>)
databases:
  <database-name>:
    schemas:
      <schema-name>:
        materialized_views:
          <materialized-view-name>:
            shares:
              <privilege>:
                - <share-name>
                - <share-name>
            grants:
              <privilege>:
                - <grant-name>
                - <grant-name>

Supported parameters

The engine supports the parameters listed below.

Configuration Key Required/Optional Data Type and Values Description
grants Optional Map: See Supported Materialized View Grants to Roles Lists the Privileges and Roles to which privileges are granted on the current materialized view
depends_on Optional List of String: See Object Dependencies for a definition of depends_on List of SOLE-managed objects that this materialized view depends on. Objects defined in the list will be added to the generated HCL dependencies list to ensure proper creation order.
manage_mode Optional String: grants (default), none Configures what properties to manage for the materialized view
shares Optional Map List of shares to which privileges are granted

Supported materialized view grants to roles

Following are the privileges you can grant to roles in the materialized view definition:

  • ALL PRIVILEGES
  • SELECT
  • OWNERSHIP
  • REFERENCES - only if the DATAOPS_SOLE_MANAGE_REFERENCES variable is set to a value in the SOLE orchestrator.

ALL PRIVILEGES handling

When you define ALL PRIVILEGES in the SOLE configuration file, you grant all the privileges listed above to roles on this object except OWNERSHIP. However, the management of ALL PRIVILEGES in SOLE differs from its handling in Snowflake. See Handling ALL PRIVILEGES in SOLE for more information.

Supported materialized view grants to shares

Following are the privileges you can grant to shares in the materialized view definition

  • SELECT

Examples

- materialized_view:
    name: DEV_VIEW
    database: rel(database.SALES_RECORD)
    schema: rel(schema.SALES)
    grants:
      SELECT:
        - rel(role.HR_ROLE)
        - ACCOUNTADMIN
    shares:
      SELECT:
        - rel(share.DEV_SHARE)
databases:
  SALES_RECORD:
    schemas:
      SALES:
        materialized_views:
          DEV_VIEW:
            grants:
              SELECT:
                - HR_ROLE
                - ACCOUNTADMIN
            shares:
              SELECT:
                - DEV_SHARE