You will likely want to select the option Use DNS SRV, which newer Atlas clusters use by default. The resulting connection string has the relevant information to provide to Metabase’s Add a Database form for MongoDB. Select the cluster you want to connect to, and click Connect. To make sure you are using the correct connection configuration: Learn more about configuring SSL with MongoDB. Java =cacerts.jks =changeit -jar metabase.jar ![]() You can enter a self-signed certificate via the Metabase UI (though not when using a connection string), or you can use the command line to add a self-signed certificate. Periodically refingerprint tables: This setting - disabled by default - enables Metabase to scan for additional field values during syncs allowing smarter behavior, like improved auto-binning on your bar charts.If you have a large database, we recommend turning this on and reviewing when and how often the field value scans happen. Choose when syncs and scans happen: By default, Metabase does a lightweight hourly sync and an intensive daily scan of field values.This setting doesn’t affect drill-throughs or SQL queries. You can turn this off if querying this database is slow. Rerun queries for simple exploration: When this is on, Metabase will automatically run queries when users do simple explorations with the Summarize and Filter buttons when viewing a table or chart.Enabling this is usually slower than a direct connection. This option also provides an extra layer of security when a VPN is not available. Use an SSH tunnel: Some database installations can only be accessed by connecting through an SSH bastion host.Settings common to both connection options If you need to use a certificate, connect via the default method and enable Use a secure connection(SSL). ![]() Metabase currently does NOT support the following connection string parameters: The Metabase user interface will update with a field to paste your connection string. If you’d prefer to connect to MongoDB using a connection string, click on Paste a connection string. If you don’t know what this means, leave this disabled. If connecting to an Atlas cluster, you might need to enable this option.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |