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)