Metabase with TreasureData (Experimental)

Metabase is a open source data collaboration and visualization platform. User can visualize own data from Treasure Data with Metabase.

Table of Contents

Setup Metabase

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

Setup Presto connection

After installing Metabase, visit Databases page on Admin menu, and click “Add database”.

Then you’ll see a list of database types. To connect Treasure Data Presto to Metabase, write down the following information based on your account:

  • 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

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.

See here for more details.

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.

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

Now, you can create a Native Query on New Question. You can specify a table by FROM <database_name>.<table_name>.

Next Step

See the following doc to know more detail about Metabase.


Last modified: Dec 03 2017 08:53:32 UTC

If this article is incorrect or outdated, or omits critical information, let us know. For all other issues, access our support channels.