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:
|Host||Materialize host name.|
|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.
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.