If you know the IP address(es) or CIDR block of clients, use that instead. Have you checked your cluster host whitelist? When testing a connection but seeing failure, have you tried setting the IP whitelist to 0.0.0.0/0? Whitelisting this address allows connections from any IP addresses.Connect using DNS SRV, which is the recommended method for newer Atlas clusters.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. Use DNS SRV when connecting Using this option requires that provided host is a FQDN.you cannot include a certificate when connecting with a connection string). This option is available for this method of connection only (i.e. Enable SSL and paste the contents of the server’s SSL certificate chain in the input text box. You’ll also have the option to Use a secure connection (SSL). Additional connection string options (optional).The default way to connect to MongoDB is to fill out your connection details in the fields Metabase provides: Using the Metabase fields to input your connection details.There are two ways to connect to MongoDB: Select MongoDB from the dropdown, and enter your desired Display name for this database. Go to Admin -> Databases, and click the Add database button. For more info, check out our troubleshooting guide. And while the sampling does a pretty good job keeping Metabase up to date, it can also mean that new fields can sometimes fall through the cracks, leading to visualization issues, or even fields failing to appear in your results. The reason Metabase only scans a sample of the documents is because scanning every document in every collection on every sync would be put too much strain on your database. This sampling helps Metabase do things like differentiate datetime fields from string fields, and provide people with pre-populated filters. To get a sense of the schema, Metabase will scan the first ten thousand documents of each collection in your MongoDB. How Metabase syncs data in MongoDBīecause MongoDB contains unstructured data, Metabase takes a different approach to syncing your database’s metadata. Metabase supports MongoDB version 4.2 or higher.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |