Data Lake Compass queries
Data Lake Compass query functionality provides robust query capabilities to search and extract results from data stored in Data Lake.
Query functionality is available through the Compass UI in Data Fabric, the Infor OS Compass API endpoint, and the Compass JDBC driver.
There are two ways to open Compass in Data Fabric:
- Click the Query in the Data Lake link on the Home page
- In the navigation menu on the left side of the page, expand Data Lake and click .
For information on how to use the Compass query editor, see Compass.
The Compass APIs provide methods to submit queries, poll for status, and retrieve results.
The Compass JDBC driver may be set up with an SQL query tool. You can run queries through a local SQL query tool.
Using Data Lake query, you can query newline-delimited JSON objects and DSV objects that are stored in Data Lake. You can combine the JSON and DSV object data in queries using joins.