AWS services support expansion for opentelemetry-instrumentation-botocore

Currently the opentelemetry-instrumentation-botocore pkg only support limited AWS services with extension, as application ecosystem grows, we want to broaden our support to encompass a wider range of services and add more resource attributes into span. Right now, we are considering improving instrumentation support for Kinesis, S3, SQS and SNS. There will be more support coming up for other AWS services in the future.

Describe the solution you'd like
We want to expand _KNOWN_EXTENSIONS in opentelemetry-instrumentation-botocore . For example, in _SqsExtension, we will add "aws.sqs.queue_name" into span attributes. And adding more for the other services as well.

Additional context
We have a aws-otel-python-instrumentation pkg, which builds aws python distro for AWS Application Signals enablement. This pkg depends on opentelemetry-python-contrib for manual/auto instrumentation. We want to expand support for AWS Application Signals, thus want to contribute to upstream instrumentation pkg.

Start in instrumentation/opentelemetry-instrumentation-botocore/src/opentelemetry/instrumentation/botocore/extensions/init.py and review the existing _KNOWN_EXTENSIONS entries, then inspect extensions/sqs.py and the corresponding Kinesis, S3, and SNS support. Done means the requested services are covered and their relevant resource attributes, including aws.sqs.queue_name, are added to spans.