Create real-time dashboards with Metabase
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 a Metabase instance 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. |
If you require SSL/TLS encryption, you can configure the connection to use sslmode=require
. For more details, check out the Metabase documentation.
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 will not have a significant impact on database performance.