metabase.md 2.0 KB
title: "Metabase" description: "How to create real-time dashboards with Metabase" aliases:
- /third-party/metabase/
- /integrations/metabase/
- /serve-results/metabase/ menu: main: parent: "bi-tools" name: "Metabase" weight: 5 ---
You can use Metabase to create real-time dashboards based on the data maintained in Materialize.
Database connection details
To set up a connection from Metabase to Materialize, use the native PostgreSQL database driver with the following parameters:
| Field | Value |
|---|---|
| Database type | PostgreSQL |
| Host | Materialize host name. |
| Port | 6875 |
| Database name | materialize |
| Database username | Materialize user. |
| Database password | App-specific password. |
| SSL mode | Require |
For more details and troubleshooting, check the Metabase documentation.
Configure a custom cluster
{{% alter-cluster/configure-cluster %}}
Refresh rate
By default, the lowest refresh rate
for Metabase dashboards is 1 minute. You can manually set this to a lower
interval by adding #refresh=1 (as an example, for a 1 second interval) to
the end of the URL, and opening the modified URL in a new tab.
Because Metabase queries are simply reading data out of self-updating views in Materialize, setting your dashboards to auto-refresh at lower rates should not have a significant impact on database performance. To minimize this impact, we recommend carefully choosing an indexing strategy for any objects serving results to Metabase.
[//]: # "TODO(morsapaes) Once we revamp quickstarts, add Related pages section pointing to a quickstart that uses Metabase"