dropFileFormat

Drops an existing file format in Snowflake.

Note: This change type does not support automatic rollback.

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

fileFormatName

String

Name of the file format to drop

Yes

ifExists

Boolean

Only drop 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 drop -->
  <changeSet id="drop-file-format-basic" author="examples">
    <pro-snowflake:dropFileFormat fileFormatName="OLD_CSV_FORMAT"/>
  </changeSet>
  <!-- Drop with IF EXISTS -->
  <changeSet id="drop-file-format-if-exists" author="examples">
    <pro-snowflake:dropFileFormat
                fileFormatName="DEPRECATED_FORMAT"
                ifExists="true"/>
  </changeSet>
  <!-- Drop with schema qualification -->
  <changeSet id="drop-file-format-qualified" author="examples">
    <pro-snowflake:dropFileFormat
                catalogName="MY_DATABASE"
                schemaName="STAGING"
                fileFormatName="TEMP_FORMAT"
                ifExists="true"/>
  </changeSet>
</databaseChangeLog>