Integrate Metabase with Tiger Data
Connect Metabase to Tiger Cloud or self-hosted TimescaleDB to explore, query, and visualize your data.
Metabase is an open-source business intelligence tool that lets you ask questions of your data and share the answers in dashboards, without writing SQL.
This page shows you how to connect Metabase to Tiger Data as a data source, so that you can explore and visualize the data in your service or database.
In this integration guide, you:
- Add your service or database to Metabase as a data source.
- Verify that Metabase can query your data.
Prerequisites for this integration guide
To follow these steps, you'll need:
- A Tiger Cloud service, or a running instance of self-hosted TimescaleDB.
- Your connection details.
- A running Metabase instance, either Metabase Cloud or a self-managed installation.
Add your service or database to Metabase
Section titled “Add your service or database to Metabase”Metabase connects to your service or database with standard PostgreSQL connection details. To keep the connection read-only, you can optionally create a dedicated role with SELECT access before you start.
- Open the database settings in Metabase
In Metabase, open the menu under your profile icon and click
Admin. In the admin bar, clickDatabases, then clickAdd database. - Enter your connection details
From the
Database typelist, selectPostgreSQL. Either paste your connection string intoConnection string (optional), which pre-fills the fields below it, or enter your connection details by hand:Host: your service or databasehost.Port: yourport, usually5432.Database name: yourdbname.UsernameandPassword: youruserandpassword.
In
Display name, give the connection a name so you can recognize it later. - Configure connection options
Tiger Cloud requires an encrypted connection, so turn on
Use a secure connection (SSL). If your service or database is only reachable through a bastion host, turn onUse an SSH-tunneland add the tunnel details.In
Schemas, limit the sync to the schemas you query, for examplepublic. TimescaleDB keeps its internal schemas,_timescaledb_*andtimescaledb_*, in the same database, and Metabase syncs all of them by default.To change how often Metabase refreshes its view of your schema, click
Show advanced options, turn onChoose when syncs and scans happen, then setDatabase syncingandScanning for Filter Values. - Save the connection
Click
Save. Metabase connects to your service or database and starts an initial sync of your tables and columns.When the sync finishes, your tables appear in the Metabase data browser.
Verify the integration
Section titled “Verify the integration”To confirm Metabase is working with your service or database:
- Ask a question
In Metabase, click
+ New>Question, select your connection, then a schema, then a table to query. - Visualize the results
Click
Visualizeto run the query.You see rows from your service or database rendered in the results area, confirming that Metabase can read your data.
You have successfully integrated Metabase with Tiger Data.
Troubleshooting
Section titled “Troubleshooting”- Connection times out or is refused: confirm the host, port, and that your network allows connections from Metabase. For Tiger Cloud, make sure SSL is enabled.
- Tables don't appear after connecting: in
Admin>Databases, open the connection and clickSync database schema.
For other connectivity and authentication issues, see Troubleshoot Tiger Cloud integrations.