SQL commands IMPORT and EXPORT

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 statements IMPORT and EXPORT control 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.