|
From: Tom V. <tom...@gm...> - 2021-05-20 22:49:54
|
Hi squirrel users! I'm trying to get my 4.2 squirrel to behave with the Snowflake cloud platform. I'm using their jdbc driver ( https://docs.snowflake.com/en/user-guide/jdbc-download.html#downloading-the-driver ). The driver configures OK and I can connect to a clients db authenticating via the browserbased SSO option (as described in their docs) However it looks like the metadata (particularly schemas) doesn't load correctly. The symptom is that I see all schemas of all databases as children under each database. e.g. db1 \ba \ba db2 \ba \ba where it should be db1 \ba db2 \ba this issue is replicated into tables etc.. Also, when trying to write some SQL squirrel pretty quickly hangs a long time. It seems to me this is related to the object cache not being build correctly from the metadata. Has anyone been able to correctly connect to a snowflake instance with multiple databases/schemas displaying ok? Happy to provide more info. regards Tom |
