![dbschema how to make subcollection dbschema how to make subcollection](https://i.ytimg.com/vi/Dxp7laJd0eI/maxresdefault.jpg)
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:
![dbschema how to make subcollection dbschema how to make subcollection](https://i.stack.imgur.com/Z8o0q.png)
You can manually edit table and column metadata in Metabase at any time from the Data Model 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 columns in your tables and automatically assigns them a 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 database schema now 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 to aid in querying. If you enable this and save your changes, 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. (Note: this setting used to be called “Enable in-depth analysis.”) Once on, you can review when and how often the field value scans happen. If you have a large database, we recommend turning on the option “This is a large database, let me choose when Metabase syncs and scans”. Choose when Metabase syncs and scansīy default, Metabase does a lightweight hourly sync and an intensive daily scan of field values. Use an SSH tunnel for database connections
![dbschema how to make subcollection dbschema how to make subcollection](https://i.stack.imgur.com/y7ntz.png)
If you prefer to connect without this layer of security, you can always change this setting later, but we highly recommend keeping SSL turned on to keep your data secure. If it’s possible to connect to your database with an SSL connection, Metabase will make that the default setting for your database. Metabase automatically tries to connect to databases with SSL first, then without if that doesn’t work.
![dbschema how to make subcollection dbschema how to make subcollection](https://dbschema.com/documentation/img/layouts/virtual-fk.png)
Note that our hosted offering, Metabase Cloud, doesn’t support community drivers, meaning that (for now) you can only use Metabase Cloud with the officially supported databases listed above.
#DBSCHEMA HOW TO MAKE SUBCOLLECTION DRIVERS#
MySQL (version 5.7 or higher, as well as MariaDB version 10.2 or higher)ĭon’t see the database you need here? Take a look at our Community Drivers page to see if someone’s built one, or learn how to get started building your own.Google Analytics (version 3 if you’re interested in support for version 4, let us know by adding your +1 to this issue (#12905)).To connect a database to Metabase, click Add database and follow the connection instructions for your database.Īlthough connection details differ database to database, in general you’ll need to get connection info from your database admin, usually some combination of hostname (sometimes called endpoint), port, database username and password, and the name of the database. You’ll see a list of your connected databases (if any). Once in the Admin section, select the Databases tab from the navigation bar at the top of the screen. In the main navigation bar, click on the gears icon in the top right, and select Admin. Errors when connecting to your database.Connecting to databases hosted by a cloud provider.01 Managing Databases Adding and managing databases