Data Refresh Time Access

Is there a way to access the schema / table refresh time via a formula column & the UI.  I want to show users the last time the data being leveraged by the dashboard was loaded. 

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Use the function schemaRefreshTime("Schema_name") in a data field.

  • Hello Team,

    I have an issue with this function schemaRefreshTime("Schema_name"):

    The output of this function is GMT.

  • Resolved this by using the funtion addMinutes as below:

    addMinutes(schemaRefreshTime("Schema_name"), -420)

  • Dilip, you can also set the timezone for your tenant in the Admin UI (http://<incorta server>:<incorta port>/incorta/admin under <Tenant>->Regional Settings in the "Time Zone" field.  See the screenshot below where I set this to "GMT-8" for Pacific time.  Changing this setting does require an Incorta restart.


  • Unsucessful using this function in a formula column within an insight. Schema name used was the actual physical schema, name was changed in the screenshot. 

    Does not give any error, however there was no output.

  • Works fine and value shows up when Aggregation is set to MAX.  

    Like 2
Like Follow
  • Status Answered
  • 10 mths agoLast active
  • 6Replies
  • 353Views
  • 7 Following

Product Announcement

We are happy to
announce Incorta 4.8 !!!