Druid -- Insert Timestamp column

Hi Team,

Could you please let me know if I can add insert time stamp column along with other Dimension to track the inserted data in druid segments?.



Hi Ashis,

If I understood you correctly, Maybe you want to use Secondary timestamps:

Druid schemas must always include a primary timestamp. The primary timestamp is used for partitioning and sorting your data, so it should be the timestamp that you will most often filter on. Druid is able to rapidly identify and retrieve data corresponding to time ranges of the primary timestamp column.

If your data has more than one timestamp, you can ingest the others as secondary timestamps. The best way to do this is to ingest them as long-typed dimensions in milliseconds format. If necessary, you can get them into this format using transform specs and expressions like timestamp_parse, which returns millisecond timestamps.

You can refer below for more details :

Thanks and Regards,