You can write job results from Treasure Data directly to Airship Audience Lists. In Airship, you can then use the List to target specific users.
This topic contains:
Basic Knowledge of Treasure Data.
Basic knowledge of Airship / Airship Audience Lists
Due to API functions, you can override the list content; you cannot append the list.
You can upload up to 10 million records.
You can create up to 100 uploaded lists.
In Treasure Data, you must create and configure the data connection prior to running your query. As part of the data connection, you provide authentication to access the integration.
Open TD Console.
Navigate to Integrations Hub > Catalog.
Enter the Base URL:
Choose an authentication method.
Enter a name for your connection.
Select the Basic or Access token method.
For the Basic authentication method:
In the Airship project dashboard, select the Settings > APIs & Integrations.
Enter the App key, App secret, and App master secret.
For the Access token authentication method:
In the Airship project dashboard, select the Settings > APIs & Integrations > Tokens.
Create a new token and grant Audience Modification or All-access Role.
Configure the data connection.
SELECT identifier_type, identifier FROM table my_table
Open the TD Console.
Navigate to Data Workbench > Queries.
Click New Query to create a new query or search for a saved query that you plan to use to export data.
At the top of your query editor, select Export Results.
The Choose Integration dialog opens. You can use an existing connection or create a new connection for your export.
Use an existing connection
Type the connection name in the search box.
Select your connection.
Set the following parameters:
List Name (required)
Audience List name
Audience List description
Skip Empty Records (optional)
The default is True. If the query result contains an empty or null column, the row will be skipped, otherwise, the job will fail and you need to remove empty records manually.
You can use Scheduled Jobs with Result Export to periodically write the output result to a target destination that you specify.
timezone: UTC _export: td: database: sample_datasets +td-result-into-target: td>: queries/sample.sql result_connection: airship result_settings: list_name: 'td uploaded list' list_description: 'ios and android channels'