Versions Compared

Key

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

...

Then, you’ll set Connection Info from the dialog below.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”

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

Data Mapping

When you click Next, the Treasure Data SQL query will be executed and executesand Datorama shows a list of columns of the result. In this screen, you will 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.

...

Click Save to finalize the mapping phase. If it shows Error like below, you must resolve these errors to proceed to the next phase.

...

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

Check if the records are correct.

Click Continue.

...

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

...