td_partial_delete>: Delete range of Treasure Data table¶

td_partial_delete> operator deletes records from a Treasure Data table.

Warning

This operator is deprecated. Use DELETE function in Trino/Presto by td operator instead.

Please be aware that records imported using streaming import can’t be deleted for several hours using td_partial_delete. Records imported by INSERT INTO, Data Connector, and bulk imports can be deleted immediately.

Time range needs to be hourly. Setting non-zero values to minutes or seconds will be rejected.

+step1:
  td_partial_delete>: my_table
  database: mydb
  from: 2016-01-01T00:00:00+08:00
  to:   2016-02-01T00:00:00+08:00

Secrets¶

When you set those parameters, use digdag secrets command <https://docs.digdag.io/command_reference.html#secrets>.

td.apikey: API_KEY The Treasure Data API key to use when running Treasure Data queries.

Parameters¶

td_partial_delete>: NAME

Name of the table.

Examples:
```
td_partial_delete>: my_table
```
database: NAME

Name of the database.

Examples:
```
database: my_database
```
from: yyyy-MM-ddTHH:mm:ss[Z]

Delete records from this time (inclusive). Actual time range is [from, to). Value should be a UNIX timestamp integer (seconds) or string in ISO-8601 (yyyy-MM-ddTHH:mm:ss[Z]) format.

Examples:
```
from: 2016-01-01T00:00:00+08:00
```
to: yyyy-MM-ddTHH:mm:ss[Z]

Delete records to this time (exclusive). Actual time range is [from, to). Value should be a UNIX timestamp integer (seconds) or string in ISO-8601 (yyyy-MM-ddTHH:mm:ss[Z]) format.

Examples:
```
to: 2016-02-01T00:00:00+08:00
```
endpoint: ADDRESS

API endpoint (default: api.treasuredata.com)
use_ssl: BOOLEAN

Enable SSL (https) to access to the endpoint (default: true)