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:
Prerequisites
Basic Knowledge of Treasure Data.
Basic knowledge of Airship / Airship Audience Lists
Creating Your Connection from the Command Line
You can use the CLI to configure your connection.
td query --database <your_database> --result <configuration> <query>
The following table identifies the configuration keys with descriptions.
Config Key | Type | Required | Description |
---|---|---|---|
| string | yes | airship |
base_url | string | yes |
|
| string | - | Airship Bearer access token |
| string | - | |
| string | - | App Secret or Master secret |
| string | Yes | Audience List name. |
| string | No | Audience List description |
| boolean | No | Use to skip invalid records and continue uploading a valid one. Set For example, a record contains empty or null data. |
| int | No | Maximum retry times for each API call. Default: 5 |
| long | No | Wait time for the first retry. Default: |
| long | No | Maximum time between retries. Default: |
| long | No | The amount of time before the connection times out when doing API calls. Default: |
| long | No | The amount of time waiting for writing data into the request. Default: |
| long | No | The amount of time waiting for reading data from the response. Default: |
Example: Query and export results to an Airship Audience List
td query --database my_db \ --result '{ "type": "airship", "app_key": "xxx" "app_secret": "yyy" "list_name: amazon_channels, "list_description": "amazone collected channels for marketing" }' 'SELECT identifier_type, identifier from my_table'
Scheduling Execution
Make sure to review: