Quick start

With Tinybird, you can ingest data from anywhere, query and transform it using SQL, and publish it as high-concurrency, low-latency REST API endpoints.

Read on to learn how to create a Workspace, ingest data, create a query, publish an API, and confirm your setup works properly using the Tinybird user interface.

Step 1: Create your Tinybird account

Create a Tinybird account. It's free and no credit card is required. See Tinybird pricing plans for more information.

Sign up for Tinybird

Step 2: Select your cloud provider and region

When logging in to Tinybird, select the cloud provider and region you want to work in.

Select your region

Step 3: Create your Workspace

A Workspace is an area that contains a set of Tinybird resources, including Data Sources, Pipes, Nodes, API Endpoints, and Tokens.

Create a Workspace named customer_rewards. The name must be unique.

Create a Workspace

Step 4: Download and ingest sample data

Download the following sample data from a fictitious online coffee shop:

Download data file

Select File Upload and follow the instructions to load the file.

Upload a file with data

Select Create Data Source to automatically create the orders Data Source.

Create a Data Source

Step 5: Query data using a Pipe

You can create Pipes to query your data using SQL.

To create a Pipe, select Pipes and then Create Pipe.

Name your Pipe rewards and add the following SQL:

select count() from orders

Select the Node name and change it to rewards_count.

Create a Pipe

Select Run to preview the result of your Pipe.

Step 6: Publish your query as an API

You can turn any Pipe into a high-concurrency, low-latency API Endpoint.

Select Create API Endpoint and then select the rewards_count Node in the menu.

Create an API Endpoint

Step 7: Call your API

You can test your API endpoint using a curl command. Go to the Output section of the API page and select the cURL tab.

Copy the curl command into a Terminal window and run it.

Test your API Endpoint

Congratulations! You have created your first API Endpoint in Tinybird.

Next steps

Was this page helpful?
Updated