Accessing Compass

Compass is an editor to query the Data Lake. It is available in ION Desk and can be used to check the Data Lake contents through ad-hoc queries and try queries. Compass contains an edit window where you can type queries. Also, context menus are available for generating queries.compass

Note: When new columns are added to an existing schema, when a custom field is added or because there is a new release of Optiva with data schema changes, the table must be reformatted in Compass or querying the table will cause an error. To reformat the table in Compass, right-click on the table and select Admin > Clear Table > Remove Formatted Data (True). This action will not remove any data. A command will be added to the edit window (exec infor.clear_table). Click the Run Query button.
compass_2