@kapa.ai how can I delete an applied custom source?

To delete a custom source in Airbyte, you can use the Airbyte Public API's

DELETE /sources/{sourceId}

endpoint. This operation does not require authentication. The

sourceId

is the unique identifier of the source you want to delete. If the operation is successful, the API will return a 204 status code, indicating that the resource was deleted successfully. However, before deleting a custom source, make sure to delete all the connections related to that source. If you have used the Airbyte database and not an external one, you can execute the deletion directly from the database. You can find the relevant entries in the

actor_definition

table. Here is an example of a SQL query that can be used to delete a custom connector from the Airbyte database:

sql WITH c_b_p AS (   DELETE FROM connector_builder_project   WHERE name = '<your connector name here>'   RETURNING id, actor_definition_id ), a_d_m AS (   DELETE FROM active_declarative_manifest t   USING c_b_p   WHERE t.actor_definition_id = c_b_p.actor_definition_id ), a_d AS (   DELETE FROM actor_definition t   USING c_b_p   WHERE t.id = c_b_p.actor_definition_id ) SELECT * FROM c_b_p;

Please replace

<your connector name here>

with the name of your custom connector. Please note that this operation should be performed with caution as it directly manipulates the database. Sources: - [Airbyte Public API - Sources > Methods > deleteSource](https://reference.airbyte.com/reference/start) - [Forum Post: Delete custom connector from the UI](https://discuss.airbyte.io/t/815) - [Github Issue (closed): Add instructions to delete custom connectors](https://github.com/airbytehq/airbyte/issues/22606)