Load Data from File
This section describes how to load data into Exasol from files on various systems.
Exasol includes a native bulk loader (EXALoader), eliminating the need for an external bulk loading tool. The native bulk loader increases performance by leveraging the parallel cluster, and simplifies the ETL process by allowing you to use the SQL statements IMPORT and EXPORT instead of external client tools and platforms that have to be installed and maintained.
You can use the IMPORT statement to import CSV and FBV files directly from local storage, FTP/FTPS/SFTP/HTTP/HTTPS servers, cloud services such as Amazon S3, Azure Blob Storage, and Google Cloud Storage, and from Hadoop.
In Exasol 2025.1 and later you can also use the native bulk loader to import Parquet files from Amazon S3 on AWS. To learn more, see Load data from Parquet files in Amazon S3 on AWS.
Exasol Cloud Storage Extension provides user defined functions (UDFs) that enable you to transfer formatted data in various formats between Exasol and cloud storage systems such as Amazon S3, Azure Blob Storage, Azure Data Lake, and Google Cloud Storage. To learn more, see also Cloud Storage Extension on GitHub.