Foreign catalog to Snowflake

emanueol
New Contributor III

While learning about Databricks foreign catalogsn (I'm on free tier DBX account), seems theres 2 ways creating foreign catalog to Snowflake:

  1. via CONNECTION type=snowflake, seems jdbc connection through where DBX pulls all metadata of 1 snowflake database. Additionally, by providing external location/paths on the CATALOG Basics DBX can directly access Snowflake Iceberg tables, falling back to jdbc if any issue with Iceberg tables, and jdbc default for all non-iceberg tables in Snowflake, and I think got this right (was able setting up this CONNECTION and FOREIGN CATALOG via DVX webUI.

Now, to create foreign catalog via Snowflake Horizon REST Iceberg API, I wonder how to achieve this:

  • Is it via a new type of entry type on new CONNECTION (something like Snowflake Horizon Rest Iceberg) ?
  • or is it same new CONNECTION type = "Snowflake", but then some sub option to distinguish between JDBC (query formation) vs Catalog Federation?

I need help, because as i don't see any "Snowflake Horizon" option or suboption anywhere in DBX webUI, Im wondering maybe trial/free DBX accounts CAN'T create foreign catalog against Snowflake Horizon REST Iceberg API ?

Thanks so much ~