Magic ETL

Enable window functions in SQL tile

Performing advanced analytical queries in Magic ETL DataFlows just got a major upgrade.

With the new window functions capability in the SQL tile, you can now effortlessly execute calculations like running totals, rankings, moving averages, and cumulative counts directly within your ETL workflows.  

Here's what you can expect:

• Simplified analytics: Forget complex setups. Write window functions straight into the SQL tile for quick calculations.  

• Time-saving efficiency: Reduce the number of transformation steps, accelerating your data pipeline development and maintenance.  

• Sharper insights: Unlock richer analytical capabilities, ensuring smarter and more dynamic data exploration.

• Optimized workflows: Combine Magic ETL’s intuitive interface with the flexibility of SQL for a seamless, powerful data transformation experience.

This feature is currently available in beta and can be accessed in the SQL tile of a Magic ETL DataFlow. Try it out today and elevate your data analysis right within the platform.

Learn how to harness the power of the SQL tile in the Knowledge Base.

AI SQL Assistant

Transform your data workflow with the new AI SQL Assistant. Now in beta, this feature improves your interaction with Magic ETL by enabling natural-language queries and formula generation.  

Writing precise SQL and formulas can be challenging, especially for non-technical users, often leading to delays, errors, and dependency on technical experts.  

How it helps:

• Accessible for all: Create complex queries or formulas by simply describing your needs in everyday language.  

• Save time: Skip the hassle of writing and debugging syntax with automated query and formula generation.  

• Boost accuracy: Get consistent, reliable results with reduced errors in construction.  

• Empower your team: Enable team members to self-serve data needs, lowering reliance on technical staff.  

• Encourage agility: Quickly refine and experiment with queries by describing changes naturally.  

The capability is available in these Magic ETL tiles. Follow the links to learn how to use the AI assistants with each tile.

• SQL tile  

• Add Formula tile

• Filter Rows tile

• Group By tile

This innovative feature empowers users to focus on insights, not syntax, fueling a faster, smoother decision-making process.