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.
First time using Tinybird? Here you'll learn all the basics you need to start ingesting, transforming and exposing data with Tinybird Analytics
Tinybird can ingest data from lots of different sources. Learn about them all with these guides.
Here you will find advanced ways in which you can use Tinybird to transform your data.
Tinybird also lets you create secure and robust API endpoints from views of your data in a matter of seconds. Learn how to do it here
Tinybird enables using best software engineering practices when working with big amounts of data, like testing and version control. Here you'll learn how to integrate them into your data projects too.
We are used to saying ClickHouse is like a Formula 1, fast as hell but hard to drive. Sometimes a partition key, an index, or a simple change in a SQL query leads to 10x faster queries. Learn how to exploit all the power behind ClickHouse here
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
Learn how to setup a real data project using the CLI
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.
Formatting your CSVs properly can leat to 5-10X ingestion speed improvements on Tinybird. Learn how to do it here
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
Working with dates is pretty easy with Tinybird. ClickHouse provides several functions for managing Date{Time} types. Unfortunately, there isn't a straightforward way to fill the empty gaps between two range of dates. In this guide, you'll learn how to fill with NULLs the gaps where you don't have data between a range of two dates
Deduplicating data on query time, doing upserts on ClickHouse and using Materialized views to do last-point analytics.
When you have hundreds of millions or billions of rows, joins get slow even on ClickHouse. Here we'll show you how to make joins on large amounts of data 100X faster using the JOIN Table Engine.
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
summary
