schema refresh end time

[Incortaconsulta]

Do we have any way to get schema refresh end time and display it dashboard with latest refresh completion time.

currently we have schemaRefreshTime takes a schema name and returns the last refresh start time if the system is running. similarly if we get something for load completion time it would be great.

Regards,

Ram

[dylanwan]

The reason why show the last schema refresh start time is to let the user know how fresh the data they are looking at.

What is the purpose of viewing loading completion time?

The JOB history table from the _IncortaMetadata schema has the information.  A dashboard insight can be built to show the data from JOB history.

[Incortaconsulta]

Dylanwan - To give you a context, Assume run time for my schema is 3 hours and only if the schema load is successful, I want to publish it on the dashboard with the last load completion time. this was requirement from our users.

[Incortaconsulta]

I agree, we can fetch data from _IncortaMetadata schema , but the challenge there is I have couple of schemas which ran for 3 hours + and post-load takes somewhere between 20 to 30 mins for each of them. so previously, when we try to take it from JOB history table, it got struck in post load and dashboards were not delivered with the latest load completion time.