cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

samples catalog doesnt have an information schema

mx2323
New Contributor

 

we are looking to do an integration with databricks, and i've noticed that the samples database doesn't have an INFORMATION_SCHEMA 

mx2323_0-1726607557549.png

 

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

 

1 REPLY 1

Walter_C
Databricks Employee
Databricks Employee

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

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group