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

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now