Exasol Transformation

Exasol is a high-performance, in-memory MPP (Massively Parallel Processing) database specifically designed for analytics. From business-critical data applications to advanced analytics, Exasol helps you analyze large volumes of data.

Example

To create a simple Exasol transformation, follow these steps:

  • Create a table in Storage by uploading this sample CSV file.
  • Create an input mapping from that table, setting its destination to source (as expected by the Snowflake script).
  • Create an output mapping, setting its destination to a new table in your Storage.
  • Copy & paste the below script into the transformation code.
  • Save and run the transformation.
SELECT "first", "second" INTO TABLE "destinationTable" FROM "sourceTable";

Screenshot - Sample Transformation

You can organize the script into blocks.