This article describes the file formats that are supported when loading data from files into an Exasol database.
Exasol supports loading data from files in comma-separated value (CSV) and fixed block value (FBV) formats. You can use the IMPORT command to load CSV/FBV files directly from your local file system or from a remote file storage service. To improve performance when loading from a remote storage service, you can split the files into several parts to allow Exasol to read/write the data in parallel.
If integration with an external bulk loading tool is required, you can use the command-line tool exajload, which is available as a part of the JDBC driver package. You can use this tool to start a loading job using a script without opening a JDBC connection. To learn more about the available options in exajload, run the command ./exajload -help (Linux) or java -jar ./exajload.jar -help (Windows). For additional information and examples on how to use EXAjload, see EXAjload: advanced techniques.