Keep the introduction brief. The customer is looking for this integration because they already have the product.

Example: Amazon Simple Storage Service (Amazon S3) is an object storage service that offers scalability, data availability, security, and performance. Amazon S3 provides features for data organization and configuration of access controls for your business, organization, and compliance requirements.

Replace the product name in the following sentence:

Example: This TD export integration allows you to write job results from Treasure Data directly to <product name>.

The Product Manager needs to add two to three bullets to explain how the customer can benefit from this integration.

Example:

• Map external ids: For example, you can map ids from your CRM system to the Braze user account. 

• Opt-out: When an end-user updates the consent choosing not to participate.

• Upload your own tracking of events, purchases, or custom profile attributes. This information can help you build precise customer segments that enhance the user experience for your campaigns.

Include a bulleted list of prerequisites the customer needs to successfully implement this export integration.

Example:

• Basic Knowledge of Treasure Data.

• Basic knowledge of Airship / Airship Audience Lists

List any product or integration limitations that affect the function of the integration.

Example:

• Treasure Data does not create a campaign.

• A transactional email action does not count over the rate limit of API calls.

• As per the rate limit of dotdigital API (https://developer.dotdigital.com/docs/getting-started-with-the-api#restrictions): one Upload bulk contacts action requires two API calls, which count into the overall rate limit.

For both CSV, TSV, JSONL formats, the following table lists options you can use to customize the final format of the files written into the destination:

code,cnt
200,4981
302,
404,17
500,2

code|cnt
200|4981
302|NULL
404|17
500|2

{"code": 200, "cnt": 4981}
{"code": 302, "cnt": null}
{"code": 404, "cnt": 17}
{"code": 500, "cnt": 2}

Open TD Console.

Navigate to Integrations Hub > Catalog.

Search for S3 and select

Select Create Authentication.

Type the credentials to authenticate:

 When specified will override region setting

Select Continue. 

Type a name for your connection.

Select Done.

1. Complete the instructions in Creating a Destination Integration.

2. Navigate to Data Workbench > Queries.

3. Select a query for which you would like to export data.

4. Run the query to validate the result set.

5. Select Export Results.

1. Select an existing integration authentication.
   
2. Define any additional Export Results details. In your export integration content review the integration parameters.
   For example, your Export Results screen might be different, or you might not have additional details to fill out:
   
   
3. Select Done.
4. Run your query
5. Validate that your data moved to the destination you specified.

SELECT * FROM www_access

_export:
  td:
  database: td.database

+s3v2_test_export_task:
  td>: export_s3v2_test.sql
  database: ${td.database}
  result_connection: s3v2_conn
  result_settings:
  	bucket: my-bucket
  	path: /path/to/target.csv
  	sse_type: sse-s3
  	format: csv
  	compression: gz
  	header: false
    delimiter: default
    null_value:  empty
    newline: LF
  	quote_policy: MINIMAL
  	escape: '"'
  	quote: '"'
  	part_size: 20

td query \
--result '{"type":"s3_v2","auth_method":"basic","region":"us-east-2","access_key_id": "************","secret_access_key":"***************","bucket":"bucket_name","path":"path/to/file.csv","format":"csv","compression":"none","header":true,"delimiter":"default","null_value":"default","newline":"CRLF","quote_policy":"NONE","part_size":10}' \
-w -d testdb \
"SELECT 1 as col" -T presto