[FEATURE] Error handling improvement request

[yipez-spec]

Is your feature request related to a problem? If yes, please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]
Currently, there are a lot of different runtime exception being thrown in every custom connectors and the exception is all thrown as Runtime exception. We need a way to better understanding if it's a client exception or a server exception

Describe the solution you'd like
A clear and concise description of what you want to happen.
To supply an additional ErrorCode to classify the exception as one of the following:
AccessDeniedException
EntityNotFoundException
InvalidCredentialsException
InvalidInputException
InvalidResponseException
OperationTimeoutException
OperationNotSupportedException
InternalServiceException
PartialFailureException
ThrottlingException

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

For a sample error handling for DynamoDB:

Error handling in Athena Connector CDK.pdf

[macohen]

@Trianz-Akshay, do you want this issue assigned to you? Commenting here will enable us to do that.

[Trianz-Akshay]

@Trianz-Akshay, do you want this issue assigned to you? Commenting here will enable us to do that.

I'm sorry for not getting back to you sooner. Sure, you can assign it to me.