This document is for customers who need to set up the connection between Metabase and Acho for the first time.
Metabase is a popular open-source visualization tool, but it only supports importing data from databases, such as MySQL, BigQeury, etc. Acho can help you import data from spreadsheets or apps and host a database on our server, so you can export any type of data to Metabase. The process includes three steps:
  1. 1.
    ​Generate database credentials (Each Acho's account generate only one set of credentials)
  2. 2.
    ​Set up a connection in Metabase: use the credentials generated from Step 1 to configure the connection in Metabase. The configuration only needs to be set up for the first time.
  3. 3.
    ​Sync the table from Acho to Metabase: Whenever you export a new table to Metabase or change the table that was exported to Metabase before, you have to sync the connection to retrieve the new tables.

Step 1: Generate database credentials

1. Click the export button on the top right of the table.
2. Select Metabase and click Generate Credentials.
3. Acho generates Dataset ID and a JSON key file automatically.
Notice that:
  • Each Acho's account has a unique set of credentials for Metabase.
  • Every time you export data to Metabase, you can find the credentials. However, you only need these credentials for the first time to build the connection in Metabase.

Step 2: Set up a connection in Metabase

  1. 1.
    Open your Metabase and click "Admin" on the top-right gear icon
2. Navigate to Settings > Setup and click Add a database.
3. Follow the instructions below to complete the configuration.
  • Database type: Choose BigQuery.
  • Name: The name of the database in your Metabase.
  • Dataset ID: The Dataset ID you receive from Step 1.
  • Service account JSON file: The JSON file you receive from Step 1.
  • (Optional) If you need to customize when Metabase should sync with Acho, please turn on the button, This is a large database, so let me choose when Metabase syncs and scans.
4. Click Save and the connected database will show up on the homepage.

Step 3. Sync the table from Acho to Metabase

  1. 1.
    Export a table from Acho
2. Click Admin on the top-right gear icon
3. Navigate to Databases and click the Database Name you created during the setup of the database.
4. Click Sync database schema now to retrieve the tables from Acho
5. Click the gear icon on the top right, and click Exit admin.
6. Click the Database Name again
7. The exported Acho table will show up in your Metabase now.

How to delete the connected database or an Acho table in Metabase

Deleting an Acho table in Metabase

1. Delete the table on Acho
2. Click "Sync database schema now" again
3. The table in the Metabase database will automatically be deleted

Deleting the whole database in Metabase

1. Go to Setting (top-right gear) > Admin > Database > Your Acho Database Name
2. Click "Remove this database"
Last modified 1mo ago