Hi @adhi_databricks,

You are right about foreign_catalogs. Please note that It is not possible to create multiple Snowflake databases under a single foreign catalog in Databricks directly. Each Snowflake database needs a separate foreign catalog to mirror the structure.

1. Create a foreign catalog for each Snowflake database.
2. Use the appropriate connectors and settings to establish connection and query the tables.

-- Example to query Snowflake table from Databricks
SELECT * FROM foreign_catalog_name.schema_name.table_name;