Thanks for the feedback! I have learned the following:
> Question: Hi Phoenix team - if I know the span_id for a particular trace, is there any way to delete it from the database? Context: this is a legal requirement for using Phoenix in production where the users should be able to request to delete their data anytime. Could you please share more details on the SQL queries to delete the record by using span_id? Like the table, and the related schema etc. Thanks!
>
> Answer: Phoenix does not currently provide a dedicated REST API to delete individual spans by span_id. However, you can manually connect to the database (SQLite or PostgreSQL) and issue SQL queries to delete spans older than a certain date or by specific IDs. For traces, there is a `delete_traces` function in the backend that deletes traces by their IDs, but there is no equivalent public function or API for deleting individual spans by span_id. If you need to automate span deletion, you would have to write a custom script that connects to your database and deletes the span with the given span_id. There is no built-in UI or API endpoint for this use case as of now.
