Instrumentation for AWS SDK 1.11 not setting db.system for DynamoDB requests

[akats7]

Describe the bug

The AWS 1.11 requests auto instrumentation does not seem to be setting the db.system attribute for dynamoDB spans. This is stopping our platform from identifying it properly as a db span.

Steps to reproduce

Enable javaagent and make request to dynamoDB using AWS 1.11 SDK

Expected behavior

db.* attributes to be set on dynamodb spans

Actual behavior

No db.* attributes set, treated as external service call

Javaagent or library instrumentation version

io.opentelemetry.aws-sdk-1.11

Environment

JDK:
OS:

Additional context

No response

[trask]

hi @akats7!

it looks like AWS SDK 2.2 instrumentation sets a couple of db attributes:

opentelemetry-java-instrumentation/instrumentation/aws-sdk/aws-sdk-2.2/library/src/main/java/io/opentelemetry/instrumentation/awssdk/v2_2/internal/TracingExecutionInterceptor.java

Lines 330 to 336 in 5cc8917

	if (awsSdkRequest.type() == DYNAMODB) {
	span.setAttribute(DB_SYSTEM, DB_SYSTEM_DYNAMODB);
	String operation = attributes.getAttribute(SdkExecutionAttribute.OPERATION_NAME);
	if (operation != null) {
	span.setAttribute(DB_OPERATION, operation);
	}
	}

I think we'd welcome the equivalent change to AWS SDK 1.1 instrumentation if that's possible

[vasantteja]

Hello @trask, Can you please assign this to me if this needs a code change?

[akats7]

Hi @vasantteja, thanks for offering, we already have a proposed fix, I just wanted to create an issue prior to opening a PR