alterSchemaContacts

Last updated: January 27, 2026

Sets or unsets contacts on a Snowflake schema.

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 database containing the schema	No
`targetSchemaName`	String	Name of the schema to alter	Yes
`ifExists`	Boolean	Don't error if schema doesn't exist	No
`setContacts`	Map	Contact purpose to contact name mappings*	No
`unsetContacts`	List	List of contact purposes to remove*	No

* Exactly one of setContacts or unsetContacts must be specified.

Contact purposes

Purpose	SQL Equivalent	Description
`Steward`	`STEWARD`	Data steward responsible for the schema
`Support`	`SUPPORT`	Support contact for operational issues
`Approver`	`ACCESS_APPROVAL`	Contact for access approval requests

unsetContact attributes

Attribute	Type	Description	Required
`purpose`	String	Contact purpose to remove	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 contacts -->
    <changeSet id="set-schema-contacts" author="examples">
        <pro-snowflake:alterSchemaContacts targetSchemaName="ANALYTICS">
            <pro-snowflake:setContacts>
                <pro-snowflake:entry key="Steward" value="PUBLIC.data_steward"/>
                <pro-snowflake:entry key="Support" value="PUBLIC.support_team"/>
            </pro-snowflake:setContacts>
        </pro-snowflake:alterSchemaContacts>
    </changeSet>

    <!-- Set contacts with IF EXISTS -->
    <changeSet id="set-contacts-if-exists" author="examples">
        <pro-snowflake:alterSchemaContacts
                targetSchemaName="STAGING"
                ifExists="true">
            <pro-snowflake:setContacts>
                <pro-snowflake:entry key="Approver" value="PUBLIC.approver_contact"/>
            </pro-snowflake:setContacts>
        </pro-snowflake:alterSchemaContacts>
    </changeSet>

    <!-- Unset contacts -->
    <changeSet id="unset-schema-contacts" author="examples">
        <pro-snowflake:alterSchemaContacts targetSchemaName="ANALYTICS">
            <pro-snowflake:unsetContacts>
                <pro-snowflake:unsetContact purpose="Steward"/>
                <pro-snowflake:unsetContact purpose="Support"/>
            </pro-snowflake:unsetContacts>
        </pro-snowflake:alterSchemaContacts>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-schema-contacts",
        "author": "examples",
        "changes": [
          {
            "alterSchemaContacts": {
              "targetSchemaName": "ANALYTICS",
              "setContacts": {
                "entries": [
                  { "entry": { "key": "Steward", "value": "PUBLIC.data_steward" } },
                  { "entry": { "key": "Support", "value": "PUBLIC.support_team" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "set-contacts-if-exists",
        "author": "examples",
        "changes": [
          {
            "alterSchemaContacts": {
              "targetSchemaName": "STAGING",
              "ifExists": true,
              "setContacts": {
                "entries": [
                  { "entry": { "key": "Approver", "value": "PUBLIC.approver_contact" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-schema-contacts",
        "author": "examples",
        "changes": [
          {
            "alterSchemaContacts": {
              "targetSchemaName": "ANALYTICS",
              "unsetContacts": [
                { "unsetContact": { "purpose": "Steward" } },
                { "unsetContact": { "purpose": "Support" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set contacts
  - changeSet:
      id: set-schema-contacts
      author: examples
      changes:
        - alterSchemaContacts:
            targetSchemaName: ANALYTICS
            setContacts:
              entries:
                - entry:
                    key: Steward
                    value: PUBLIC.data_steward
                - entry:
                    key: Support
                    value: PUBLIC.support_team

  # Set contacts with IF EXISTS
  - changeSet:
      id: set-contacts-if-exists
      author: examples
      changes:
        - alterSchemaContacts:
            targetSchemaName: STAGING
            ifExists: true
            setContacts:
              entries:
                - entry:
                    key: Approver
                    value: PUBLIC.approver_contact

  # Unset contacts
  - changeSet:
      id: unset-schema-contacts
      author: examples
      changes:
        - alterSchemaContacts:
            targetSchemaName: ANALYTICS
            unsetContacts:
              - unsetContact:
                  purpose: Steward
              - unsetContact:
                  purpose: Support

--liquibase formatted sql

--changeset examples:set-contacts
-- Set contacts
ALTER SCHEMA ANALYTICS SET CONTACT STEWARD = PUBLIC.data_steward, SUPPORT = PUBLIC.support_team;

--changeset examples:set-contacts-with-if-exists
-- Set contacts with IF EXISTS
ALTER SCHEMA IF EXISTS STAGING SET CONTACT ACCESS_APPROVAL = PUBLIC.approver_contact;

--changeset examples:unset-contacts
-- Unset contacts
ALTER SCHEMA ANALYTICS UNSET CONTACT STEWARD, SUPPORT;

<?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 contacts -->
    <changeSet id="set-schema-contacts" author="examples">
        <pro-snowflake:alterSchemaContacts targetSchemaName="ANALYTICS">
            <pro-snowflake:setContacts>
                <pro-snowflake:entry key="Steward" value="PUBLIC.data_steward"/>
                <pro-snowflake:entry key="Support" value="PUBLIC.support_team"/>
            </pro-snowflake:setContacts>
        </pro-snowflake:alterSchemaContacts>
    </changeSet>

    <!-- Set contacts with IF EXISTS -->
    <changeSet id="set-contacts-if-exists" author="examples">
        <pro-snowflake:alterSchemaContacts
                targetSchemaName="STAGING"
                ifExists="true">
            <pro-snowflake:setContacts>
                <pro-snowflake:entry key="Approver" value="PUBLIC.approver_contact"/>
            </pro-snowflake:setContacts>
        </pro-snowflake:alterSchemaContacts>
    </changeSet>

    <!-- Unset contacts -->
    <changeSet id="unset-schema-contacts" author="examples">
        <pro-snowflake:alterSchemaContacts targetSchemaName="ANALYTICS">
            <pro-snowflake:unsetContacts>
                <pro-snowflake:unsetContact purpose="Steward"/>
                <pro-snowflake:unsetContact purpose="Support"/>
            </pro-snowflake:unsetContacts>
        </pro-snowflake:alterSchemaContacts>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-schema-contacts",
        "author": "examples",
        "changes": [
          {
            "alterSchemaContacts": {
              "targetSchemaName": "ANALYTICS",
              "setContacts": {
                "entries": [
                  { "entry": { "key": "Steward", "value": "PUBLIC.data_steward" } },
                  { "entry": { "key": "Support", "value": "PUBLIC.support_team" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "set-contacts-if-exists",
        "author": "examples",
        "changes": [
          {
            "alterSchemaContacts": {
              "targetSchemaName": "STAGING",
              "ifExists": true,
              "setContacts": {
                "entries": [
                  { "entry": { "key": "Approver", "value": "PUBLIC.approver_contact" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-schema-contacts",
        "author": "examples",
        "changes": [
          {
            "alterSchemaContacts": {
              "targetSchemaName": "ANALYTICS",
              "unsetContacts": [
                { "unsetContact": { "purpose": "Steward" } },
                { "unsetContact": { "purpose": "Support" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set contacts
  - changeSet:
      id: set-schema-contacts
      author: examples
      changes:
        - alterSchemaContacts:
            targetSchemaName: ANALYTICS
            setContacts:
              entries:
                - entry:
                    key: Steward
                    value: PUBLIC.data_steward
                - entry:
                    key: Support
                    value: PUBLIC.support_team

  # Set contacts with IF EXISTS
  - changeSet:
      id: set-contacts-if-exists
      author: examples
      changes:
        - alterSchemaContacts:
            targetSchemaName: STAGING
            ifExists: true
            setContacts:
              entries:
                - entry:
                    key: Approver
                    value: PUBLIC.approver_contact

  # Unset contacts
  - changeSet:
      id: unset-schema-contacts
      author: examples
      changes:
        - alterSchemaContacts:
            targetSchemaName: ANALYTICS
            unsetContacts:
              - unsetContact:
                  purpose: Steward
              - unsetContact:
                  purpose: Support

--liquibase formatted sql

--changeset examples:set-contacts
-- Set contacts
ALTER SCHEMA ANALYTICS SET CONTACT STEWARD = PUBLIC.data_steward, SUPPORT = PUBLIC.support_team;

--changeset examples:set-contacts-with-if-exists
-- Set contacts with IF EXISTS
ALTER SCHEMA IF EXISTS STAGING SET CONTACT ACCESS_APPROVAL = PUBLIC.approver_contact;

--changeset examples:unset-contacts
-- Unset contacts
ALTER SCHEMA ANALYTICS UNSET CONTACT STEWARD, SUPPORT;

alterSchemaContacts

Available attributes

Contact purposes

unsetContact attributes

XML example

JSON example

YAML example

SQL example

More like this