add delete failed datasource

[iakov-aws]

Issue #, if available:

Description of changes: Avoid keeping all failed datasources + change name of datasource to Athena-CID for better identification.

By submitting this pull request, I confirm that you can use, modify, copy, and redistribute this contribution, under the terms of your choice.