Magic ETL on BigQuery (Beta) – Pushdown Processing with Subsets and Native SQL | Jan 2026 Update

Build more powerful and efficient BigQuery workflows with Magic ETL Pushdown for Google BigQuery, now available in beta. This update lets you design transformations visually in Magic ETL while executing them directly in your BigQuery environment—keeping data in place, maintaining security, and optimizing compute costs.

In this episode of The Domo Drop, you’ll learn how to:
• Use Magic ETL Pushdown on BigQuery to process data where it lives
• Control BigQuery outputs with Subset Processing options like Append, Upsert, and Partition
• Optimize large datasets by updating only the data you need
• Apply Native BigQuery SQL syntax directly in Magic ETL’s SQL tile
• Reuse existing SQL scripts without refactoring
• Improve performance and reduce costs with smarter data workflows

What’s new in Magic ETL on BigQuery (Beta):

Subset Processing Support
Choose how data is written to BigQuery using Append, Upsert, or Partition methods—ideal for daily updates, historical snapshots, and large datasets.

Native SQL Syntax
Use BigQuery-native SQL directly in Magic ETL’s SQL tile with the new pass-through SQL option, giving advanced users greater flexibility and control.

📍 Where to find it: Access BigQuery Pushdown options in Magic ETL output tiles and the SQL tile on the Magic ETL authoring canvas.

📌 Subscribe to The Domo Drop for more product updates, data integration features, and how-to demos https://bit.ly/3IrYg1W

Learn more about Domo: https://bit.ly/FY26yt