how to complete connection to snowflake

emanueol — Sat, 20 Dec 2025 16:53:34 GMT

Hi all,

Simple test creating connection to my snowflake trial account was successful, and..

Anyway:

dbx > external data > connections > create connection > ... > [Test] successful
but still see last 2 steps todo (5 access, 6 metadata) but don't see any button [next] to advance?
so I clicked dbx > catalog (accepted browser popup warning stuff still kissed to do) > external data > connections - "and i can see my connection is listed/got created.
i then clicked: [create catalog] , provided a catalog name and snowflake database name and it successfully retrieved schemas metadata.

Now in Sql Editor, i had to select a catalog + schema:

can i join data from different catalogs?
and 2nd thingy, tried execute a snowflake `show tables in schema db.s` but dbx sql editor returned invalid sql error. I would imagine it pushed down e ery SQL to snowflake since was the default catalog+schema selected on SQL editor? so seems sql dialect is constrained to dbx own sql dialect ? Does that even exists?

Re: how to complete connection to snowflake

szymon_dybczak — Sun, 21 Dec 2025 20:30:38 GMT

Hi @emanueol ,

From you description it seems that you were able to set up connection. Not every step in the wizard has "next button". From example in step 4 (catalog basic) if you create a catalog then you will be automatically transfered to the next step.

Regarding your other questions:

can i join data from different catalogs? - yes, you can join between 2 catalogs. Below is example when I'm joining tables from snowlake with a table that resides in Databricks Catalog:
and 2nd thingy, tried execute a snowflake `show tables in schema db.s` but dbx sql editor returned invalid sql error. - Query federation translates Databricks SQL statements into statements that can be pushed down into the federated data source. So you can't use here snowfake syntax. As a workaroudn, you can achieve the same thing using below query:

%sql SHOW TABLES IN snowflake_catalog.TPCDS_SF100TCL

topic Re: how to complete connection to snowflake in Administration & Architecture

how to complete connection to snowflake

Re: how to complete connection to snowflake