alterViewProperties

Last updated: January 27, 2026

Sets or unsets properties on an existing Snowflake view.

Known limitations:

This change type does not support automatic rollback.
Snowflake snapshots created with Liquibase Secure 5.1 are incompatible with earlier versions due to enhanced object type detection for TABLES and VIEWS. Regenerate all snapshots with 5.1 after upgrading to avoid false differences in diff and diff-changelog operations.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the view	No
`schemaName`	String	Name of the schema containing the view	No
`viewName`	String	Name of the view to alter	Yes
`ifExists`	Boolean	If true, only alters if the view exists using `IF EXISTS`	No
`secure`	Boolean	Set to `true` for SET SECURE, `false` for UNSET SECURE	No*
`comment`	String	New comment text to set	No*
`unsetComment`	Boolean	If true, removes the existing comment	No*

*Exactly one SET or UNSET operation must be specified. Only one property can be set or unset per statement.

<?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 SECURE -->
    <changeSet id="set-secure" author="examples">
        <pro-snowflake:alterViewProperties
            viewName="MY_VIEW"
            secure="true"/>
    </changeSet>

    <!-- Unset SECURE -->
    <changeSet id="unset-secure" author="examples">
        <pro-snowflake:alterViewProperties
            viewName="MY_VIEW"
            secure="false"/>
    </changeSet>

    <!-- Set comment -->
    <changeSet id="set-comment" author="examples">
        <pro-snowflake:alterViewProperties
            viewName="MY_VIEW"
            comment="View containing customer data"/>
    </changeSet>

    <!-- Unset comment -->
    <changeSet id="unset-comment" author="examples">
        <pro-snowflake:alterViewProperties
            viewName="MY_VIEW"
            unsetComment="true"/>
    </changeSet>

    <!-- With IF EXISTS -->
    <changeSet id="alter-with-if-exists" author="examples">
        <pro-snowflake:alterViewProperties
            catalogName="MYDB"
            schemaName="PUBLIC"
            viewName="MY_VIEW"
            ifExists="true"
            secure="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-secure",
        "author": "examples",
        "changes": [
          {
            "alterViewProperties": {
              "viewName": "MY_VIEW",
              "secure": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-secure",
        "author": "examples",
        "changes": [
          {
            "alterViewProperties": {
              "viewName": "MY_VIEW",
              "secure": false
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "set-comment",
        "author": "examples",
        "changes": [
          {
            "alterViewProperties": {
              "viewName": "MY_VIEW",
              "comment": "View containing customer data"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-comment",
        "author": "examples",
        "changes": [
          {
            "alterViewProperties": {
              "viewName": "MY_VIEW",
              "unsetComment": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set SECURE
  - changeSet:
      id: set-secure
      author: examples
      changes:
        - alterViewProperties:
            viewName: MY_VIEW
            secure: true

  # Unset SECURE
  - changeSet:
      id: unset-secure
      author: examples
      changes:
        - alterViewProperties:
            viewName: MY_VIEW
            secure: false

  # Set comment
  - changeSet:
      id: set-comment
      author: examples
      changes:
        - alterViewProperties:
            viewName: MY_VIEW
            comment: View containing customer data

  # Unset comment
  - changeSet:
      id: unset-comment
      author: examples
      changes:
        - alterViewProperties:
            viewName: MY_VIEW
            unsetComment: true

--liquibase formatted sql

--changeset examples:set-secure
-- Set SECURE
ALTER VIEW MYDB.PUBLIC.MY_VIEW SET SECURE;

--changeset examples:unset-secure
-- Unset SECURE
ALTER VIEW MYDB.PUBLIC.MY_VIEW UNSET SECURE;

--changeset examples:set-comment
-- Set comment
ALTER VIEW MYDB.PUBLIC.MY_VIEW SET COMMENT = 'View containing customer data';

--changeset examples:unset-comment
-- Unset comment
ALTER VIEW MYDB.PUBLIC.MY_VIEW UNSET COMMENT;

--changeset examples:with-if-exists
-- With IF EXISTS
ALTER VIEW IF EXISTS MYDB.PUBLIC.MY_VIEW SET SECURE;

<?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 SECURE -->
    <changeSet id="set-secure" author="examples">
        <pro-snowflake:alterViewProperties
            viewName="MY_VIEW"
            secure="true"/>
    </changeSet>

    <!-- Unset SECURE -->
    <changeSet id="unset-secure" author="examples">
        <pro-snowflake:alterViewProperties
            viewName="MY_VIEW"
            secure="false"/>
    </changeSet>

    <!-- Set comment -->
    <changeSet id="set-comment" author="examples">
        <pro-snowflake:alterViewProperties
            viewName="MY_VIEW"
            comment="View containing customer data"/>
    </changeSet>

    <!-- Unset comment -->
    <changeSet id="unset-comment" author="examples">
        <pro-snowflake:alterViewProperties
            viewName="MY_VIEW"
            unsetComment="true"/>
    </changeSet>

    <!-- With IF EXISTS -->
    <changeSet id="alter-with-if-exists" author="examples">
        <pro-snowflake:alterViewProperties
            catalogName="MYDB"
            schemaName="PUBLIC"
            viewName="MY_VIEW"
            ifExists="true"
            secure="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-secure",
        "author": "examples",
        "changes": [
          {
            "alterViewProperties": {
              "viewName": "MY_VIEW",
              "secure": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-secure",
        "author": "examples",
        "changes": [
          {
            "alterViewProperties": {
              "viewName": "MY_VIEW",
              "secure": false
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "set-comment",
        "author": "examples",
        "changes": [
          {
            "alterViewProperties": {
              "viewName": "MY_VIEW",
              "comment": "View containing customer data"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-comment",
        "author": "examples",
        "changes": [
          {
            "alterViewProperties": {
              "viewName": "MY_VIEW",
              "unsetComment": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set SECURE
  - changeSet:
      id: set-secure
      author: examples
      changes:
        - alterViewProperties:
            viewName: MY_VIEW
            secure: true

  # Unset SECURE
  - changeSet:
      id: unset-secure
      author: examples
      changes:
        - alterViewProperties:
            viewName: MY_VIEW
            secure: false

  # Set comment
  - changeSet:
      id: set-comment
      author: examples
      changes:
        - alterViewProperties:
            viewName: MY_VIEW
            comment: View containing customer data

  # Unset comment
  - changeSet:
      id: unset-comment
      author: examples
      changes:
        - alterViewProperties:
            viewName: MY_VIEW
            unsetComment: true

--liquibase formatted sql

--changeset examples:set-secure
-- Set SECURE
ALTER VIEW MYDB.PUBLIC.MY_VIEW SET SECURE;

--changeset examples:unset-secure
-- Unset SECURE
ALTER VIEW MYDB.PUBLIC.MY_VIEW UNSET SECURE;

--changeset examples:set-comment
-- Set comment
ALTER VIEW MYDB.PUBLIC.MY_VIEW SET COMMENT = 'View containing customer data';

--changeset examples:unset-comment
-- Unset comment
ALTER VIEW MYDB.PUBLIC.MY_VIEW UNSET COMMENT;

--changeset examples:with-if-exists
-- With IF EXISTS
ALTER VIEW IF EXISTS MYDB.PUBLIC.MY_VIEW SET SECURE;

alterViewProperties

Available attributes

XML example

JSON example

YAML example

SQL example

More like this