Delete

The Delete API allows you to remove data from Telemetry. You can delete specific rows based on a condition or remove an entire table. Be cautious when using this API, as deleting data is irreversible.

DELETE https://api.telemetry.sh/delete

Headers

Name	Type	Description
Content-Type	String	application/json
Authorization	String	<YOUR_API_KEY>

Body

Name	Type	Description
table	String	The table you want to delete data from
where	String (optional)	SQL clause for what rows to delete

Example usage with cURL

To delete all rows older than 3 days from the table named uber_rides using cURL, you can use the following command:

API_KEY="YOUR_API_KEY"
WHERE_CONDITION="timestamp <= (now() - INTERVAL '3 day')"

curl -X DELETE https://api.telemetry.sh/api/delete \
  -H "Content-Type: application/json" \
  -H "Authorization: $API_KEY" \
  -d @- <<EOF
{
  "table": "uber_rides",
  "where": "$WHERE_CONDITION"
}
EOF

If you want to delete the entire uber_rides table, simply omit the where field:

API_KEY="YOUR_API_KEY"

curl -X DELETE https://api.telemetry.sh/api/delete \
  -H "Content-Type: application/json" \
  -H "Authorization: $API_KEY" \
  -d '{
    "table": "uber_rides"
  }'

Important Notes

• Data Deletion: Be careful when using the delete endpoint. If the where condition is not provided, the entire table will be deleted.

• Irreversibility: Once data is deleted, it cannot be recovered.