You can now create Materialized Views in the Tinybird UI

Tinybird has introduced the ability to create Materialized Views (MVs) directly within its UI, which previously required using the CLI and specific ClickHouse expertise. This enhancement aims to streamline the development process for users who prefer a graphical interface by automatically suggesting optimal parameters for MVs, thus enabling faster and more efficient creation of performant endpoints. Materialized Views are key in reducing query response times and data scan sizes, making data delivery faster and more cost-effective. The process involves using Pipes to define pre-aggregated or filtered results that can be easily converted into a Materialized View, with the UI offering features like automatic parameter recommendations and real-time incremental materialization. This update is designed to simplify the creation of MVs, offering an intuitive process that ensures reliable and real-time data sources for enhanced application performance.