[Elastic Agent] Track TSDB enablement

[constanca-m]

Data streams

All metrics data streams were migrated, except for Endpoint security metrics since the data stream is not working currently (see elastic/elastic-agent#1944).

• Add dimensions: [Elastic Agent] Set dimension fields for metrics data streams #6939

• Set metric type: [Elastic Agent] Set metric type #7033

• Enable TSDB by default: [Elastic Agent] Enable TSDB by default #7214:

  • Endpoint security metrics is not migrated since it receives no data.
  • Filebeat input metrics: the migration is failing with

  Error: error running package asset tests: could not complete test run: can't install the package: can't install the package: could not install package; API status code = 500; response body = {"statusCode":500,"error":"Internal Server Error","message":"invalid_index_template_exception\n\tRoot causes:\n\t\tinvalid_index_template_exception: index_template [metrics-elastic_agent.filebeat_input] invalid, cause [Validation Failed: 1: [index.mode=time_series] requires a non-empty [index.routing_path];]"}
  

  However, agent.id is set as dimension and it is always present for all documents. I cannot find the reason for why this is happening, so I am removing this data stream migration from this PR.