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:
|Host||Materialize host name.|
|Database username||Materialize user.|
|Database password||App-specific password.|
For more details and troubleshooting, check the Metabase documentation.
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.