Source History attributes can be used in the SELECT list, WHERE clause and ORDER BY clause of a MQL Query.
The following Source History attributes are supported on a set of imported objects such as tables, views, and Tableau worksheets, dashboards and workbooks.
|
Source History attribute name |
Description |
Value examples |
Value data type |
Supported operators in WHERE |
Supported in ORDER BY |
Supported in FACET |
|
"Source History"."Popularity Count" |
Popularity count of the object in the source system |
10 |
Integer |
=, !=, = ANY (...), != ANY (...), [NOT] EXISTS, <, <=, >, >= and BETWEEN … AND … |
Yes |
Yes |
|
"Source History"."Last Data Access Date" |
Last data access date for database tables and views etc. |
2024-07-24 13:25:17 |
Date |
=, BEFORE, AFTER, BETWEEN ... AND …, [NOT] EXISTS |
Yes |
Yes |
|
"Source History"."Last Data Update Date" |
Last data modification date for database tables and views etc. |
2024-07-24 13:25:17 |
Date |
=, BEFORE, AFTER, BETWEEN ... AND …, [NOT] EXISTS |
Yes |
Yes |
|
"Source History"."Last Access Users" |
Last users who access an object |
[{ “Name”: “Angela”, “Email”: “agelar@metaintegration.com”, “Last access time”: “2024-07-24 13:25:17”}] |
Array of SourceHistoryAccessUser |
[NOT] EXISTS |
No |
No |