Hi,

two ideas:

1. Add field _CELONIS_CHANGE_DATE to your DM and use MAX(_CELONIS_CHANGE_DATE) to get latest date of your data extractions
2. Make use of a dummy table that you add to your transactions and which is executed in front of a new data model load. Within this dummy table you just insert the current timestamp:

e.g:

CREATE TABLE LAST_DATA_LOAD AS (

SELECT CURRENT_TIMESTAMP AS LAST_DATA_LOAD

);

BR

Dennis

Hi @nicola.lomba11,

Every extracted table in Celonis automatically includes a hidden column named "_CELONIS_CHANGE_DATE". This column stores the timestamp when the data extraction process started for that specific table. You can leverage this column to display the last data load date in your views. 😁

For instance, for an Excel file I loaded in, it also generates the _Celonis_Change_Date column. Hopefully this helps you out!