SELECT product.name, SUM(sale.volume) AS total
FROM product
JOIN sale ON sale.product_id = product.id
GROUP BY product.name
incro is a data transformation engine that keeps your data warehouse up-to-date at lightning speed by transforming your SQL queries into an incremental model that performs computations on granular data changes
Modelling
Empower your data engineers to query, join and transform your data with SQL and let incro manage model dependencies and deliver incremental updates at lightning speed.
Your data transformation is bottlenecked by the frequency of the batch job - typically 24 hours
incro monitors your datawarehouse for any changes in source tables and instantly transforms new data
Monitor data changes from the source or directly in your data warehouses
Stream changes from your upstream data sources to transformed tables without batching updates
Build models on top of each other and let incro manage dependencies between models
Be the first to try our transformation engine