Export to Metabase

This document is for customers who need to set up the connection between Metabase and Acho for the first time.

Setup Metabase connection

1. Contact Acho to request a one-time setup

Contact us to receive the Dataset ID and Service account JSON file to connect your Metabase with Acho

2. Add a Database in Metabase

2.1 Click "Admin" on the top-right gear icon

2.2 Click "Add a database" in the Settings

2.3 Set up Database type, Name, Dataset ID, and Service account JSON file

Set up the form with the following instructions:

  • Database type

    • BigQuery

  • Name

    • The name of the database in your Metabase

  • Dataset ID

    • The Dataset ID you receive from Acho Team

  • Service account JSON file

    • The JSON file you receive from Acho Team

  • This is a large database, so let me choose when Metabase syncs and scans(optional)

    • Turn on this setting if you need to customize when Metabase syncs with Acho

Click "Save" to set up the database in your Metabase

2.4 Finish the setup, and the connected database will show up on the homepage

3. Sync the table from Acho to Metabase

3.1 Export a table from Acho

3.2 Sync the database in Metabase

3.2.1 Click "Admin" on the top-right gear icon

3.2.2 Click "Database" in the navigation bar

3.2.3 Click the Database Name you created during the setup of the database

3.2.4 Click "Sync database schema now" to sync the tables from Acho to Metabase

3.3 Check the Acho tables in Metabase

3.3.1 Click the gear icon on the top right, and click "Exit admin"

3.3.2 Click the Database Name again

3.3.3 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"