This section describes how to load data into Exasol from files on various systems.
Exasol’s loading engine is integrated with the cluster, eliminating the need for an external bulk loading tool. This simplifies the ETL process by using the SQL statements IMPORT and EXPORT instead of client tools and platforms that have to be installed and maintained. It also enhances performance by leveraging the parallel cluster.
The user that executes the IMPORT or EXPORT command must have the corresponding system privilege IMPORT or EXPORT. If all database users need to execute these commands, you can grant the privileges to the PUBLIC role using the GRANT statement.
We recommend that you use connection objects to encapsulate the credentials for external systems. For more information, see CREATE CONNECTION
This section covers the following topics:
Load data from CSV/FBV files
You can use the IMPORT SQL command to load CSV/FBV files directly from the following sources:
- Your local file system
- FTP/FTPS/SFTP/HTTP/HTTPS servers
- Cloud storage services such as Amazon S3, Azure Blob Storage, and Google Cloud Storage
- Hadoop
Load data from other file types
You can also load data from files on cloud storage systems in any of the following file formats:
- Parquet
- Delta Lake
- ORC
- Avro
