topic schema refresh end time in Administrative Discussions

schema refresh end time

Incortaconsulta — Thu, 27 Mar 2025 11:26:53 GMT

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

Re: schema refresh end time

dylanwan — Thu, 27 Mar 2025 13:37:23 GMT

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.

Re: schema refresh end time

Incortaconsulta — Thu, 27 Mar 2025 16:10:56 GMT

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.

Re: schema refresh end time

Incortaconsulta — Thu, 27 Mar 2025 16:13:09 GMT

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.

Re: schema refresh end time

dylanwan — Fri, 09 May 2025 11:45:02 GMT

Are you talking about that the JOB table itself is not refreshed timely?