dropFileFormat

Last updated: September 2, 2025

The dropFileFormat Change type removes an existing FILE FORMAT object in Snowflake. Once dropped, the file format cannot be recovered and must be recreated if needed. This change type helps clean up unused file formats or remove obsolete definitions.

Run dropFileFormat

To run this Change type, follow these steps:

  1. Add the Change type to your changeset, as shown in the examples on this page.

  2. Specify any required attributes. Use the table on this page to see which ones your database requires.

  3. Deploy your changeset by running the command:liquibase update

Available attributes

Name

Type

Description

Requirement

dropFileFormat

object

Contains fileFormatName of format to drop, and ifExists boolean.

Required

Nested attributes

dropFileFormat

Name

Type

Description

Requirement

fileFormatName

String

Name of the file format to create

Required

ifExists

Boolean

If true, do not raise an error if the file format does not exist

Optional

databaseChangeLog:
  - changeSet:
      id: 1
      author: your.name
      comment: drop_file_format_comment
      changes:
        - dropFileFormat:
            fileFormatName: deprecated_json_format
            ifExists: true

dropFileFormat - Liquibase