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.
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 . This action will not remove any data. A command will be added to the edit
window (exec infor.clear_table). Click the button.