![]() 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. (Note: this setting used to be called “Enable in-depth analysis.”) Database syncing Once on, you can review when and how often the field value scans happen. ![]() If you have a large database, we recommend enabling the toggle Choose when syncs and scans happen found when you select Show advanced options. 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 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. Automatically run queries when doing simple filtering and summarizing.Use an SSH-tunnel for database connections.AWS’s Relational Database Service (RDS)Ĭonnection options differ depending on which database you’re connecting to.MySQL (version 5.7 or higher, as well as MariaDB version 10.2 or higher)Ĭonnecting to databases hosted by a cloud providerįor provider-specific connection details, like connecting to a PostgreSQL data warehouse on RDS:.Customers on paid plans will get official support. The following databases have official drivers maintained by the Metabase team. Metabase supports many different databases and data sources, with different levels of support. 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. Connecting to databases hosted by a cloud providerĪt the bottom of the navigation sidebar, click on the gears icon and select Admin settings.Metabase Cloud doesn’t support serialization./ Adding and managing databases Adding and managing databases You won’t be able to access the application database if you want insights into how people are using your Metabase, check out the Auditing feature. Metabase Cloud is currently only available hosted from the United States (via AWS US-East-1). Metabase Cloud does not support customization of the “from address” for emailed reports, alerts, and other system notifications. Only some databases support custom certificates, which you can input/upload via the database connection setup user interface in your Metabase. Metabase Cloud doesn’t support community database drivers, or file-based databases (SQLite and H2), because there’s currently no file storage available. Metabase’s officially supported databases (with the exception of SQLite and H2. ![]() Metabase Cloud only supports official and partner databases These limitations apply to all Metabase Cloud plans. There are some limitations that could impact your migration to Metabase Cloud.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |