# Metabase Experimental

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

## Set up Metabase

See [Metabase installation](https://www.metabase.com/docs/latest/operations-guide/start.md#installing-and-running-metabase). This page describes a way to connect to Treasure Data Presto from Metabase with Mac OS X application.

**Optionally, Install the Starburst Metabase driver**

1. Go to [Releases · starburstdata/metabase-driver](https://github.com/starburstdata/metabase-driver/releases)
2. Download jar file for the latest version of the driver
3. Copy the jar file into the plugins directory in Metabase


Starburst is a community-developed driver. Contact [Starburst](https://docs.starburst.io/support.md) with any questions.

## Set up Presto connection

1. Install Metabase.
2. Navigate to the Databases page on the Admin menu.
3. Click **Add database**.


![](/assets/image-20191016-195602.0eac3630504e4e2a839a63db61b34784298ce912e6920c822b506d7b1eaaad8c.83d33514.png)

You’ll see a list of database types.

1. 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`


![](/assets/image-20191016-195640.e23c7718ebc472117713bb2c766d4297d8f2b64e93acbde0463bc654d9353b97.83d33514.png)

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](https://www.metabase.com/docs/latest/administration-guide/01-managing-databases.md) for more details.

![](/assets/image-20191016-195726.539799cc79f0380e6e9c7be0685e4feb45ed6461ccf3f288096fc849aabaf7d8.83d33514.png)

1. 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.


![](/assets/image-20191016-195737.2fe923eb28a7a9119177014f1232528ded6355b124b9fe806780043a311fdd23.83d33514.png)

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

![](/assets/image-20191016-195746.3c94f39e52006d085c8f7780d9a6bbaea8a6f6a113d4183811b3df748be96bc7.83d33514.png)

1. Create a Native Query on New Question.
2. Specify a table by `FROM database_name.table_name`.


![](/assets/image-20191016-195755.4b9c39338d9b352dbc80ce2ad6b53408f940325da09ae77c3261ac461531e56c.83d33514.png)