SQL Workbench DBTree retrieval very slow (Snowflake)
31 views
Skip to first unread message
Akash Nath
Jul 6, 2021, 12:35:00 PM7/6/21
to SQL Workbench/J - DBMS independent SQL tool
Hi, I am using SQL Workbench Build 127 to connect to Snowflake warehouse and when I explan to get the list of tables in DB Treee - its retriving from last 20 mins. This is the case when I use DB Explorer.
I agree the there are lots of tables under a specific schema in this warehouse. How could I speed up the performance?
I have checked AutoCommit, Remember DBExplorerSchema, StoreCompletion Cache locally,
The application works well when I use it to connect Amazon Redshift or Oracle.
Akash Nath
Jul 7, 2021, 12:33:49 PM7/7/21
to SQL Workbench/J - DBMS independent SQL tool
Attaching log. I have masked my user name and snowflake account id in the url.
Please advise - I have spent hours trying to make it work. I have also tried snowflake extended properties CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX = True. Reference: https://docs.snowflake.com/en/sql-reference/parameters.html#client-metadata-use-session-database
2021-07-07 21:05:09 INFO =================== Log started ===================
2021-07-07 21:05:09 INFO Settings.initialize() Using configdir: C:\Users\aknx\.sqlworkbench
2021-07-07 21:05:09 DEBUG Settings.initialize() Using default xstlDir: C:\Users\aknx\Documents\SQL Workbench\xslt
2021-07-07 21:05:09 DEBUG Settings.initialize() Last modification time of loaded config file: 1625672105458
2021-07-07 21:05:09 INFO ResourceMgr.getResources() Setting default locale to: en
2021-07-07 21:05:09 INFO WbManager.readParameters() Starting SQL Workbench/J, Build 127 (2020-08-22 22:34)
2021-07-07 21:05:09 INFO WbManager.readParameters() Java version=11.0.6, java.home=C:\Program Files\Java\jdk-11.0.6, vendor=Oracle Corporation, name=Java HotSpot(TM) 64-Bit Server VM
2021-07-07 21:05:09 INFO WbManager.readParameters() Operating System=Windows 10, version=10.0, platform=amd64
2021-07-07 21:05:09 INFO WbManager.readParameters() Available memory: 10558MB
2021-07-07 21:05:09 INFO WbManager.readParameters() Classpath: C:\Users\aknx\Documents\SQL Workbench\sqlworkbench.jar;C:\Users\aknx\Documents\SQL Workbench\ext\commons-codec.jar;C:\Users\aknx\Documents\SQL Workbench\ext\commons-collections4.jar;C:\Users\aknx\Documents\SQL Workbench\ext\commons-compress.jar;C:\Users\aknx\Documents\SQL Workbench\ext\flatlaf.jar;C:\Users\aknx\Documents\SQL Workbench\ext\jna-platform.jar;C:\Users\aknx\Documents\SQL Workbench\ext\jna.jar;C:\Users\aknx\Documents\SQL Workbench\ext\odfdom-java.jar;C:\Users\aknx\Documents\SQL Workbench\ext\poi-ooxml-schemas.jar;C:\Users\aknx\Documents\SQL Workbench\ext\poi-ooxml.jar;C:\Users\aknx\Documents\SQL Workbench\ext\poi.jar;C:\Users\aknx\Documents\SQL Workbench\ext\resolver.jar;C:\Users\aknx\Documents\SQL Workbench\ext\serializer.jar;C:\Users\aknx\Documents\SQL Workbench\ext\simple-odf.jar;C:\Users\aknx\Documents\SQL Workbench\ext\xercesImpl.jar;C:\Users\aknx\Documents\SQL Workbench\ext\xml-apis.jar;C:\Users\aknx\Documents\SQL Workbench\ext\xmlbeans.jar
2021-07-07 21:05:09 INFO CommandRegistry.scanForExtensions() Found 0 commands in 9ms
2021-07-07 21:05:09 DEBUG LnFManager.getLnFList() Found Look & Feel: Dracula, class: com.bulenkov.darcula.DarculaLaf, type: dynamic
2021-07-07 21:05:09 DEBUG LnFManager.getLnFList() Found Look & Feel: FlatLaf Dark, class: com.formdev.flatlaf.FlatDarkLaf, type: ext
2021-07-07 21:05:09 DEBUG LnFManager.getLnFList() Found Look & Feel: FlatLaf Light, class: com.formdev.flatlaf.FlatLightLaf, type: ext
2021-07-07 21:05:09 DEBUG LnFManager.getLnFList() Checking look & feels took: 62ms
2021-07-07 21:05:09 DEBUG MacroStorage.loadMacros() Macro file C:\Users\aknx\.sqlworkbench\WbMacros.xml not found. No Macros loaded
2021-07-07 21:05:09 DEBUG MacroManager.<init> Loading default macros took 4ms
2021-07-07 21:05:09 INFO IconMgr.<init> Using sizes: toolbar: 16, menu: 16
2021-07-07 21:05:09 DEBUG Settings.restoreWindowPosition() Restoring window position for 'workbench.gui.MainWindow', current screen size: [x: 0, y: 0, w:1376,h:774], requested position: [x: -6, y: 0, w:1032,h:774]
2021-07-07 21:05:10 INFO PoiHelper.isPoiAvailable() POI version: 4.1.0 available
2021-07-07 21:05:10 DEBUG DbUnitHelper.isDbUnitAvailable() DbUnit not available
2021-07-07 21:05:11 DEBUG BookmarkManager.lambda$updateInBackground$4() Panel 'Statement' was updated in 3ms (0 bookmarks)
2021-07-07 21:05:11 DEBUG ClasspathUtil.checkLibsToMove() Checking directory: C:\Users\aknx\Documents\SQL Workbench for additional libraries
2021-07-07 21:05:11 INFO ClasspathUtil.checkLibsToMove() Checking for ext libs took: 10ms
2021-07-07 21:05:11 DEBUG IniProfileStorage.readProfiles() Loading connection profiles from C:\Users\aknx\.sqlworkbench\wb-profiles.properties
2021-07-07 21:05:11 INFO IniProfileStorage.readProfiles() Loaded 7 connection profiles from C:\Users\aknx\.sqlworkbench\wb-profiles.properties
2021-07-07 21:05:11 DEBUG ProfileManager.readFile() 7 profiles loaded from C:\Users\aknx\.sqlworkbench\wb-profiles.properties in 13ms
2021-07-07 21:05:11 INFO ProfileManager.readProfiles() 7 profiles loaded in 19ms from 1 files
2021-07-07 21:05:14 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\wb-profiles.properties" took 11ms
2021-07-07 21:05:14 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\wb-profiles.properties.5" as a backup of "C:\Users\aknx\.sqlworkbench\wb-profiles.properties" in 33ms
2021-07-07 21:05:14 DEBUG IniProfileStorage.saveProfiles() Saving profiles to: C:\Users\aknx\.sqlworkbench\wb-profiles.properties
2021-07-07 21:05:14 DEBUG IniProfileStorage.saveProfiles() Saved 7 profiles to C:\Users\aknx\.sqlworkbench\wb-profiles.properties in 6ms
2021-07-07 21:05:14 DEBUG MacroStorage.loadMacros() Macro file C:\Users\aknx\.sqlworkbench\WbMacros.xml not found. No Macros loaded
2021-07-07 21:05:14 DEBUG MacroManager.loadMacros() Loaded 0 macros from file C:\Users\aknx\.sqlworkbench\WbMacros.xml for clientId: 1
2021-07-07 21:05:14 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1
2021-07-07 21:05:14 DEBUG SqlPanel.readFromWorkspace() Restoring panel 1 from workspace C:\Users\aknx\.sqlworkbench\Default.wksp took 13ms
2021-07-07 21:05:14 DEBUG MainWindow.loadWorkspace() Loading workspace C:\Users\aknx\.sqlworkbench\Default.wksp took 392ms
2021-07-07 21:05:14 DEBUG BookmarkManager.updateBookmarks() Parsing bookmarks for 2 tabs took: 13ms
2021-07-07 21:05:14 DEBUG TreeLoader.setSelectedTypes() Selected object types: [TABLE]
2021-07-07 21:05:14 INFO ConnectionMgr.getConnection() Creating new connection for "{Default group}/SF-CDW-RO": [user=
xx...@xxxxxx.com, url=jdbc:snowflake://xxx.snowflakecomputing.com/?authenticator=externalbrowser&role=NNI_SNFK_READER_PROD&db=CDW_PROD&warehouse=WH_S_READERS_PROD, driverClass=net.snowflake.client.jdbc.SnowflakeDriver, driverName=Snowflake]
2021-07-07 21:05:14 INFO DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Program%20Files%20(x86)/Java/jre1.8.0_261/lib/snowflake-jdbc-3.13.1.jar
2021-07-07 21:05:20 DEBUG DbMetadata.<init> WbWin-1: Schema term: schema
2021-07-07 21:05:20 DEBUG DbMetadata.<init> WbWin-1: Catalog term: database
2021-07-07 21:05:20 DEBUG DbMetadata.<init> WbWin-1: Identifier quote character obtained from driver: "
2021-07-07 21:05:20 INFO DbMetadata.<init> WbWin-1: Using DBID=snowflake
2021-07-07 21:05:20 INFO DbMetadata.<init> WbWin-1: Using identifier quote character: "
2021-07-07 21:05:20 INFO DbMetadata.<init> WbWin-1: Using search string escape character: \
2021-07-07 21:05:20 INFO DbMetadata.retrieveObjectTypes() WbWin-1: Table types returned by the JDBC driver: [TABLE, VIEW]
2021-07-07 21:05:20 INFO DbMetadata.<init> WbWin-1: Using catalog separator: .
2021-07-07 21:05:20 DEBUG GenericSchemaInfoReader.logSettings() WbWin-1: Re-Use statement: false, cache current schema: false, SQL: null
2021-07-07 21:05:20 DEBUG GenericCatalogInformationReader.<init> WbWin-1: Cache current schema: false
2021-07-07 21:05:20 INFO ConnectionMgr.getConnection() Connected to: [Snowflake], Database version info: [5.25.0], Database version number: [5.25], Driver version: [3.13.1], JDBC version: [1.0], ID: [WbWin-1]
2021-07-07 21:05:20 DEBUG ConnectionInfo.updateDBSwitcher() Removing DB switcher for: WbWin-1,
xx...@xxxxxx.com@jdbc:snowflake://xxx.snowflakecomputing.com/?authenticator=externalbrowser&role=NNI_SNFK_READER_PROD&db=CDW_PROD&warehouse=WH_S_READERS_PROD
2021-07-07 21:05:20 DEBUG ConnectionInfo.updateDBSwitcher() Removing DB switcher for: WbWin-1,
xx...@xxxxxx.com@jdbc:snowflake://xxx.snowflakecomputing.com/?authenticator=externalbrowser&role=NNI_SNFK_READER_PROD&db=CDW_PROD&warehouse=WH_S_READERS_PROD
2021-07-07 21:05:20 DEBUG DbTreePanel.setConnectionToUse() Using connection WbWin-1,
xx...@xxxxxx.com@jdbc:snowflake://xxx.snowflakecomputing.com/?authenticator=externalbrowser&role=NNI_SNFK_READER_PROD&db=CDW_PROD&warehouse=WH_S_READERS_PROD for DbTree
2021-07-07 21:05:20 DEBUG TreeLoader.setConnection() Using object types: [TABLE, VIEW]
2021-07-07 21:05:20 DEBUG DbTreePanel.loadTypes() Using the following object types for the type filter: [TABLE, VIEW]
2021-07-07 21:05:20 DEBUG DbMetadata.getCatalogInformation() WbWin-1: Retrieving 7 catalogs using getCatalogs() took: 480ms
2021-07-07 21:05:20 DEBUG TreeLoader.loadSchemas() Loading schemas for catalog: CDW_PROD
2021-07-07 21:05:22 DEBUG DbMetadata.getSchemas() WbWin-1: Retrieving 12 schemas using getSchemas() took 1236ms
2021-07-07 21:05:22 DEBUG TreeLoader.loadSchemas() Loaded 12 schemas. Currently selected types: [TABLE]
2021-07-07 21:05:35 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\Default.wksp" took 14ms
2021-07-07 21:05:35 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\Default.wksp.5" as a backup of "C:\Users\aknx\.sqlworkbench\Default.wksp" in 19ms
2021-07-07 21:05:35 DEBUG MainWindow._doSaveWorkspace() Workspace C:\Users\aknx\.sqlworkbench\Default.wksp saved in 30ms
2021-07-07 21:05:50 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\Default.wksp" took 13ms
2021-07-07 21:05:50 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\Default.wksp.5" as a backup of "C:\Users\aknx\.sqlworkbench\Default.wksp" in 20ms
2021-07-07 21:05:50 DEBUG MainWindow._doSaveWorkspace() Workspace C:\Users\aknx\.sqlworkbench\Default.wksp saved in 32ms
2021-07-07 21:10:53 INFO DataStore.initData() Retrieve cancelled
2021-07-07 21:11:04 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\Default.wksp" took 10ms
2021-07-07 21:11:04 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\Default.wksp.5" as a backup of "C:\Users\aknx\.sqlworkbench\Default.wksp" in 14ms
2021-07-07 21:11:04 DEBUG MainWindow._doSaveWorkspace() Workspace C:\Users\aknx\.sqlworkbench\Default.wksp saved in 22ms
2021-07-07 21:11:22 INFO DataStore.initData() Retrieve cancelled
2021-07-07 21:11:44 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\Default.wksp" took 9ms
2021-07-07 21:11:44 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\Default.wksp.5" as a backup of "C:\Users\aknx\.sqlworkbench\Default.wksp" in 14ms
2021-07-07 21:11:44 DEBUG MainWindow._doSaveWorkspace() Workspace C:\Users\aknx\.sqlworkbench\Default.wksp saved in 22ms
2021-07-07 21:11:52 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\Default.wksp" took 10ms
2021-07-07 21:11:52 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\Default.wksp.5" as a backup of "C:\Users\aknx\.sqlworkbench\Default.wksp" in 16ms
2021-07-07 21:11:52 DEBUG MainWindow._doSaveWorkspace() Workspace C:\Users\aknx\.sqlworkbench\Default.wksp saved in 24ms
2021-07-07 21:12:00 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\Default.wksp" took 13ms
2021-07-07 21:12:00 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\Default.wksp.5" as a backup of "C:\Users\aknx\.sqlworkbench\Default.wksp" in 18ms
2021-07-07 21:12:00 DEBUG MainWindow._doSaveWorkspace() Workspace C:\Users\aknx\.sqlworkbench\Default.wksp saved in 34ms
2021-07-07 21:12:24 INFO DataStore.initData() Retrieve cancelled
2021-07-07 21:12:58 DEBUG DbMetadata.getObjects() WbWin-1: Retrieving table list took: 1769ms
2021-07-07 21:23:43 DEBUG FileDisconnectAction.executeAction() Initiating disconnect.
2021-07-07 21:23:43 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\Default.wksp" took 14ms
2021-07-07 21:23:43 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\Default.wksp.5" as a backup of "C:\Users\aknx\.sqlworkbench\Default.wksp" in 20ms
2021-07-07 21:23:43 DEBUG MainWindow._doSaveWorkspace() Workspace C:\Users\aknx\.sqlworkbench\Default.wksp saved in 27ms
2021-07-07 21:23:43 DEBUG ConnectionMgr.disconnect() Trying to physically close the connection with id=WbWin-1
2021-07-07 21:23:43 INFO ConnectionMgr.closeConnection() Disconnecting: [SF-CDW-RO], ID=WbWin-1
2021-07-07 21:23:48 DEBUG WbConnection.shutdown() Connection WbWin-1 closed.
2021-07-07 21:23:48 DEBUG ConnectionMgr.closeConnection() Disconnecting connection with ID=WbWin-1,
xx...@xxxxxx.com@jdbc:snowflake://xxx.snowflakecomputing.com/?authenticator=externalbrowser&role=NNI_SNFK_READER_PROD&db=CDW_PROD&warehouse=WH_S_READERS_PROD took 4897ms
2021-07-07 21:23:48 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1
2021-07-07 21:23:48 DEBUG BookmarkManager.lambda$updateInBackground$4() Panel 'Statement' was updated in 0ms (0 bookmarks)
2021-07-07 21:24:46 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\wb-profiles.properties" took 13ms
2021-07-07 21:24:46 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\wb-profiles.properties.5" as a backup of "C:\Users\aknx\.sqlworkbench\wb-profiles.properties" in 19ms
2021-07-07 21:24:46 DEBUG IniProfileStorage.saveProfiles() Saving profiles to: C:\Users\aknx\.sqlworkbench\wb-profiles.properties
2021-07-07 21:24:46 DEBUG IniProfileStorage.saveProfiles() Saved 7 profiles to C:\Users\aknx\.sqlworkbench\wb-profiles.properties in 3ms
2021-07-07 21:24:46 DEBUG MacroStorage.loadMacros() Macro file C:\Users\aknx\.sqlworkbench\WbMacros.xml not found. No Macros loaded
2021-07-07 21:24:46 DEBUG MacroManager.loadMacros() Loaded 0 macros from file C:\Users\aknx\.sqlworkbench\WbMacros.xml for clientId: 1
2021-07-07 21:24:46 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1
2021-07-07 21:24:46 DEBUG SqlPanel.readFromWorkspace() Restoring panel 1 from workspace C:\Users\aknx\.sqlworkbench\Default.wksp took 1ms
2021-07-07 21:24:46 DEBUG MainWindow.loadWorkspace() Loading workspace C:\Users\aknx\.sqlworkbench\Default.wksp took 123ms
2021-07-07 21:24:46 DEBUG BookmarkManager.updateBookmarks() Parsing bookmarks for 2 tabs took: 0ms
2021-07-07 21:24:46 DEBUG TreeLoader.setSelectedTypes() Selected object types: [TABLE]
2021-07-07 21:24:46 INFO ConnectionMgr.getConnection() Creating new connection for "{Default group}/SF-CDW-RO": [user=
xx...@xxxxxx.com, url=jdbc:snowflake://xxx.snowflakecomputing.com/?authenticator=externalbrowser&role=NNI_SNFK_READER_PROD&db=CDW_PROD&warehouse=WH_S_READERS_PROD, driverClass=net.snowflake.client.jdbc.SnowflakeDriver, driverName=Snowflake]
2021-07-07 21:24:48 DEBUG DbMetadata.<init> WbWin-1: Schema term: schema
2021-07-07 21:24:48 DEBUG DbMetadata.<init> WbWin-1: Catalog term: database
2021-07-07 21:24:48 DEBUG DbMetadata.<init> WbWin-1: Identifier quote character obtained from driver: "
2021-07-07 21:24:48 INFO DbMetadata.<init> WbWin-1: Using DBID=snowflake
2021-07-07 21:24:48 INFO DbMetadata.<init> WbWin-1: Using identifier quote character: "
2021-07-07 21:24:48 INFO DbMetadata.<init> WbWin-1: Using search string escape character: \
2021-07-07 21:24:48 INFO DbMetadata.retrieveObjectTypes() WbWin-1: Table types returned by the JDBC driver: [TABLE, VIEW]
2021-07-07 21:24:48 INFO DbMetadata.<init> WbWin-1: Using catalog separator: .
2021-07-07 21:24:48 DEBUG GenericSchemaInfoReader.logSettings() WbWin-1: Re-Use statement: false, cache current schema: false, SQL: null
2021-07-07 21:24:48 DEBUG GenericCatalogInformationReader.<init> WbWin-1: Cache current schema: false
2021-07-07 21:24:48 INFO ConnectionMgr.getConnection() Connected to: [Snowflake], Database version info: [5.25.0], Database version number: [5.25], Driver version: [3.13.1], JDBC version: [1.0], ID: [WbWin-1]
2021-07-07 21:24:48 DEBUG ConnectionInfo.updateDBSwitcher() Removing DB switcher for: WbWin-1,
xx...@xxxxxx.com@jdbc:snowflake://xxx.snowflakecomputing.com/?authenticator=externalbrowser&role=NNI_SNFK_READER_PROD&db=CDW_PROD&warehouse=WH_S_READERS_PROD
2021-07-07 21:24:48 DEBUG ConnectionInfo.updateDBSwitcher() Removing DB switcher for: WbWin-1,
xx...@xxxxxx.com@jdbc:snowflake://xxx.snowflakecomputing.com/?authenticator=externalbrowser&role=NNI_SNFK_READER_PROD&db=CDW_PROD&warehouse=WH_S_READERS_PROD
2021-07-07 21:24:48 DEBUG DbTreePanel.setConnectionToUse() Using connection WbWin-1,
xx...@xxxxxx.com@jdbc:snowflake://xx.snowflakecomputing.com/?authenticator=externalbrowser&role=NNI_SNFK_READER_PROD&db=CDW_PROD&warehouse=WH_S_READERS_PROD for DbTree
2021-07-07 21:24:48 DEBUG TreeLoader.setConnection() Using object types: [TABLE, VIEW]
2021-07-07 21:24:48 DEBUG DbTreePanel.loadTypes() Using the following object types for the type filter: [TABLE, VIEW]
2021-07-07 21:24:48 DEBUG DbMetadata.getCatalogInformation() WbWin-1: Retrieving 7 catalogs using getCatalogs() took: 355ms
2021-07-07 21:24:48 DEBUG TreeLoader.loadSchemas() Loading schemas for catalog: CDW_PROD
2021-07-07 21:24:49 DEBUG DbMetadata.getSchemas() WbWin-1: Retrieving 12 schemas using getSchemas() took 1211ms
2021-07-07 21:24:49 DEBUG TreeLoader.loadSchemas() Loaded 12 schemas. Currently selected types: [TABLE]
2021-07-07 21:25:02 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\Default.wksp" took 20ms
2021-07-07 21:25:02 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\Default.wksp.5" as a backup of "C:\Users\aknx\.sqlworkbench\Default.wksp" in 26ms
2021-07-07 21:25:02 DEBUG MainWindow._doSaveWorkspace() Workspace C:\Users\aknx\.sqlworkbench\Default.wksp saved in 34ms
2021-07-07 21:26:37 INFO DataStore.initData() Retrieve cancelled
2021-07-07 21:26:49 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\Default.wksp" took 9ms
2021-07-07 21:26:49 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\Default.wksp.5" as a backup of "C:\Users\aknx\.sqlworkbench\Default.wksp" in 13ms
2021-07-07 21:26:50 DEBUG MainWindow._doSaveWorkspace() Workspace C:\Users\aknx\.sqlworkbench\Default.wksp saved in 20ms
2021-07-07 21:28:15 DEBUG MainWindow.windowClosing() Main window closing
2021-07-07 21:28:15 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\Users\aknx\.sqlworkbench\Default.wksp" took 27ms
2021-07-07 21:28:15 DEBUG FileVersioner.createBackup() Created file "C:\Users\aknx\.sqlworkbench\Default.wksp.5" as a backup of "C:\Users\aknx\.sqlworkbench\Default.wksp" in 35ms
2021-07-07 21:28:15 DEBUG MainWindow._doSaveWorkspace() Workspace C:\Users\aknx\.sqlworkbench\Default.wksp saved in 41ms
2021-07-07 21:28:15 DEBUG MacroStorage.saveMacros() No macros defined, nothing to save
2021-07-07 21:28:15 DEBUG ConnectionMgr.disconnect() Trying to physically close the connection with id=WbWin-1
2021-07-07 21:28:15 INFO ConnectionMgr.closeConnection() Disconnecting: [SF-CDW-RO], ID=WbWin-1
2021-07-07 21:28:16 DEBUG WbConnection.shutdown() Connection WbWin-1 closed.
2021-07-07 21:28:16 DEBUG ConnectionMgr.closeConnection() Disconnecting connection with ID=WbWin-1, xx...@xxxxxx.com@jdbc:snowflake://xxx.snowflakecomputing.com/?authenticator=externalbrowser&role=NNI_SNFK_READER_PROD&db=CDW_PROD&warehouse=WH_S_READERS_PROD took 1203ms
2021-07-07 21:28:16 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1
2021-07-07 21:28:16 DEBUG BookmarkManager.lambda$updateInBackground$4() Panel 'Statement' was updated in 0ms (0 bookmarks)
2021-07-07 21:28:16 DEBUG WbManager.closeAllWindows() Closing all open windows
2021-07-07 21:28:16 DEBUG Settings.saveSettings() Saving global settings to: C:\Users\aknx\.sqlworkbench\workbench.settings
2021-07-07 21:28:16 INFO WbManager.doShutdown() Stopping SQL Workbench/J, Build 127
2021-07-07 21:28:16 INFO =================== Log stopped ===================
Thomas Kellerer
Jul 12, 2021, 7:36:19 AM7/12/21
to sql-wo...@googlegroups.com
According to the log file retrieving catalogs, schemas and tables took 3485ms (=3.5 seconds) so that's quite a difference to 20 minutes.
Akash Nath schrieb am 07.07.2021 um 18:33:
> Hi, I am using SQL Workbench Build 127 to connect to Snowflake warehouse and when I explan to get the list of tables in DB Treee - its retriving from last 20 mins.
>> Attaching log. I have masked my user name and snowflake account id in the url.> > Please advise - I have spent hours trying to make it work. I have also tried snowflake extended properties CLIENT_METADATA_REQUEST_USE_CONNECTION_CT <https://docs.snowflake.com/en/sql-reference/parameters.html#label-client-metadata-request-use-connection-ctx>X = True. Reference: https://docs.snowflake.com/en/sql-reference/parameters.html#client-metadata-use-session-database
Akash Nath schrieb am 07.07.2021 um 18:33:
> Hi, I am using SQL Workbench Build 127 to connect to Snowflake warehouse and when I explan to get the list of tables in DB Treee - its retriving from last 20 mins.
>
> 2021-07-07 21:05:14 DEBUG TreeLoader.setSelectedTypes() Selected object types: [TABLE]
> 2021-07-07 21:05:14 DEBUG TreeLoader.setSelectedTypes() Selected object types: [TABLE]
> 2021-07-07 21:05:20 INFO DbMetadata.retrieveObjectTypes() WbWin-1: Table types returned by the JDBC driver: [TABLE, VIEW]
> 2021-07-07 21:05:20 DEBUG TreeLoader.setConnection() Using object types: [TABLE, VIEW]
> 2021-07-07 21:05:20 DEBUG DbMetadata.getCatalogInformation() WbWin-1: Retrieving 7 catalogs using getCatalogs() took: 480ms
> 2021-07-07 21:05:20 DEBUG TreeLoader.loadSchemas() Loading schemas for catalog: CDW_PROD
> 2021-07-07 21:05:22 DEBUG DbMetadata.getSchemas() WbWin-1: Retrieving 12 schemas using getSchemas() took 1236ms
> 2021-07-07 21:05:22 DEBUG TreeLoader.loadSchemas() Loaded 12 schemas. Currently selected types: [TABLE]
> 2021-07-07 21:05:20 DEBUG TreeLoader.loadSchemas() Loading schemas for catalog: CDW_PROD
> 2021-07-07 21:05:22 DEBUG DbMetadata.getSchemas() WbWin-1: Retrieving 12 schemas using getSchemas() took 1236ms
> 2021-07-07 21:05:22 DEBUG TreeLoader.loadSchemas() Loaded 12 schemas. Currently selected types: [TABLE]
Reply all
Reply to author
Forward
0 new messages