Version v0.42 of Metabase is no longer supported. Check out the docs for the current stable version, Metabase v0.63.
In addition to specifying the host, port, database name and user credentials for the database connection, you have the option of securing that connection.
PostgreSQL databases support different levels of security with their connections, with different levels of overhead.
SSL Mode options include:
See the PostgreSQL docs for a table about the different SSL Modes, and select the option that works for you.
If you set the SSL Mode to either “verify-ca” or “verify-full”, you’ll need to specify a root certificate (PEM). You have the option of using a Local file path or an Uploaded file path. If you’re on Metabase Cloud, you’ll need to select Uploaded file path and upload your certificate.
You have the option of using a Local file path or an Uploaded file path. If you’re on Metabase Cloud, you’ll need to select Uploaded file path and upload your certificate.
Again, you have the option of using a Local file path or an Uploaded file path. If you’re on Metabase Cloud, you’ll need to select Uploaded file path and upload your certificate.
You’ll also need to input your SSL Client Key Password.
You can set up an SSH tunnel by supplying the tunnel host, port, tunnel username, and SSH authentication credentials, either using an SSH Key and passphrase, or a password.
For more, see SSH tunneling in Metabase.
Here you can add on to your connection string.
We execute the underlying query when you explore data using Summarize or Filter. This is on by default, but you can turn it off if performance is slow.
This is a lightweight process that checks for updates to this database’s schema. In most cases, you should be fine leaving this set to sync hourly.
This enables Metabase to scan for additional field values during syncs allowing smarter behavior, like improved auto-binning on your bar charts.
