alterMaterializedViewContacts

Last updated: January 27, 2026

Sets or unsets contacts on a materialized view in Snowflake. Contacts provide a way to associate responsible parties with database objects for governance and support purposes. Materialized views require Snowflake Enterprise Edition or higher.

Note: This change type does not support automatic rollback or database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands). Contacts must be created before they can be assigned to objects.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the materialized view	No
`schemaName`	String	Name of the schema containing the materialized view	No
`viewName`	String	Name of the materialized view to alter	Yes
`setContacts`	Nested	Key-value pairs mapping contact purposes to contact names*	No
`unsetContacts`	Nested	List of contact purposes to remove*	No

*Exactly one of setContacts or unsetContacts must be specified.

setContacts attributes

Attribute	Type	Description	Required
`key`	String	Contact purpose: `steward`, `support`, or `approver`	Yes
`value`	String	Contact name (must reference an existing contact object)	Yes

unsetContacts attributes

Attribute	Type	Description	Required
`purpose`	String	Contact purpose to unset: `steward`, `support`, etc.	Yes

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set single contact -->
    <changeSet id="mv-set-single-contact" author="examples">
        <pro-snowflake:alterMaterializedViewContacts viewName="MV_CUSTOMERS">
            <pro-snowflake:setContacts>
                <pro-snowflake:entry key="steward" value="data_steward"/>
            </pro-snowflake:setContacts>
        </pro-snowflake:alterMaterializedViewContacts>
    </changeSet>

    <!-- Set multiple contacts -->
    <changeSet id="mv-set-multiple-contacts" author="examples">
        <pro-snowflake:alterMaterializedViewContacts
                schemaName="PUBLIC"
                viewName="MV_CUSTOMERS">
            <pro-snowflake:setContacts>
                <pro-snowflake:entry key="steward" value="data_steward"/>
                <pro-snowflake:entry key="support" value="support_team"/>
                <pro-snowflake:entry key="approver" value="compliance_officer"/>
            </pro-snowflake:setContacts>
        </pro-snowflake:alterMaterializedViewContacts>
    </changeSet>

    <!-- Unset single contact -->
    <changeSet id="mv-unset-single-contact" author="examples">
        <pro-snowflake:alterMaterializedViewContacts viewName="MV_CUSTOMERS">
            <pro-snowflake:unsetContacts>
                <pro-snowflake:unsetContact purpose="steward"/>
            </pro-snowflake:unsetContacts>
        </pro-snowflake:alterMaterializedViewContacts>
    </changeSet>

    <!-- Unset multiple contacts -->
    <changeSet id="mv-unset-multiple-contacts" author="examples">
        <pro-snowflake:alterMaterializedViewContacts viewName="MV_CUSTOMERS">
            <pro-snowflake:unsetContacts>
                <pro-snowflake:unsetContact purpose="steward"/>
                <pro-snowflake:unsetContact purpose="support"/>
                <pro-snowflake:unsetContact purpose="approver"/>
            </pro-snowflake:unsetContacts>
        </pro-snowflake:alterMaterializedViewContacts>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "mv-set-single-contact",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewContacts": {
              "viewName": "MV_CUSTOMERS",
              "setContacts": {
                "entries": [
                  { "entry": { "key": "steward", "value": "data_steward" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-set-multiple-contacts",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewContacts": {
              "schemaName": "PUBLIC",
              "viewName": "MV_CUSTOMERS",
              "setContacts": {
                "entries": [
                  { "entry": { "key": "steward", "value": "data_steward" } },
                  { "entry": { "key": "support", "value": "support_team" } },
                  { "entry": { "key": "approver", "value": "compliance_officer" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-unset-single-contact",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewContacts": {
              "viewName": "MV_CUSTOMERS",
              "unsetContacts": [
                { "unsetContact": { "purpose": "steward" } }
              ]
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-unset-multiple-contacts",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewContacts": {
              "viewName": "MV_CUSTOMERS",
              "unsetContacts": [
                { "unsetContact": { "purpose": "steward" } },
                { "unsetContact": { "purpose": "support" } },
                { "unsetContact": { "purpose": "approver" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set single contact
  - changeSet:
      id: mv-set-single-contact
      author: examples
      changes:
        - alterMaterializedViewContacts:
            viewName: MV_CUSTOMERS
            setContacts:
              entries:
                - entry:
                    key: steward
                    value: data_steward

  # Set multiple contacts
  - changeSet:
      id: mv-set-multiple-contacts
      author: examples
      changes:
        - alterMaterializedViewContacts:
            schemaName: PUBLIC
            viewName: MV_CUSTOMERS
            setContacts:
              entries:
                - entry:
                    key: steward
                    value: data_steward
                - entry:
                    key: support
                    value: support_team
                - entry:
                    key: approver
                    value: compliance_officer

  # Unset single contact
  - changeSet:
      id: mv-unset-single-contact
      author: examples
      changes:
        - alterMaterializedViewContacts:
            viewName: MV_CUSTOMERS
            unsetContacts:
              - unsetContact:
                  purpose: steward

  # Unset multiple contacts
  - changeSet:
      id: mv-unset-multiple-contacts
      author: examples
      changes:
        - alterMaterializedViewContacts:
            viewName: MV_CUSTOMERS
            unsetContacts:
              - unsetContact:
                  purpose: steward
              - unsetContact:
                  purpose: support
              - unsetContact:
                  purpose: approver

--liquibase formatted sql

--changeset examples:set-single-contact
-- Set single contact
ALTER MATERIALIZED VIEW PUBLIC.MV_CUSTOMERS SET CONTACT STEWARD = data_steward;

--changeset examples:set-multiple-contacts
-- Set multiple contacts
ALTER MATERIALIZED VIEW PUBLIC.MV_CUSTOMERS SET CONTACT STEWARD = data_steward, SUPPORT = support_team, APPROVER = compliance_officer;

--changeset examples:unset-single-contact
-- Unset single contact
ALTER MATERIALIZED VIEW PUBLIC.MV_CUSTOMERS UNSET CONTACT STEWARD;

--changeset examples:unset-multiple-contacts
-- Unset multiple contacts
ALTER MATERIALIZED VIEW PUBLIC.MV_CUSTOMERS UNSET CONTACT STEWARD, SUPPORT, APPROVER;

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set single contact -->
    <changeSet id="mv-set-single-contact" author="examples">
        <pro-snowflake:alterMaterializedViewContacts viewName="MV_CUSTOMERS">
            <pro-snowflake:setContacts>
                <pro-snowflake:entry key="steward" value="data_steward"/>
            </pro-snowflake:setContacts>
        </pro-snowflake:alterMaterializedViewContacts>
    </changeSet>

    <!-- Set multiple contacts -->
    <changeSet id="mv-set-multiple-contacts" author="examples">
        <pro-snowflake:alterMaterializedViewContacts
                schemaName="PUBLIC"
                viewName="MV_CUSTOMERS">
            <pro-snowflake:setContacts>
                <pro-snowflake:entry key="steward" value="data_steward"/>
                <pro-snowflake:entry key="support" value="support_team"/>
                <pro-snowflake:entry key="approver" value="compliance_officer"/>
            </pro-snowflake:setContacts>
        </pro-snowflake:alterMaterializedViewContacts>
    </changeSet>

    <!-- Unset single contact -->
    <changeSet id="mv-unset-single-contact" author="examples">
        <pro-snowflake:alterMaterializedViewContacts viewName="MV_CUSTOMERS">
            <pro-snowflake:unsetContacts>
                <pro-snowflake:unsetContact purpose="steward"/>
            </pro-snowflake:unsetContacts>
        </pro-snowflake:alterMaterializedViewContacts>
    </changeSet>

    <!-- Unset multiple contacts -->
    <changeSet id="mv-unset-multiple-contacts" author="examples">
        <pro-snowflake:alterMaterializedViewContacts viewName="MV_CUSTOMERS">
            <pro-snowflake:unsetContacts>
                <pro-snowflake:unsetContact purpose="steward"/>
                <pro-snowflake:unsetContact purpose="support"/>
                <pro-snowflake:unsetContact purpose="approver"/>
            </pro-snowflake:unsetContacts>
        </pro-snowflake:alterMaterializedViewContacts>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "mv-set-single-contact",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewContacts": {
              "viewName": "MV_CUSTOMERS",
              "setContacts": {
                "entries": [
                  { "entry": { "key": "steward", "value": "data_steward" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-set-multiple-contacts",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewContacts": {
              "schemaName": "PUBLIC",
              "viewName": "MV_CUSTOMERS",
              "setContacts": {
                "entries": [
                  { "entry": { "key": "steward", "value": "data_steward" } },
                  { "entry": { "key": "support", "value": "support_team" } },
                  { "entry": { "key": "approver", "value": "compliance_officer" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-unset-single-contact",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewContacts": {
              "viewName": "MV_CUSTOMERS",
              "unsetContacts": [
                { "unsetContact": { "purpose": "steward" } }
              ]
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-unset-multiple-contacts",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewContacts": {
              "viewName": "MV_CUSTOMERS",
              "unsetContacts": [
                { "unsetContact": { "purpose": "steward" } },
                { "unsetContact": { "purpose": "support" } },
                { "unsetContact": { "purpose": "approver" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set single contact
  - changeSet:
      id: mv-set-single-contact
      author: examples
      changes:
        - alterMaterializedViewContacts:
            viewName: MV_CUSTOMERS
            setContacts:
              entries:
                - entry:
                    key: steward
                    value: data_steward

  # Set multiple contacts
  - changeSet:
      id: mv-set-multiple-contacts
      author: examples
      changes:
        - alterMaterializedViewContacts:
            schemaName: PUBLIC
            viewName: MV_CUSTOMERS
            setContacts:
              entries:
                - entry:
                    key: steward
                    value: data_steward
                - entry:
                    key: support
                    value: support_team
                - entry:
                    key: approver
                    value: compliance_officer

  # Unset single contact
  - changeSet:
      id: mv-unset-single-contact
      author: examples
      changes:
        - alterMaterializedViewContacts:
            viewName: MV_CUSTOMERS
            unsetContacts:
              - unsetContact:
                  purpose: steward

  # Unset multiple contacts
  - changeSet:
      id: mv-unset-multiple-contacts
      author: examples
      changes:
        - alterMaterializedViewContacts:
            viewName: MV_CUSTOMERS
            unsetContacts:
              - unsetContact:
                  purpose: steward
              - unsetContact:
                  purpose: support
              - unsetContact:
                  purpose: approver

--liquibase formatted sql

--changeset examples:set-single-contact
-- Set single contact
ALTER MATERIALIZED VIEW PUBLIC.MV_CUSTOMERS SET CONTACT STEWARD = data_steward;

--changeset examples:set-multiple-contacts
-- Set multiple contacts
ALTER MATERIALIZED VIEW PUBLIC.MV_CUSTOMERS SET CONTACT STEWARD = data_steward, SUPPORT = support_team, APPROVER = compliance_officer;

--changeset examples:unset-single-contact
-- Unset single contact
ALTER MATERIALIZED VIEW PUBLIC.MV_CUSTOMERS UNSET CONTACT STEWARD;

--changeset examples:unset-multiple-contacts
-- Unset multiple contacts
ALTER MATERIALIZED VIEW PUBLIC.MV_CUSTOMERS UNSET CONTACT STEWARD, SUPPORT, APPROVER;