Loading Data from File

Exasol's loading engine is integrated with the cluster instead of using an external bulk loading tool. This enhances the performance by leveraging the parallel cluster, and simplifies the ETL process by using SQL statements instead of installing and maintaining client tools and different platforms.

The SQL statement IMPORT controls the loading processes in Exasol.

You can use connection objects (see CREATE CONNECTION for more information) to encapsulate the credentials for external systems.

The users need the system privileges IMPORT or EXPORT to execute the corresponding commands. If all users need IMPORT and EXPORT privileges, you can grant the privileges to the PUBLIC role through the GRANT statement.

CSV/FBV File Types

Using the IMPORT command, you can load CSV/FBV files directly from:

  • Your local file system
  • FTP(s), SFTP, or HTTP(s) servers
  • Amazon S3
  • Hadoop

For detailed information on how to load data from CSV/FBV files, see Loading CSV/FBV Files.

Other File Types

Additionally, you can also load data from cloud storage systems in any of the following file formats: 

  • Parquet
  • ORC
  • Avro
  • Delta

For detailed information on how to load data from the cloud storage systems, see Loading from Other Files.