[Meta] [TSDB] Eliminate fingerprinting of dimensions and labels added as part of TSDB Enablement

[agithomas]

The Elasticsearch issues

• Remove dimension limit for time series data streams elasticsearch#93564
• Hash the tsid to overcome dimensions limits elasticsearch#98023
  are resolved.

These changes help to overcome the dimension limit and the need to hashing the labels and dimensions that are part of the Elastic Integration package fields.

The changes are presently evaluated & tested for the Prometheus package.

This meta issue captures the scope of the integration package (datasets) which could take the benefit of above mentioned improvements added to Elasticsearch.

Requirements

• 8.14 or above.

Related Issues

• Cleanup dockerfile kibana#183334 (comment) (Blocking)

Pass Criteria

• No document drop should happen after applying the changes

Testing Methodology.

• Manual verification
• TSDB Test toolkit evaluation

Applicable Integration package list.

Beta Give feedback

1. AWS/cloudwatch_metrics
2. azure_application_insights
3. azure_metrics/monitor
4. elasticsearch/ingest_pipeline
5. etcd/metrics
6. gcp/cloudrun_metrics
7. gcp/cloudsql_mysql
8. gcp/cloudsql_postgresql
9. gcp/cloudsql_sqlserver
10. gcp/compute
11. gcp/dataproc
12. gcp/gke
13. gcp/loadbalancing_metrics
14. gcp/pubsub
15. gcp/redis
16. gcp/storage
17. istio/istiod_metrics
18. istio/proxy_metrics
19. microsoft_sqlserver/transaction_log
20. mysql/performance
21. oracle/performance
22. postgresql/activity
23. prometheus/collector : [prometheus] Eliminate labels fingerprint #9785
24. prometheus/query : [prometheus] Eliminate labels fingerprint #9785
25. prometheus/remote_write : [prometheus] Eliminate labels fingerprint #9785

Update Developer Guidelines Document

Beta Give feedback

1. TSDB Guidelines document (github)
2. Developer Documentation Page (if applicable)