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
