Share

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

• Manage Lifecycle of new and existing Share
• Manage Lifecycle of cloned Share
• Manage Grants of Share

Supported Parameters

The engine supports the parameters listed below.

• COMMENT: Specifies a comment for the share.
  • Configuration Key: comment
  • Data Type: String
• NAMESPACING: Specify whether Prefix or Suffix or both are to be added to Share Name[Doesn't apply to Default Database].
  • Configuration key: namespacing
  • Data Type: String
  • Possible Values:
    • none
    • prefix
    • suffix
    • both(Default)
• ENVIRONMENT: Specify the environment in which the Share is managed. Regex can be provided as well.
  • Configuration key: environment
  • Data Type: String
• MANAGE_MODE: Configures what properties to manage for the Share.
  • Configuration key: manage_mode
  • Data Type: String
  • Possible Values:
    • none
    • grants
    • all(Default)
• ACCOUNTS: A list of accounts to be added to the share
  • Configuration key: accounts
  • Data Type: List of String
• SHARE_RESTRICTIONS: Enables/disables adding a Standard or Enterprise consumer account to a share belonging to a Business Critical data provider. You must set this parameter each time you are adding a new non-Business Critical consumer account to the share belonging to a Business Critical provider.
  • Configuration key: share_restrictions
  • Data Type: Boolean

Basic syntax

shares:
  <share-name>:
    <configuration-key>: <value>
    accounts:
      - <account-name>

Examples

Share creation

shares:
  DEV_SHARE:
    comment: "share for Ingestion Developers"

Share with grants to accounts

shares:
  MODELLING_SHARE:
    comment: "share for Ingestion Developers"
    accounts:
      - <account-name>
      - <account-name>

Share with defined share_restrictions

shares:
  MODELLING_SHARE:
    comment: "share for Ingestion Developers"
    accounts:
      - <account-name>
      - <account-name>
    share_restrictions: false