Convert epoc_second to date type

OpenSearch
1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
OpenSearch 2.15

Describe the issue:
I am ingestion data from DynamoDB to opensearch using opensearch ingestion pipeline so there is one field in DDB of type number which represent time in epoch_second like this : 1743064486.717718 so while ingestion in opensearch index it mapped to number type by default but I want to mapped it date type with strict_date_optional_time format.

Could someone please help me regarding this ?

Configuration:

Relevant Logs or Screenshots:

2

Hi @utkagar,

The epoch need to match the format as per:

i.e.:

PUT your_index
{
  "mappings": {
    "properties": {
      "epoch_milliseconds": {
        "type": "date"
      }
    }
  }
}

POST your_index/_doc/1
{
  "epoch_milliseconds": 1743064486717
}

Best,
mj