![]() By default, Metabase will use the value you supply on the cache settings page, but if this database has other factors that influence the freshness of data, it could make sense to set a custom duration. Default result cache durationĭatabase-specific caching is only available on Pro and Enterprise plans (both self-hosted and on Metabase Cloud). If you leave this option OFF, Metabase will only fingerprint your columns once during setup. Turn this option ON to scan a sample of values every time Metabase runs a sync.Ī fingerprinting query examines the first 10,000 rows from each column and uses that data to guesstimate how many unique values each column has, what the minimum and maximum values are for numeric and timestamp columns, and so on. Periodic refingerprinting will increase the load on your database. Use the Re-scan field values now button to run a manual scan and bring your filter values up to date. Never, I’ll do this manually if I need to is an option for databases that are either prohibitively large, or which never really have new values added.Turning this option ON means that Metabase will only scan and cache the values of the field(s) that are used when a new filter is added to a dashboard or SQL question. Only when adding a new filter widget is a great option if you want scan queries to run on demand.This is the best option for a small database, or tables with distinct values that get updated often. The time is set in the timezone of the server where your Metabase app is running. Regularly, on a schedule allows you to run scan queries at a frequency that matches the rate of change to your database.If you’ve selected Choose when syncs and scans happen > ON, you’ll see the following options under Scanning for filter values: This can be a somewhat resource-intensive process, particularly if you have a very large database. Metabase can scan the values present in each field in this database to enable checkbox filters in dashboards and questions. ![]() The time to run the sync, in the timezone of the server where your Metabase app is running.The frequency of the sync: hourly (default) or daily.If you’ve selected Choose when syncs and scans happen > ON, you’ll be able to set: For more information, see Syncing and scanning databases. Turn this option ON to manage the queries that Metabase uses to stay up to date with your database. If your database is slow, you may want to disable re-running to avoid loading data on each click. Turn this option OFF if people want to click Run (the play button) before applying any Summarize or filter selections.īy default, Metabase will execute a query as soon as you choose an grouping option from the Summarize menu or a filter condition from the drill-through menu. You can append options to the connection string that Metabase uses to connect to your database. Additional JDBC connection string options If you turn on JSON unfolding, you can also toggle the unfolding for individual columns in table metadata. JSON unfolding is on by default, but you can turn off JSON unfolding if performance is slow. Unfold JSON Columnsįor MySQL databases, Metabase can unfold JSON columns into component fields to yield a table where each JSON key becomes a column. You can paste your server’s SSL certification chain. The password for the username that you use to connect to the database. You can set up multiple connections to the same database using different user accounts to connect to the same database, each with different sets of privileges. The database username for the account that you want to use to connect to your database. Your database’s IP address, or its domain name (e.g., ). The display name for the database in the Metabase interface. To add a database connection, click on the gear icon in the top right, and navigate to Admin settings > Databases > Add a database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |