kafka_events
21.3B rows / 4.1Gb
top_products
SELECT product_id, count() AS sales FROM events
WHERE event = 'buy'
GROUP BY product_id
ORDER BY sales DESC
top_products_endpoint
SELECT title, sales, sales*price as revenues
FROM o top_products
JOIN o products using product_id
ORDER BY {{column(order_by, 'sales')}} DESC
LIMIT {{Int8(limit, 10, required=True)}}
By splitting your query in different nodes you simplify development and maintenance.
Use JOINs to enrich your data. Enable parameterised API endpoints using a simple templating language.
In-Product Analytics
Capturing huge amounts of data is fine, but is what you do with it that counts. Any use case you think of you can easily implement and scale with Tinybird SQL Pipes.
Realtime Personalization
Whether you want to trigger downstream automations or keep an eye on problems or opportunities via alerts, Tinybird grants you the scale and flexibility to tackle your use case via low-latency APIs over your streaming data.
Usage Based Pricing
Whether you want to trigger downstream automations or keep an eye on problems or opportunities via alerts, Tinybird grants you the scale and flexibility to tackle your use case via low-latency APIs over your streaming data.
Operational Intelligence
Implement rolling windows, roll-ups or enrich data incrementally as you ingest data streams in Tinybird.
Anomaly Detection & Alerts
Once your data is in Tinybird, any new use case is just one SQL query away.
Machine Learning & AI
Once your data is in Tinybird, any new use case is just one SQL query away.
Tinybird Connectors enable you to take advantage of a realtime analytics platform to build fast applications, faster. Speed wins.