...
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
Install Metabase.
Navigate to the Databases page on the Admin menu.
Click Add database.
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
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.
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 Sync on the right side of the screen.
You can see your table schema at View Schema
after the schema load is completed.
6. Create a Native Query on New Question.
7. Specify a table by FROM <database_name>.<table_name>
.