Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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. Click Select the Data Streams parent tab and then the Data Streams child tab.

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

...