Cloud Amplifier Pushdown Magic ETL

Run Magic ETL on your cloud (Append Only) - Snowflake, Databricks, Big Query, and Oracle

Transform how you manage data with Magic ETL on Snowflake, the latest feature in our Cloud Amplifier update. Data engineers will no longer face the constant strain of balancing user demands and governance. Magic ETL empowers teams by enabling business users to perform self-service data transformations directly within Snowflake, all without writing SQL or moving data. By executing transformations on your own engine, this feature ensures that data stays secure, structured, and fully governed. Access by navigating to the Magic ETL UI and selecting a Snowflake integration from the compute drop-down.

Snowflake: Native CDW SQL Syntax

The Snowflake Pass-Through SQL Tile is now available. Designed with flexibility in mind, this new tool allows SQL experts to seamlessly paste their existing scripts into Domo and execute them natively, while low-code users can continue leveraging Magic ETL's intuitive drag-and-drop 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. Access the Snowflake Pass Through SQL Tile in Magic ETL.

Snowflake: Append, Upsert and Partition Output Tables and Subset Processing

Designed to tackle the high costs of processing large data sets with Magic ETL, Domo Managed Pushdown Subset Processing expands output tile options beyond Replace to include Partition, Append, and Upsert. 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.