Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Metabase is an open source data collaboration and visualization platform. You can visualize your data from Arm Treasure Data with Metabase. See https://www.metabase.com/docs/latest/ for more detail about Metabase.
This topic includes:

Table of Contents

Setup Set up Metabase

See Metabase installation. This page describes a way to connect to Treasure Data Presto from Metabase with Mac OS X application.


Setup Set up Presto connection

  1. Install Metabase.

  2. Navigate to the Databases page on the Admin menu.

  3. Select Click Add database.

Image Modified


You’ll see a list of database types.

...

  • Database type: Presto

  • Name: <Any name>

  • Host: api-presto.treasuredata.com

  • Port: 443

  • Database name: td-presto

  • Database username: <YOUR TREASURE DATA APIKEY>

  • Database password: <any password (Treasure Data Presto validates only APIKEY)>

  • Use an SSH-tunnel for database connections: OFF (Not Supported)

  • This is a large database, so let me choose when Metabase syncs and scans: YES

Image Modified


After the connection is established, Metabase takes a look at the metadata of the fields in your tables and automatically assigns them a field type. Also, you’ll select one of three scan options in the Scheduling tab.

Review managing databases for more details.

Image Modified


5. 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 button on the right side of the screen.

Image Modified


You can see your table schema at View Schema after the schema load is completed.

Image Modified


6. Create a Native Query on New Question.

7. Specify a table by FROM <database_name>.<table_name>.

Image Modified