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.
Next video:
