samples catalog doesnt have an information schema
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-17-2024 02:16 PM
we are looking to do an integration with databricks, and i've noticed that the samples database doesn't have an INFORMATION_SCHEMA
we rely on the existence of the information_schema to help us understand what views / tables exist in each catalog.
what is the samples catalog and why doesn't it have an information_schema? are there other situations where a catalog may not have an information_schema?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-01-2024 08:02 AM
The "samples" catalog in Databricks does not have an INFORMATION_SCHEMA
because it is designed primarily for demonstration and educational purposes, rather than for production use. This schema is typically included in catalogs created on Unity Catalog, which is intended for more comprehensive data management and governance.
There are other situations where a catalog may not have an INFORMATION_SCHEMA
. For example, catalogs that are not managed by Unity Catalog or those that are specifically designed for limited or specialized use cases might not include an INFORMATION_SCHEMA
. This can include catalogs that are part of legacy systems or those that are used for specific integrations where the metadata provided by INFORMATION_SCHEMA
is not necessary

