This article describes how to use Datorama with Treasure Data. Datorama supports Treasure Data natively.

Prerequisites

  • Datorama account

  • Basic knowledge of Treasure Data

  • Requires access to the new Presto-specific JDBC/ODBC API, currently in Private Beta. Contact your account representative if you’d like access to this feature.


Create a Data Stream

  1. Select the Data Streams parent tab and then the Data Streams child tab.

  2. Find Treasure Data under the Technical Vendors category and select the icon.



Then, specify your data stream Name, Data Stream Type, and Default Channel Name.



Then, you’ll set Connection Info from the dialog as follows:



Set each field:

Delivery Method

Databases

Connection String

jdbc:presto://api-presto.treasuredata.com:443/td-presto/database

Credentials - User

“YOUR_API_KEY”

Credentials - Password

(Empty)

Query

“YOUR_TREASURE_DATA_QUERY”

Select Validate. If it shows Success! dialog, your setup was succeeded.

Data Mapping

When you select Next, the Treasure Data SQL query executesand Datorama shows a list of columns of the result. In this screen, you map your original columns to Datorama’s global columns. With Datorama’s auto-mapping algorithm, some columns may be already mapped based on your previous mapping activities.



For the rest of the column, which is not mapped, you can manually map with global columns.



Select Save to finalize the mapping phase. If it shows an error like the following example, you must resolve these errors to proceed to the next phase.



Data Preview shows the actual records retrieved from Treasure Data inside Datorama.

Check if the records are correct.

Select Continue.



Your data is ingested into Datorama. It should show Processing Complete! message when it’s completed.





  • No labels