Drops an existing file format in Snowflake.
Note: This change type does not support automatic rollback.
Attribute | Type | Description | Required |
|---|---|---|---|
| String | Name of the catalog (database) containing the file format | No |
| String | Name of the schema containing the file format | No |
| String | Name of the file format to drop | Yes |
| Boolean | Only drop if the file format exists using | 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><?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>