Hi there! Is it possible to show in views the last data load date? Users would like to see in app when data have been loaded in Celonis. Thank you in advance for your help!
Best answer by dennis.pflug
Hi,
two ideas:
- Add field _CELONIS_CHANGE_DATE to your DM and use MAX(_CELONIS_CHANGE_DATE) to get latest date of your data extractions
- 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,
two ideas:
- Add field _CELONIS_CHANGE_DATE to your DM and use MAX(_CELONIS_CHANGE_DATE) to get latest date of your data extractions
- 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
+14Hi @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!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.