Connect Metabase

Metabase is an open-source business intelligence (BI) tool that allows users to explore data, create dashboards, and visualize data

1. You need to first generate a database user for your site. Follow this documentation to create a read-only user.

   
   

   Typically, it takes a few seconds to configure the database user. Once it's complete, click on View Credential

   
   

   
   

2. Open your Metabase dashboard and click on Add database.

3. Choose MySQL as Database Type and fill all the database user related information.
   
   

   Note : Ensure that Use a secure Connection (SSL) is checked.

   
   

   For Server SSL certificate Chain, check the Step 1 and download the certificate first. Next, open your operating system's default text editor and copy- paste to metabase.

   
   

4. Once all the details filled, click on Save.

5. If everything works fine, you will see your database in the list.

   
   

6. Wait a few minutes for the table schema to sync, then you can view the metadata.

   
   

7. Once this step is complete, you can follow the official documentation to create the dashboard and reports.