renameFileFormat

Last updated: January 27, 2026

Renames an existing file format in Snowflake.

Note: Automatic rollback renames the file format back to original name.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the file format	No
`schemaName`	String	Name of the schema containing the file format	No
`oldFileFormatName`	String	Current name of the file format	Yes
`newFileFormatName`	String	New name for the file format	Yes
`ifExists`	Boolean	Only rename if the file format 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-file-format-basic" author="examples">
        <pro-snowflake:renameFileFormat
                oldFileFormatName="CSV_FORMAT"
                newFileFormatName="CSV_FORMAT_V2"/>
    </changeSet>

    <!-- Rename with IF EXISTS -->
    <changeSet id="rename-file-format-if-exists" author="examples">
        <pro-snowflake:renameFileFormat
                oldFileFormatName="OLD_JSON_FORMAT"
                newFileFormatName="JSON_FORMAT_PRODUCTION"
                ifExists="true"/>
    </changeSet>

    <!-- Rename with schema qualification -->
    <changeSet id="rename-file-format-qualified" author="examples">
        <pro-snowflake:renameFileFormat
                catalogName="MY_DATABASE"
                schemaName="STAGING"
                oldFileFormatName="TEMP_FORMAT"
                newFileFormatName="PRODUCTION_FORMAT"
                ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-file-format-basic",
        "author": "examples",
        "changes": [
          {
            "renameFileFormat": {
              "oldFileFormatName": "CSV_FORMAT",
              "newFileFormatName": "CSV_FORMAT_V2"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-file-format-if-exists",
        "author": "examples",
        "changes": [
          {
            "renameFileFormat": {
              "oldFileFormatName": "OLD_JSON_FORMAT",
              "newFileFormatName": "JSON_FORMAT_PRODUCTION",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-file-format-qualified",
        "author": "examples",
        "changes": [
          {
            "renameFileFormat": {
              "catalogName": "MY_DATABASE",
              "schemaName": "STAGING",
              "oldFileFormatName": "TEMP_FORMAT",
              "newFileFormatName": "PRODUCTION_FORMAT",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic rename
  - changeSet:
      id: rename-file-format-basic
      author: examples
      changes:
        - renameFileFormat:
            oldFileFormatName: CSV_FORMAT
            newFileFormatName: CSV_FORMAT_V2

  # Rename with IF EXISTS
  - changeSet:
      id: rename-file-format-if-exists
      author: examples
      changes:
        - renameFileFormat:
            oldFileFormatName: OLD_JSON_FORMAT
            newFileFormatName: JSON_FORMAT_PRODUCTION
            ifExists: true

  # Rename with schema qualification
  - changeSet:
      id: rename-file-format-qualified
      author: examples
      changes:
        - renameFileFormat:
            catalogName: MY_DATABASE
            schemaName: STAGING
            oldFileFormatName: TEMP_FORMAT
            newFileFormatName: PRODUCTION_FORMAT
            ifExists: true

--liquibase formatted sql

--changeset examples:basic-rename
-- Basic rename
ALTER FILE FORMAT PUBLIC.CSV_FORMAT RENAME TO PUBLIC.CSV_FORMAT_V2;

--changeset examples:rename-with-if-exists
-- Rename with IF EXISTS
ALTER FILE FORMAT IF EXISTS PUBLIC.OLD_JSON_FORMAT RENAME TO PUBLIC.JSON_FORMAT_PRODUCTION;

--changeset examples:rename-with-schema-qualification
-- Rename with schema qualification
ALTER FILE FORMAT IF EXISTS MY_DATABASE.STAGING.TEMP_FORMAT RENAME TO MY_DATABASE.STAGING.PRODUCTION_FORMAT;

<?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-file-format-basic" author="examples">
        <pro-snowflake:renameFileFormat
                oldFileFormatName="CSV_FORMAT"
                newFileFormatName="CSV_FORMAT_V2"/>
    </changeSet>

    <!-- Rename with IF EXISTS -->
    <changeSet id="rename-file-format-if-exists" author="examples">
        <pro-snowflake:renameFileFormat
                oldFileFormatName="OLD_JSON_FORMAT"
                newFileFormatName="JSON_FORMAT_PRODUCTION"
                ifExists="true"/>
    </changeSet>

    <!-- Rename with schema qualification -->
    <changeSet id="rename-file-format-qualified" author="examples">
        <pro-snowflake:renameFileFormat
                catalogName="MY_DATABASE"
                schemaName="STAGING"
                oldFileFormatName="TEMP_FORMAT"
                newFileFormatName="PRODUCTION_FORMAT"
                ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-file-format-basic",
        "author": "examples",
        "changes": [
          {
            "renameFileFormat": {
              "oldFileFormatName": "CSV_FORMAT",
              "newFileFormatName": "CSV_FORMAT_V2"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-file-format-if-exists",
        "author": "examples",
        "changes": [
          {
            "renameFileFormat": {
              "oldFileFormatName": "OLD_JSON_FORMAT",
              "newFileFormatName": "JSON_FORMAT_PRODUCTION",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-file-format-qualified",
        "author": "examples",
        "changes": [
          {
            "renameFileFormat": {
              "catalogName": "MY_DATABASE",
              "schemaName": "STAGING",
              "oldFileFormatName": "TEMP_FORMAT",
              "newFileFormatName": "PRODUCTION_FORMAT",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic rename
  - changeSet:
      id: rename-file-format-basic
      author: examples
      changes:
        - renameFileFormat:
            oldFileFormatName: CSV_FORMAT
            newFileFormatName: CSV_FORMAT_V2

  # Rename with IF EXISTS
  - changeSet:
      id: rename-file-format-if-exists
      author: examples
      changes:
        - renameFileFormat:
            oldFileFormatName: OLD_JSON_FORMAT
            newFileFormatName: JSON_FORMAT_PRODUCTION
            ifExists: true

  # Rename with schema qualification
  - changeSet:
      id: rename-file-format-qualified
      author: examples
      changes:
        - renameFileFormat:
            catalogName: MY_DATABASE
            schemaName: STAGING
            oldFileFormatName: TEMP_FORMAT
            newFileFormatName: PRODUCTION_FORMAT
            ifExists: true

--liquibase formatted sql

--changeset examples:basic-rename
-- Basic rename
ALTER FILE FORMAT PUBLIC.CSV_FORMAT RENAME TO PUBLIC.CSV_FORMAT_V2;

--changeset examples:rename-with-if-exists
-- Rename with IF EXISTS
ALTER FILE FORMAT IF EXISTS PUBLIC.OLD_JSON_FORMAT RENAME TO PUBLIC.JSON_FORMAT_PRODUCTION;

--changeset examples:rename-with-schema-qualification
-- Rename with schema qualification
ALTER FILE FORMAT IF EXISTS MY_DATABASE.STAGING.TEMP_FORMAT RENAME TO MY_DATABASE.STAGING.PRODUCTION_FORMAT;

renameFileFormat

Available attributes

XML

JSON

YAML

SQL

More like this