[Feature]: Delete data source experience

[sribalajig]

Is there an existing issue for this?

• [X] I have searched the existing issues

Summary

When I try to delete a datasource, there are a couple of issues -

1. After confirming that I want to delete a data source, Appsmith takes a really long time (~30s) to give me feedback that the data source cannot be deleted because there are actions that depend on it.
2. The error message does not actually list all of the actions that depend on the datasource, therefore it is very difficult to find them.
3. The datasource is not deletable even if you delete the apps and pages associated
4. Cannot delete a datasource, if the actions URL are updated, the association of an action to the datasource doesn't go away. Ref: https://theappsmith.slack.com/archives/C040LHZN03V/p1704429009634409

Please check the attached video for that shows the large time lag between deleting and the error message.

https://user-images.githubusercontent.com/15727421/190985602-1d8f9d3d-8e7b-4450-a4c2-ca1b1fd5c643.mov

Why should this be worked on?

For users who want to clean up their app by removing datasources that are not needed, it should be easy for them to do so.

Front conversations

Update

Another user reported this here

Edit 01/04/2024

• Added Point 4
• Point 1 and Point 3 are not reproducible anymore
• Point 2 is a feature request
• Created Subtasks for the above points

### Tasks
- [ ] https://github.com/appsmithorg/appsmith/issues/32292
- [ ] https://github.com/appsmithorg/appsmith/issues/32295