Skip to main content

File Format

This page provides a comprehensive overview of File Format operations in Databend, organized by functionality for easy reference.

File Format Management

CommandDescription
CREATE FILE FORMATCreates a named file format object for use in data loading and unloading
DROP FILE FORMATRemoves a file format object

File Format Information

CommandDescription
SHOW FILE FORMATSLists all file formats in the current database
note

File formats in Databend define how data files should be parsed during data loading operations or formatted during data unloading operations. They provide a reusable way to specify file type, field delimiters, compression, and other formatting options.

Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today