renameRole

Last updated: January 27, 2026

Renames an existing role in Snowflake.

Note: Automatic rollback renames the role back to original name.

Known limitation: This change type does not support database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands).

Available attributes

Attribute	Type	Description	Required
`oldRoleName`	String	Current name of the role	Yes
`newRoleName`	String	New name for the role	Yes
`ifExists`	Boolean	Only rename if the role exists using `IF EXISTS`	No

<?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">

    <!-- Basic rename -->
    <changeSet id="rename-role-basic" author="examples">
        <pro-snowflake:renameRole
                oldRoleName="DATA_ANALYST_ROLE"
                newRoleName="ANALYTICS_ROLE"/>
    </changeSet>

    <!-- Rename with IF EXISTS -->
    <changeSet id="rename-role-if-exists" author="examples">
        <pro-snowflake:renameRole
                oldRoleName="ANALYTICS_ROLE"
                newRoleName="SENIOR_ANALYST_ROLE"
                ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-role-basic",
        "author": "examples",
        "changes": [
          {
            "renameRole": {
              "oldRoleName": "DATA_ANALYST_ROLE",
              "newRoleName": "ANALYTICS_ROLE"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-role-if-exists",
        "author": "examples",
        "changes": [
          {
            "renameRole": {
              "oldRoleName": "ANALYTICS_ROLE",
              "newRoleName": "SENIOR_ANALYST_ROLE",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic rename
  - changeSet:
      id: rename-role-basic
      author: examples
      changes:
        - renameRole:
            oldRoleName: DATA_ANALYST_ROLE
            newRoleName: ANALYTICS_ROLE

  # Rename with IF EXISTS
  - changeSet:
      id: rename-role-if-exists
      author: examples
      changes:
        - renameRole:
            oldRoleName: ANALYTICS_ROLE
            newRoleName: SENIOR_ANALYST_ROLE
            ifExists: true

--liquibase formatted sql

--changeset examples:basic-rename
-- Basic rename
ALTER ROLE DATA_ANALYST_ROLE RENAME TO ANALYTICS_ROLE;

--changeset examples:rename-with-if-exists
-- Rename with IF EXISTS
ALTER ROLE IF EXISTS ANALYTICS_ROLE RENAME TO SENIOR_ANALYST_ROLE;

<?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">

    <!-- Basic rename -->
    <changeSet id="rename-role-basic" author="examples">
        <pro-snowflake:renameRole
                oldRoleName="DATA_ANALYST_ROLE"
                newRoleName="ANALYTICS_ROLE"/>
    </changeSet>

    <!-- Rename with IF EXISTS -->
    <changeSet id="rename-role-if-exists" author="examples">
        <pro-snowflake:renameRole
                oldRoleName="ANALYTICS_ROLE"
                newRoleName="SENIOR_ANALYST_ROLE"
                ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-role-basic",
        "author": "examples",
        "changes": [
          {
            "renameRole": {
              "oldRoleName": "DATA_ANALYST_ROLE",
              "newRoleName": "ANALYTICS_ROLE"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-role-if-exists",
        "author": "examples",
        "changes": [
          {
            "renameRole": {
              "oldRoleName": "ANALYTICS_ROLE",
              "newRoleName": "SENIOR_ANALYST_ROLE",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic rename
  - changeSet:
      id: rename-role-basic
      author: examples
      changes:
        - renameRole:
            oldRoleName: DATA_ANALYST_ROLE
            newRoleName: ANALYTICS_ROLE

  # Rename with IF EXISTS
  - changeSet:
      id: rename-role-if-exists
      author: examples
      changes:
        - renameRole:
            oldRoleName: ANALYTICS_ROLE
            newRoleName: SENIOR_ANALYST_ROLE
            ifExists: true

--liquibase formatted sql

--changeset examples:basic-rename
-- Basic rename
ALTER ROLE DATA_ANALYST_ROLE RENAME TO ANALYTICS_ROLE;

--changeset examples:rename-with-if-exists
-- Rename with IF EXISTS
ALTER ROLE IF EXISTS ANALYTICS_ROLE RENAME TO SENIOR_ANALYST_ROLE;

renameRole

Available attributes

XML example

JSON example

YAML example

SQL example