Scripting Complex ETL Jobs
IMPORT and EXPORT statements are often part of a complex logic to update the data. For example, deleting the old data or merging the 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 or run different execution branches depending on certain conditions.
Therefore, we recommend to use scripting for more complex ETL processes. With Exasol's scripting capabilities, you can execute multiple SQL statements in a single script, use exceptions handling, and even process smaller accounts of data directly in the programming language. For more information on scripting capabilities of Exasol, see Scripting.