Connect Mitzu to Tinybird

Mitzu can connect to Tinybird using the ClickHouse® Data Source, taking advantage of Tinybird's ClickHouse® HTTP protocol compatibility.

The ClickHouse® connection to Tinybird is read-only. You can use it to query and analyze data from your Tinybird data sources, but you cannot modify data through this connection.

Prerequisites

  • A Mitzu account
  • A Tinybird workspace with data sources
  • A Tinybird Auth Token with scopes WORKSPACE:READ_ALL and optionally ORG_DATASOURCES:READ. See how to create it.

Create a new connection

  1. Select Connect Mitzu with your data warehouse.
  2. In the databases list select ClickHouse®.
  3. Fill in the ClickHouse database credentials.

Connection settings

Host: https://clickhouse.tinybird.co:443/<WORKSPACE_NAME>
Username / Key: <WORKSPACE_NAME>  # Your workspace name
Password / Token: <TOKEN>  # Your Tinybird auth token

Then create a New Dataset selecting the previously created connection.

See the list of ClickHouse hosts to find the correct one for your region.

Learn more

Updated
Looking for Classic docs?