samples catalog doesnt have an information schema

mx2323 — Tue, 17 Sep 2024 21:16:26 GMT

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?

Re: samples catalog doesnt have an information schema

Walter_C — Tue, 01 Oct 2024 15:02:16 GMT

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

topic samples catalog doesnt have an information schema in Administration & Architecture

samples catalog doesnt have an information schema

Re: samples catalog doesnt have an information schema