Only when adding a new filter widget is a great option if you have a relatively large database, but you still want to enable dashboard and SQL/native query filters.This is the best option if you have a relatively small database, or if the distinct values in your tables change often. Regularly, on a schedule lets you choose to scan daily, weekly, or monthly, and also lets you choose what time of day, or which day of the month to scan.This process can slow down large databases, so if you have a particularly large database, you can turn on the option to choose when Metabase scans, and select one of three scan options in the Scheduling tab: If a field is classified wrong, you can always manually edit it from the Metadata tab in the Admin Panel.īy default, Metabase also performs a more intensive daily sampling of each field's values and caches the distinct values in order to make checkbox and select filters work in dashboards and SQL/native questions. Metabase also takes a sample of each table to look for URLs, JSON, encoded strings, etc. When Metabase first connects to your database, it takes a look at the metadata of the fields in your tables and automatically assigns them a field type. If you'd like to sync your database manually at any time, click on it from the Databases list in the admin panel and click on the Sync button on the right side of the screen: Syncing can't be turned off completely, otherwise Metabase wouldn't work. Syncing can be set to hourly, or daily at a specific time. It only maintains lists of the tables and columns. Metabase does not copy any data from your database. By default, Metabase performs this lightweight sync hourly to look for changes to the database such as new tables or fields. Metabase maintains its own information about the various tables and fields in each database that is added to aid in querying. Save your changes, and you'll see a new tab at the top of the form called "Scheduling." Click on that, and you'll see options to change when and how often Metabase syncs and scans. If you'd like to change these default settings, find and click on your database in the Databases section of the Admin Panel, and turn on the toggle at the bottom of the form that says "This is a large database, so let me choose when Metabase syncs and scans." (This is an option that used to be called "Enable in-depth analysis.") Database Sync and Analysisīy default, Metabase performs a lightweight hourly sync of your database, and a nightly deeper analysis of the fields in your tables to power some of Metabase's features, like filter widgets. You can always change this setting later if you prefer to connect without this layer of security, but we highly recommend keeping SSL turned on to keep your data secure. ![]() If it is possible to connect to your database with a SSL connection, Metabase will make that the default setting for your database. Metabase automatically tries to connect to databases with and without SSL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |