Data Lake System Table

When connecting via the Compass API, is there a Data Lake system table that contains the indexes for the Data Lake tables?

Find more posts tagged with

Infor Data Fabric

Accepted answers

unknown

Hey @jeffrey-henn ,

Compass has a schema called information_schema with the following tables available:

columns
schemata
tables
view_column_usage
view_table_usage
views

You can run queries against these tables regardless of the Compass interface (UI, API, JDBC) being used. For example:

SELECT * FROM information_schema.tables

The Compass SQL UI only shows tables & views found within your default schema so that reflects what you currently have in storage. However, you can see information_schema when loading up the Compass SQL JDBC driver in a SQL client (e.g. DBeaver).

All comments

unknown

Hey @jeffrey-henn ,

Compass has a schema called information_schema with the following tables available:

columns
schemata
tables
view_column_usage
view_table_usage
views

You can run queries against these tables regardless of the Compass interface (UI, API, JDBC) being used. For example:

SELECT * FROM information_schema.tables

Copyright © 2025 Infor. All rights reserved.