# Redash Export Integration

[Redash](https://redash.io/help/) is an open-source data collaboration and visualization platform. Users can visualize their own data from Treasure Data with Redash by building their own dashboards with Redash and Treasure Data.

![](/assets/image-20191016-204045.eb51bef6c18ec91f5a8623d7b0d3e0a428d15a410be97620c75b926fdd46146d.f2ebf899.png)

This topic includes:

## Configure in Redash

- Environments
  - Redash v0.10.1 by using [AMI Image](https://docs.redash.io/en/latest/setup.html#create-an-instance)
  - Treasure Data account
- Choose AMI Image from [docs](https://docs.redash.io/en/latest/setup.html#create-an-instance).
- Launch `redash-0101b1834.1-us-east-1 - ami-52c3373f (ami-52c3373f)` or later.
- Open http://(Address)/login as admin/admin.


![](/assets/image-20191016-204105.be380672ac5c4eb62069c1f3eef65975f9e8b63e49bce1ae43720dade53aeb95.f2ebf899.png)

## Configure in Your Connector

### Add Treasure Data Connector

To add Treasure Data connector as a data source, edit the following parameters.

- Name: Any
- Type: TreasureData
- APIKEY: Any (Required)
- Database Name: Any (Required)
- Endpoint: [https://api.treasuredata.com/](https://api.treasuredata.com/) (Default: [https://api.treasuredata.com/](https://api.treasuredata.com/))
- Auto Schema Retrieval: Off (default) — If you turn on this feature, Treasure Data’s table schema appears in Query Editor. But, if you have a lot of schema in Treasure Data, this feature might affect the performance.
- Type: hive/presto


![](/assets/image-20191016-204131.8eea5c4a0c68d3e939f9b338d359b4cbf15137a904ac98f579a699f7bcf323c2.f2ebf899.png)

### Try New Query

After adding Treasure Data connector, you can select it as a Data Source on the New Query page. You can see the table schema on the right. After issuing a new query, you can see the results at the bottom. Optionally, you can select `Refresh Interval` to collect data automatically.

![](/assets/image-20191016-204156.6c2f11ca3ba271f05d341c5b56eeab26fab6c93388c08cdf4cf6b783fb960de1.f2ebf899.png)

Also, you can see the job issued from Redash on Treasure Data Console.

![](/assets/image-20191016-204219.db1e79ae4097b1b6c0e482f56f56b1616637f6dc81bb6eefd4830af34e10d1c0.f2ebf899.png)

### Visualize Collected Data

Let’s set the following query; you can get Page View.


```
SELECT
TD_TIME_FORMAT(time, 'yyyy-MM-dd HH:00:00') as hour,
count(1) as pv
FROM www_access
GROUP BY 1
```

![](/assets/image-20191016-204238.9d17b7e37e5e7429c7de0471b4d0a7c7ce7ff5d0a678124181ff6a70f7b73240.f2ebf899.png)

To visualize the above data, click + New Visualization button, and then you can edit graph.

![](/assets/image-20191016-204403.36f5c1b328bda85b8ee96d4b4c2507784fbd54684b99c10bebcd7128572b3958.f2ebf899.png)

To save your graph, change the title on top.

![](/assets/image-20191016-204301.273d7d0b3e187c0289db49fe859d3f474e9de0b59ba81673d7d1bb17350b0c7b.f2ebf899.png)

### Build Your Dashboard

After visualizing collected data, you can build your own dashboard.

Move to the dashboard page, and you can add your graph by Add widget.

![](/assets/image-20191016-204316.ce084ce15661b7b48766ce1931362d0b0d599f6f752e7dc221647eb8be227b18.f2ebf899.png)

Then, you can see Page View on your dashboard.

![](/assets/image-20191016-204324.d2fd9f43748a02a361a2aa3c50f01c34a296493562ef0b9557314023713e10ab.f2ebf899.png)

## Conclusion

You can collect data from Treasure Data easily and visualize data on Treasure Data by Redash!

![](/assets/image-20191016-204339.b31f783eb95cb9a2d1bf049a4abd28285d3f2a6bbf2974130e2a5a90fd75fa07.f2ebf899.png)