...
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
Click Select the Data Streams parent tab and then the Data Streams child tab.
Find Treasure Data under the Technical Vendors category and click select the icon.
...
Then, specify your data stream Name, Data Stream Type, and Default Channel Name.
...
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” |
Click Select Validate. If it shows Success! dialog, your setup was succeeded.
Data Mapping
When you click 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.
...
Click Select Save to finalize the mapping phase. If it shows Error like belowan error like the following example, you must resolve these errors to proceed to the next phase.
...
Check if the records are correct.
Click Select Continue.
...
Your data is ingested into Datorama. It should show Processing Complete! message when it’s completed.
...