incro
SELECT product.name, SUM(sale.volume) AS total
FROM productJOIN sale ON sale.product_id = product.id
GROUP BY product.nameContinuous data modelling
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
The old (slow) way
Your data transformation is bottlenecked by the frequency of the batch job - typically 24 hours
The incremental way
incro monitors your datawarehouse for any changes in source tables and instantly transforms new data
Transform all of your data
Monitor data changes from the source or directly in your data warehouses
Updates at lightning speed
Stream changes from your upstream data sources to transformed tables without batching updates
Model dependencies
Build models on top of each other and let incro manage dependencies between models