how to complete connection to snowflake

emanueol
New Contributor III

‎12-20-2025 08:53 AM

Hi all,

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

Anyway:

  1. dbx > external data > connections > create connection > ... > [Test] successful 
  2. but still see last 2 steps todo (5 access, 6 metadata) but don't see any button [next] to advance?
  3. 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.
  4. 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? 
Labels:
0 Kudos

szymon_dybczak
Esteemed Contributor III

‎12-21-2025 12:29 PM - edited ‎12-21-2025 12:30 PM

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.

szymon_dybczak_0-1766347508915.png

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:

    szymon_dybczak_1-1766348817122.png

     

  •  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

 

 

View solution in original post