Redash 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.
Configure in Redash
Environments
Redash v0.10.1 by using AMI Image
Treasure Data account
Choose AMI Image from docs.
Launch
redash-0101b1834.1-us-east-1 - ami-52c3373f (ami-52c3373f)
or later.Open http://(Address)/login as admin/admin.
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/ (Default: 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 (Default) / presto (Paid Plan)
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.
Also, you can see the job issued from Redash on Treasure Data Console.
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
To visualize the above data, click + New Visualization button, and then you can edit graph.
To save your graph, change the title on top.
Build Your Dashboard
After visualized collected data, you can build your own dashboard.
Move to dashboard page, and you can add your graph by Add widget.
Then, you can see Page View on your dashboard.
Conclusion
You can collect data to Treasure Data easily and visualize data on Treasure Data by Redash!