Support zero-code configuration of resource detectors

[MrAlias]

Having a complete and correct resource to associate with telemetry often requires a resource detector to be used. There is currently no way to configure a resource detector for the auto-instrumentation at run-time without having to write an implementation.

Describe the solution you'd like

When auto-instrumentation is started it determines what resource detector to run based on configuration it is provided (i.e environment variables, configuration file).

To accomplish this, the autodetect package should be used.

Describe alternatives you've considered

• Write our own autodetect package (i.e. feat: support resource detector auto-configuration with OTEL_GO_DETECTORS env var #2438)

[MrAlias]

For environment variable configuration, if we plan to support this method of configuration, the variable name will need to be prefixed with OTEL_GO_AUTO_. This matches our other configuration options for things that are not defined in the specification.

[MrAlias]

Supporting a configuration file for this will mean we need to integration the OpenTelemetry declarative configuration. This is not stable yet, and support is Go is an ongoing work-in-progres.

I propose we do not attempt to solve this problem when resolving this issue. Meaning we stick to just supporting environment variables.

[MrAlias]

Duplicate of #2434

[MrAlias]

Closing in favor of #2434