adhi_databricks
Contributor

Hey @Alberto_Umana 

In Databricks, the structure is: Catalog -> Schema -> Tables,

while in Snowflake it is: Database -> Schema -> Tables.

The foreign_catalog in Databricks mirrors the Snowflake database, correct? For example, if one Snowflake account contains 10 databases, I would need to create 10 foreign catalogs in Databricks to reflect those Snowflake tables, as outlined in the documentation.

I would like to know how I can create these databases under a single foreign catalog. Additionally, if this is possible, how do I query the Snowflake tables from within Databricks?