Optimize

When your data is in Tinybird, you can create intermediate data sources to preprocess data and make the endpoints faster. This can be done by using materialized views or copy pipes.

  • Copy pipes capture the result of a pipe at a specific point in time and write it to a target data source. They can run on a schedule or run on demand, making them ideal for event-sourced snapshots, data experimentation, and deduplication with snapshots.

  • Materialized views continuously re-evaluate a query as new events are inserted, maintaining an always up-to-date derived dataset. Unlike copy pipes which create point-in-time snapshots, materialized views provide real-time transformations of your data.

Each approach has its own strengths and use cases:

  • Use copy pipes when you need scheduled or on-demand snapshots of your data.
  • Use materialized views when you need continuous, real-time transformations.

Next steps

Updated