Snowflake Usage Analysis

[Dalton_Ruer]

Download the latest and greatest version of the application from GitHub here:  https://github.com/Qlik-PE/Snowflake-Usage-Analysis-Dashboard

[Sue_Macaluso]

@Dalton_Ruer Thanks for sharing this!

[Enisgurel]

@Dalton_Ruer, Thanks for sharing!

[Dalton_Ruer]

@DavidFreriks and I interrupt your normal browsing session with the news that Version 5.0 of the Snowflake Usage Application is now available. 

The Qlik Sense Snowflake Usage Application - Version 5 now allows for much more focus on your Query Performance. Including the ability to call the latest Snowflake feature, the Query Stats Performance function featured on this Snowflake blog post https://www.snowflake.com/blog/new-approaches-visualizing-snowflake-query-statistics/.

Unlike Version 4 that required developers to understand QVD files, incremental loads and On Demand Application Generation features, Version 5 simply allows for a rolling X days and loads all of the data for the application live. So the only setup/configuration needed is to identify your own Snowflake tenant connections.

Version 5 can be downloaded from the same site as above for version 3. https://github.com/Qlik-PE/Snowflake-Usage-Analysis-Dashboard

Here is a demo of Version 5:

For those of you that really want to dig in, here is a how-to video that shows you code level insights to help you understand and configure Version 5 for your usage:

[Dalton_Ruer]

The dog ate my homework.

My wifi was down.

The email went to my spam folder.

Those are all excuses I wish I could use to explain why I posted information about Version 5 of the Snowflake Usage Application prior to posting information about Version 4. I think out of the box for sure, but I still count 1 - 2 - 3 - 4 -5 just like everyone else. 

@DavidFreriks  and I designed Version 4 of the Qlik Snowflake Usage Application with the big implementations in mind. Incremental loads are used for the tables so that you can keep accumulating massive history without the cost/time of having to read it all live. All of the query history is retained and saved to QVD for use in a specific Query Analysis application, but only the aggregates are retained in the main application. Thus, allowing very nimble responses and yet providing an easy to link to the details when anyone wants to analyze them. For cost tracking we provided a way for you to map Users to Cost Centers. 

This link will take you directly to the Version 4 download files on our Qlik Partner Engineering GitHub repository:  https://github.com/Qlik-PE/Snowflake-Usage-Analysis-Dashboard/tree/master/releases/Version4 

We worked hard on Version 4. It's the real deal. It certainly deserved being documented but the sun was in my eyes.