Using the Compass application page
Compass is a Data Fabric tool for querying the contents of Data Lake for data analysis and exploration, ad-hoc data exports, data management, and troubleshooting.
You can start Compass in the Data Fabric application in these ways:
- Click the Query the Data Lake link on the Home page
- In the navigation menu, select .
Note: The Compass page is not available in Infor Government Solutions.
In Compass, you can run these tasks:
- Write and run SQL queries
- Create views on your data objects stored in Data Lake
- Export data
- Explore data objects and properties
- Execute administrative tasks within Data Lake
Compass offers these elements and functionality:
- Multi-tabbed query development with up to 10 concurrent tabs.
- Data Objects and Views Panel - for exploring Data Catalog objects and views.
- Ability to search and filter the data objects and data object properties
- Generate contextual SQL statements and SQL hints to influence data retrieval behaviors
- Generate contextual administrative SQL code for managing and troubleshooting data in Data Lake
- Query Editor - for writing SELECT statements and running them.
- Syntax highlighting
- Contextual auto-suggest for SQL keywords, custom keywords, and data object and data object property names
- SQL formatting
- Font size controls
- Results Panel - for previewing the query results
- Success and error messages
- Result set in a data grid
- Exporting a result set
With Compass editor you can write simple or advanced SQL SELECT statements and run them to retrieve data.
These supported SQL statements are available:
- SELECT statements
- Standard SQL dialect
SQL Comments are supported within a statement.
For Data Lake, these additional options exist:
- SELECT statement with Infor-supported functions for handling variations, deleted objects, and archived objects
- Admin statements to manage the formatted Data Lake objects.
- CREATE, ALTER, and DROP statements for views.