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
- Cloud Storage, like Amazon S3, Azure Blob Storage, and Google Cloud Storage
For detailed information on how to load data from CSV/FBV files, see Load Data from CSV/FBV Files.
Other File Types
Additionally, you can also load data from cloud storage systems in any of the following file formats:
For detailed information on how to load data from the cloud storage systems, see Load Data from Other Files.