Learn tips & tricks from industry experts, and take your real-time analytics APIs to the next level.
We’ve carefully curated a set of short guides to help you get the most out of your Tinybird account. Take a look.
Tinybird can import huge amounts of CSV-formatted data using our UI, our API and our CLI
Learn how to use pipes to explore, combine and transform data from multiple data sources
In this guide you'll learn how you can create API endpoints in Tinybird in a matter of minutes to let others consume it
Data deletion operations are pretty common in transactional databases where your operational data lives. Often due to a data quality process in your operational database you will also need to update or delete your analytical data in Tinybird
Using a cronjob to replace data on Tinybird periodically and keep it synced with data on its origin
In this guide you'll learn how to use the quarantine table to detect and fix errors on any of your datasources, both in development and production environments
Learn how to create a pipe to monitor the quality of the data that gets periodically ingested to your datasources on Tinybird
In this guide you'll learn hoy to ingest unstructured data, like JSON to Tinybird. A typical scenario consists on having a document based database or using nested records on your data warehouse. In those cases, sometimes is hard to flatten the records so they conform to a typical CSV file structure in which each field represents a column.
In this guide you'll learn how to automatically ingest and synchronize all the CSV files in an AWS S3 or Google Cloud Storage bucket to a Tinybird Data Source.
In this guide, you'll learn how to use materialized columns to easily calculate or transform data on the fly, as it is ingested, and avoid spending hours running costly ETL processes on your end
Learn how to persist the result of the transformation in materialized views to have different organized, pre-filtered or pre-aggregated views of your source data for different use cases
Deduplicating data on query time, doing upserts on ClickHouse and using Materialized views to do last-point analytics.
In this guide, you'll learn how to define API endpoints Tinybird that accept dynamic parameters that will be passed to the underlying queries so that your frontend is performant, independently of the parameters that you pass to the endpoints
With Tinybird, you can avoid all the hassle behind securitizing and filtering your data in a multi-user application with no extra backend needed
In this guide you'll learn about the different possibilities for sharing your API endpoints documentation with other developers that tinybird brings to you
This guide will show you how to run automatic tests on your API endpoints as part of your continuous integration workflow
This guide will show you how to version your pipes using Tinybird's CLI