The INFORMATION_SCHEMA.CATALOGS view contains information about the catalog that contains the metadata of a project. This is the catalog in which the INFORMATION_SCHEMA resides. This view always contains a single row and returns DREMIO as the only catalog in the project.
SELECT * FROM INFORMATION_SCHEMA.CATALOGS
|DREMIO||The internal metadata used by Dremio||empty|
|CATALOG_NAME||varchar||The name of the catalog, which is always DREMIO.|
|CATALOG_DESCRIPTION||varchar||The description for the catalog that contains metadata.|
|CATALOG_CONNECT||varchar||The connection permissions to the catalog that contains metadata information. This is an inherited field and is always empty.|
Was this page helpful?
Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.