|
From: Tom V. <tom...@gm...> - 2021-05-21 07:29:04
|
**update to below issue It seems that the problem can be fixed by adding an ALTER SESSION command in the Keep-alive section like so: -- https://docs.snowflake.com/en/sql-reference/parameters.html#client-metadata-request-use-connection-ctx alter session set CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX = true; (thanks to this article https://community.snowflake.com/s/article/Improve-Performance-of-JDBC-Metadata-Operations ) cheers Tom Op vr 21 mei 2021 om 00:49 schreef Tom Verweij <tom...@gm...>: > 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 > |
