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.

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.

Back to top ↑