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?
