# td_table_export>: Treasure Data table export to S3

NOTE: We're limiting export capability to only us-east region S3 bucket. In general, please use Result Output to S3 feature using td operator.

**td_table_export>** operator exports data from Treasure Data to S3.


```
+step1:
  td_table_export>:
  database: mydb
  table: mytable
  file_format: jsonl.gz
  from: 2016-01-01 00:00:00 +0800
  to:   2016-02-01 00:00:00 +0800
  s3_bucket: my_backup_backet
  s3_path_prefix: mydb/mytable
```

## Secrets

When you don't know how to set secrets, please refer to [Managing Workflow Secret](https://docs.treasuredata.com/products/customer-data-platform/data-workbench/workflows/setting-workflow-secrets-from-td-console)

* **td.apikey**: API_KEY
The Treasure Data API key to use when running Treasure Data table exports.
* **aws.s3.access_key_id**: ACCESS_KEY_ID
The AWS Access Key ID to use when writing to S3.
Examples:



```
  aws.s3.access_key_id: ABCDEFGHJKLMNOPQRSTU
```

* **aws.s3.secret_access_key**: SECRET_ACCESS_KEY
The AWS Secret Access Key to use when writing to S3.
Examples:



```
  aws.s3.secret_access_key: QUtJ/QUpJWTQ3UkhZTERNUExTUEEQUtJQUpJWTQ3
```

## Options

* **database**: NAME
Name of the database.
Examples:



```
  database: my_database
```

* **table**: NAME
Name of the table to export.
Examples:



```
  table: my_table
```

* **file_format**: TYPE
Output file format. Available formats are `tsv.gz` (tab-separated values per line) and `jsonl.gz` (json record per line).
`json.gz` and `line-json.gz` are available only for backward compatibility purpose.
Examples:



```
  file_format: jsonl.gz
```

* **from**: yyyy-MM-dd HH:mm:ss[ Z]
Export records from this time (inclusive). Actual time range is :command:`[from, to)`. Value should be a UNIX timestamp integer (seconds) or string in yyyy-MM-dd HH:mm:ss[ Z] format.
Examples:



```
  from: 2016-01-01 00:00:00 +0800
```

* **to**: yyyy-MM-dd HH:mm:ss[ Z]
Export records to this time (exclusive). Actual time range is :command:`[from, to)`. Value should be a UNIX timestamp integer (seconds) or string in yyyy-MM-dd HH:mm:ss[ Z] format.
Examples:



```
  to: 2016-02-01 00:00:00 +0800
```

* **s3_bucket**: NAME
S3 bucket name to export records to.
Examples:



```
  s3_bucket: my_backup_backet
```

* **s3_path_prefix**: NAME
S3 file name prefix.
Examples:



```
  s3_path_prefix: mytable/mydb
```

* **endpoint**: ADDRESS
API endpoint (default: api.treasuredata.com).
* **use_ssl**: BOOLEAN
Enable SSL (https) to access to the endpoint (default: true).


## Output parameters

* **td.last_job_id** or **td.last_job.id**
The job id this task executed.
Examples:



```
  52036074
```

* **td.last_job.num_records**
The number of records of this job output.
Examples:



```
  10
```