IMPORT and EXPORT statements are often part of a complex logic to update the data. For example, deleting old data or merging new and changed data, or even more complex processes such as cleaning the data. To create flexible ETL processes, it is often necessary to monitor the exceptions and/or run different execution branches depending on certain conditions.
To handle complex ETL processes, we recommend that you use scripting. Exasol’s scripting capabilities allow you to execute multiple SQL statements in a single script, to use exceptions handling, and to process smaller accounts of data directly in the programming language.
For more information about the scripting capabilities of Exasol, see Scripting.
