When I connect to Snowflake database and expand the schema then expand "tables" or "views" in object explorer (using treelist), I want the list to be sorted alpha/numeric. It starts off fairly random and if I click the "Name" column, it appears to sort alpha/numeric but in groups. So maybe A-Z sorted for 30 tables, then A-Z for 35 tables, then A-Z for 20 tables, etc. This happens with all tables and views on a snowflake connection. Can someone help me understand why this is occurring and if I can do something to fix it?
Also if I open the tables up in "viewer tables" they are sorted A-Z correctly.
Thank you for bringing this to our attention. We're aware of the issue you're experiencing, and it has already been logged on Jira QAT-19295. Our development team is actively working on resolving issues and implementing new features to improve our tool and provide a better experience for all our users.
We appreciate your patience and understanding as we work to address this matter.
This is scheduled to be addressed in our Toad Data Point 6.4 release which will be out in October 2024
Great, I’ve been using a quick fix in the SQL Dictionary by adding an "Order by" to the appropriate locations but it's nice to know the issue is being fixed. Do you know if there would be any conflict without me removing what I have done?
EX:
SELECT {{Count(Start)}} TABLE_NAME, TABLE_SCHEMA {{Count(End)}} FROM {{Quote(:DatabaseName)}}.INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = {{Quote(:SchemaName)}} {{Filter}} Order by 1
Not sure if there would be a conflict - but I am bringing this up with our product owner so I am hoping she can test the new version with this.