Source History Attributes
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 |