Main concepts¶
The main concepts you’ll want to understand on your journey to becoming a Tinybird pro!
Workspaces¶
Workspaces help you to organize and collaborate on your Tinybird data projects.
All of your Tinybird resources live in a Workspace; you can have multiple Workspaces to organize your resources as you see fit.
Other users can be invited to your Workspaces easily and you can choose their role to control what they are able do. You can invite as many users to your Workspace as you want on a per-Workspace basis.
It is also possible to share resources from one Workspace to another.
People often use Workspaces to give a team, or a project, its own space to work in.
Data Sources¶
Data Sources are how you ingest & store data in Tinybird.
Think of a Data Source like a database table (there’s a little more detail behind it, but close enough for now).
All of your data lives inside a Data Source, and you will write your SQL queries against them.
You can bulk upload or stream data into a Data Source, and they support several different incoming data formats (CSV, JSON, Parquet).
Pipes¶
Pipes are where your Nodes live; within a Pipe, you can have as many Nodes as you need.
We can ‘chain’ the Nodes in our Pipe together by having a Node select the results of a previous Node. This lets you break larger queries down into multiple, smaller queries that are much easier to read.
Nodes¶
A Node in Tinybird is simply a single SQL SELECT
statement that selects FROM
a Data Source or another Node.
Nodes live within Pipes.
API Endpoints¶
The magic of Tinybird is the ability to turn any Pipe into an API Endpoint.
Build your SQL logic inside a Pipe, and then publish the result of your query as an HTTP API Endpoint.
All you need to do is write the SQL, everything else is taken care of for you.
Auth Tokens¶
When you publish an API Endpoint from a Pipe, it is automatically secured using Auth Tokens.
You can manage your Auth Tokens inside Tinybird and configure granular access permissions as needed.
CLI¶
Tinybird has a CLI that you can use instead of the UI. Pick whichever works for you!
ClickHouse¶
Tinybird is built using open source software. We love open source and have dedicated teams that contribute to all of the projects we use.
ClickHouse is an open source OLAP database & is responsible for Tinybird’s analytical powers.
The SQL that you write inside Tinybird will be in ClickHouse SQL dialect.