It is imperative that we have to load the individual tables on the need basis outside of the load schedule. Then, SchemaRefreshTime variable will also reflect this table load instead of the previous schema load. And the dashboards using this variable will also reflect the incorrect data.
Can we have the ability for the variable as below,
1. SchemaRefreshTime(<SchemaName>,<TableName>) --> Should provide the last load of a particular table within the schema.
2.SchemaRefreshTime(<SchemaName>) --> Should provide the info on the last load of the schema (Incremental or Full)