Built-in Functions → schemaRefreshTime
schemaRefreshTime() is a function that returns the last refresh start time of a physical schema if the system is running. The function takes a schema name and returns the last refresh start time if the system is running. If the system is rebooted, the last load start time gets returned (until the next refresh). If the schema is not a part of a dashboard, it will not be accurate and will show the date/time in which the dashboard first ran and the function had been called.
Warning
Do not use this function in physical schema formula columns as this will cause Post-load calculations to fail, resulting in unsuccessful load jobs.
Signature
schemaRefreshTime(schemaName)
- schemaName is a
stringparameter.
Returns
timestamp
Example
Find the last refresh time of the SALES schema.
schemaRefreshTime("SALES")