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 Compass.

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. If a query takes longer than 60 minutes a timeout occurs.

See Using Compass query APIs.

The Compass JDBC driver can 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 use joins to combine the JSON and DSV object data in queries.