Scalar FunctionsDate & Time Functions
ingestion_time
Return the ingestion timestamp of the current row, as recorded by the nursery in the synthetic `ingest_time` column. Evaluates to a datetime null when the source does not carry an ingestion timestamp (e.g. ad-hoc `datatable(...)` inputs).
Differs from Microsoft KQL
Microsoft Kusto's ingestion_time() reads the $IngestionTime system
property, which is only populated when the source table has the
IngestionTime policy enabled. Berserk always stamps ingest_time at
nursery write time, so the value is populated for every catalog-ingested
row.
Syntax
ingestion_time()Returns: datetime
Examples
Example 1
datatable(x:int)[
1,
2,
3
]
| project x, t = ingestion_time()| x (int) | t (datetime) |
|---|---|
| 1 | null |
| 2 | null |
| 3 | null |