Magic ETL on Snowflake

Native Snowflake SQL syntax

The SQL tile in Magic ETL now supports native Snowflake syntax. Now you can use Snowflake-specific functions or copy and paste existing scripts into Domo and execute them natively.

Low-code users can continue to leverage Magic ETL's intuitive drag-and-drop functions, while Snowflake experts can write SQL—all in the same interface.

For business users, advanced IT teams, and longtime Snowflake users with tons of pre-built SQL queries, this feature ensures a smooth and unified experience for transforming data.

Join the beta to try native Snowflake syntax in the SQL tile in Magic ETL.

Subset processing

Subset processing support gives users more flexibility on Snowflake outputs. This update expands output tile options in Magic ETL beyond Replace to include Partition, Append, and Upsert.

Instead of replacing everything, you can pick what works best:

Updating a sales table daily? Append just one day’s data.

Managing historical snapshots? Use Upsert or Partitioning for smarter, more efficient updates. 

This added flexibility empowers users to select the output method that best fits their specific use cases, optimizing both efficiency and cost. This feature can be found in Magic ETL output tiles when using a Snowflake compute integration.

Learn about the new update methods.