Learn about data formatting rules when loading data from CSV and FBV files.
You can use the IMPORT command to load files from your local file system or from a remote file storage service. To improve performance when loading from remote storage, you can split the files into several parts to allow Exasol to read/write the data in parallel.
This article describes the data formatting rules for comma-separated value (CSV) and fixed block value (FBV) files.
To learn about data formatting and options when importing Parquet files, see Importing Parquet files.
The native bulk loader in Exasol is normally the most efficient way to load data. If integration with an external bulk loading tool is desired you can use the Java command-line tool EXAjload, which is available as a part of the JDBC driver package.
You can use EXAjload to start a loading job using a script without opening a JDBC connection. To learn more, use ./exajload -help (Linux) or java -jar ./exajload.jar -help (Windows) after installing the JDBC driver.
For additional information and examples, see also EXAjload: advanced techniques.