how to complete connection to snowflake

[emanueol]

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? 

[szymon_dybczak]

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