Metabase is an easy, open-source way to derive insights from data:
- Let anyone on your team ask questions without knowing SQL.
- Rich beautiful dashboards with auto refresh and fullscreen.
- SQL Mode for analysts and data pros.
- Create canonical segments and metrics for your team to use.
- Send data to Slack or email on a schedule with Pulses.
- View data in Slack anytime with MetaBot.
- Humanize data for your team by renaming, annotating and hiding fields.
You can deploy Metabase on Render in under 5 minutes. It is backed by Render’s fully-managed PostgreSQL and can be used to gain insights from any supported database including PostgreSQL, MySQL, Google Analytics, and MongoDB.
Create a new PostgreSQL database on Render and copy the internal DB URL to use below. This is the database where Metabase stores its own data. You will configure a connection to your application database in Metabase after installation.
Fork render-examples/metabase on GitHub.
Create a new Web Service on Render, and give Render permission to access your new repo.
Dockerfor the environment, and add the following environment variable under the Advanced section:
The internal connection string for the database you created above.
You can optionally encrypt your Metabase database connection details by adding the
MB_ENCRYPTION_SECRET_KEYenvironment variable as described in the Metabase operations guide.
That’s it! Metabase will be live on your Render URL as soon as the Docker build finishes.
Next, create a Metabase admin account and connect to your database using the Metabase Setup Guide. Soon everyone in your team will be uncovering data insights with your shiny Metabase instance on Render! 🙌
When you first install Metabase, Render will use the latest stable version in the Dockerfile:
To upgrade, simply trigger a manual deploy for Metabase in your Render dashboard.
You can also use a specific version of Metabase in your Dockerfile:
Commit and push your changes and Render will automatically upgrade and deploy your Metabase instance.