Core concepts

The main concepts you'll need to understand on your journey to becoming a Tinybird pro!

Workspaces

Workspaces help you organize and collaborate on your Tinybird projects. You can have more than one.

A Workspace contains the project resources (Data Sources, Pipes), data, and state. You can share resources from one Workspace to another. You can invite other users to your Workspace(s), and choose their role to control what they are able do. People often use Workspaces to give a team, or a project, its own space to work in.

User roles:

  • Admins can do everything in the Workspace.
  • Guests can do most things, but they can't delete Workspaces, invite/remove users, or share Data Sources across Workspaces.
  • Viewers can't edit anything in the main Workspace Branch, but they can use Playgrounds to query the data and create/edit Branches.

Read more about Workspaces.

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 your data lives inside a Data Source, and you write SQL queries against Data Sources. You can bulk upload or stream data into a Data Source, and they support several different incoming data formats (CSV, JSON, Parquet).

Read more about Data Sources.

Pipes

Pipes are how you write SQL logic in Tinybird.

Pipes are a collection of one or more SQL queries chained together and compiled into a single query. This lets you break larger queries down into multiple smaller queries that are much easier to read. Pipes can be published as API Endpoints, Copy Pipes, or Materialized Views.

Read more about Pipes.

Nodes

A Node in Tinybird is simply a single SQL SELECT statement that selects FROM a Data Source or another Node or API Endpoint. 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.

Read more about APIs.

Charts

Charts are a great way to visualize your data. You can create and publish Charts in Tinybird from your published API Endpoints.

Read more about Charts.

Tokens

Tinybird uses Tokens to authorize requests. Tokens can be static for back-end integrations, or custom JWTs for using in front-end applications.

Read more about Tokens.

Branches

Branches in Tinybird are inspired by branches in Git. They allow you to create a copy of your Workspace, where you can make changes, run tests, and develop new features, then merge those changes back into the original Workspace.

Read more about Branches.

CLI

The Tinybird CLI (command line interface) allows you to interact with Tinybird via the command line instead of the UI (user interface). It can be installed on your local machine, and embedded into your CI/CD pipelines.

Read more about the Tinybird CLI.

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, and it serves as Tinybird's real-time analytics database and SQL engine. The SQL that you write inside Tinybird uses the ClickHouse SQL dialect.

Read more about ClickHouse.

Next steps