To Snowsight or Not To Snowsight - TAKE #2 - May 2022:Â
Back in October 2021, I published my original take on reasons why to move to Snowsight. It is in GA but based on my LinkedIn Polls and other DSH chatter, Snowsight is still not being embraced by many experienced Snowflake users it seems. I think if some of these changes below are made then users will begin to embrace the new interface!
| ORIGINAL POLL ON LINKEDIN:Â Â | MAY 2022 POLL ON LINKEDIN:Â |
|
|
|
| October 2021 102 Votes - Classic Console wins at 54% to 46% against Snowsight |
May 2022 53 Votes - Classic Console wins at 55% to 45% against Snowsight - 8 months later |
In my original Snowsight Article, I made a case that the new functionality in Snowsight makes it much better to use than the Classic Console Especially in these departments: Autosuggest/AutoComplete, Versioning, Sharing Worksheets, and Dashboards. These features take Snowflake's ease of use related to query and code collaboration to a much higher level of efficiency and collaboration.
All of that being said, I still see a huge resistance to using Snowsight in the Data Superhero (DSH) community and among experienced Snowflake Internal Sales Engineers. I guess part of the reason is that humans have a tough time with change. The other issue though is some MAJOR "inefficiencies" and "transparency" issues with Snowsight have been occurring in the last few months.
So, this grid below goes in-depth on the differences between Snowsight and Classic Console. In some cases, I consider that the Classic Console still outperforms Snowsight, but hopefully, the guys at Snowflake are working hard to improve these issues.
Snowflake versus Classic Console [May 2022]
| Web Interface Functionality | Classic Console | Snowsight | Comments |
| Show SQL based on GUI Form | WINNER | One of the great features of the Snowflake Classic Console was you could start creating just about any object in the GUI and then get the code syntax by using the Show SQL functionality. Why this was left out of Snowsight seems like a tragic miss. | |
| Create Procedure Example Listing Procedures |
WINNER | Classic Console doesn’t have this functionality. | |
| Create Function Example Listing Functions |
WINNER | Classic Console doesn’t have this functionality. | |
| Create Task Example Listing Tasks |
WINNER | Classic Console doesn’t have this functionality. | |
| Create Pipe Example Listing Pipes |
WINNER | Classic Console doesn’t have this functionality. | |
| Create Stage Example | WINNER | Classic Console doesn’t have this functionality. | |
| Create Table Example | WINNER | Classic Console doesn’t have this functionality. | |
| Create View Example | WINNER | Classic Console doesn’t have this functionality. | |
| Usage Reporting | WINNER | While Snowsight has many more screens and better reports, the fact that it has default misleading reports and bugs makes the Classic Console the winner here. | |
| Dependability | WINNER | Sadly, Snowsight still has weird bugs that happen all the time and you often come to a screen with an endless spinner. | |
| New Worksheet Navigation | WINNER | One nice new feature of Snowsight is you can open worksheets in new windows. This was not possible in the Classic Console. Also, you could not share links with others. | |
| Worksheet Sharing | WINNER | This is one of my favorite features of Snowsight. This is not possible within the Classic Console. | |
| Dashboards and Dashboard Sharing | WINNER | Dashboards are not in the Classic Console | |
| Auto-Complete | WINNER | This is another one of my favorite features of Snowsight. | |
| Executing highlighted code correctly | WINNER | Sadly, Snowsight often takes code above or below the highlighted code and tries to execute it which results in errors. It becomes annoying. | |
| Failure Reporting | WINNER | Sadly, Snowsight within the query history does a horrible job of surfacing the error while the Classic Console easily displays an error with 1 click. So so so much better and makes troubleshooting on Snowsight ... pretty much suck ... | |
Conclusion:
There you have it. This is just a highlight of features that I care about. Let me know what you think and what features you still love on the Classic Console work better there than on Snowsight.
