Power Hub currently supports the following Metadata tables:
- . AttributeMetadata_DES
- . TargetMetadata_DES
- . OptionsetMetadata_DES
- . GlobalOptionsetMetadata_DES
Note: StateMetadata and StatusMetadata will be implemented during q4
Metadata tables and columns currently supported:
Another important point is that all tables are configured as temporal tables which brings built-in support for providing information about data stored in the table at any point in time, rather than only the data that is correct at the current moment in time.
Further information about temporal tables in SQL can be found here
To minimize the switch from DES to Power Hub all tables are mirrored in DES views. The main differences between the table and the views are the naming/casing (lower in the views and camel in the table) and some extra columns in the views.
deletedon – only relevant for historical data in the history table/query.
deletedby – only relevant for historical data in the history table/query.
xxxAppURL – a direct URL to the item in the selected app.
The difference between the two views is that DES is built directly on the table with the, at that time, synchronized values.
DESLookups has built-in lookups for Optionset and related (and synced) tables. Due to the joins to other tables in DESLookups, performance is slower than in DES and it is recommended to limit the columns in queries to only the necessary ones.
Data example from account_DES view