Kaustav Ghosh
09/26/2024, 9:52 AMuser
09/26/2024, 9:53 AMairbyte-db
and not an external one, you can exec into it based on your deployment (Docker or Kubernetes). 3. In the database, you will find the actor_definition
table which you can check and delete the relevant entries. 4. If you encounter issues with deleting the custom connector with the sourceDefinitionId
, you may need to edit the airbyte-db
entry in the actor_definition
table. Here is an example SQL query that might help you delete the custom connector: 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 connector. Remember to be careful when directly interacting with the database as it can affect the integrity of your data. For more information, you can refer to this [forum post](https://discuss.airbyte.io/t/815) and this [Github issue](https://github.com/airbytehq/airbyte/issues/22606).