DataLakeHouse.io Snowflake Usage Analytics Boasts a 300% Increase in Visibility

<p>Without a doubt capturing details about your Snowflake account and usage is important.  It might be one of the most important explorations you make in your organization’s Snowflake architecture, aside from the data and analytics workloads which make your company, team, and Snowflake account special.   So what if we told you that we’ve built and maintained a highly useful product usage and analysis tool for any Snowflake customer to explore details and analytical trending regarding how their Snowflake environment is being used, by whom, and how to optimize for better performance outcomes where possible? Well, we’ve actually done just…</p>

<div data-elementor-type="wp-post" data-elementor-id="15017" class="elementor elementor-15017" data-elementor-post-type="blog"> <section class="elementor-section elementor-top-section elementor-element elementor-element-e6b154c elementor-section-boxed elementor-section-height-default elementor-section-height-default" data-id="e6b154c" data-element_type="section"> <div class="elementor-container elementor-column-gap-default"> <div class="elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2507fd3" data-id="2507fd3" data-element_type="column"> <div class="elementor-widget-wrap elementor-element-populated"> <div class="elementor-element elementor-element-5055a03 elementor-widget elementor-widget-text-editor" data-id="5055a03" data-element_type="widget" data-widget_type="text-editor.default"> <div class="elementor-widget-container"> <p><span style="font-weight: 400;">Without a doubt capturing details about your </span><a href="https://trial.snowflake.com/?owner=SPN-PID-126628" target="_blank" rel="noopener"><span style="font-weight: 400;">Snowflake</span></a><span style="font-weight: 400;"> account and usage is important.  It might be one of the most important explorations you make in your organization’s Snowflake architecture, aside from the data and analytics workloads which make your company, team, and Snowflake account special.</span></p><p> </p><p><span style="font-weight: 400;">So what if we told you that we’ve built and maintained a highly useful product usage and analysis tool for any </span><a href="https://www.snowflake.com/en/" target="_blank" rel="noopener"><span style="font-weight: 400;">Snowflake</span></a><span style="font-weight: 400;"> customer to explore details and analytical trending regarding how their Snowflake environment is being used, by whom, and </span><a href="https://www.datalakehouse.io/resources/blog/snowflake-usage-analytics-the-key-to-efficient-data-warehousing/"><span style="font-weight: 400;">how to optimize</span></a><span style="font-weight: 400;"> for better performance outcomes where possible? Well, we’ve actually done just that!</span></p><p> </p><p><b>How to Increase Visibility into your Snowflake Account by 300%</b></p> </div> </div> <div class="elementor-element elementor-element-1170ece elementor-widget elementor-widget-image" data-id="1170ece" data-element_type="widget" data-widget_type="image.default"> <div class="elementor-widget-container"> <img loading="lazy" decoding="async" width="720" height="480" src="https://public-cdn.dlh.io/migrated/uploads/2023/04/Snowflake-Usage-in-Snowsight-.png" class="attachment-large size-large wp-image-15019" alt="Snowflake usage dashboard in Snowsight" srcset="https://www.datalakehouse.io/wp-content/uploads/2023/04/Snowflake-Usage-in-Snowsight-.png 720w, https://www.datalakehouse.io/wp-content/uploads/2023/04/Snowflake-Usage-in-Snowsight--300x200.png 300w" sizes="(max-width: 720px) 100vw, 720px" /> </div> </div> <div class="elementor-element elementor-element-3190235 elementor-widget elementor-widget-text-editor" data-id="3190235" data-element_type="widget" data-widget_type="text-editor.default"> <div class="elementor-widget-container"> <p><span style="font-weight: 400;">The Snowsight UI provides basic output and graphing capabilities, which is a nice alternative to the legacy interface. Snowflake will obviously continue to build on this UI platform, but we think their time will be better spent working on new features versus trying to figure out how to display forensic details for all their individual customers.</span></p><p> </p><p><span style="font-weight: 400;">There’s also your other high-level visibility feature coverage, which you come to expect from any platform, like these Warehouse monitoring details:</span></p> </div> </div> <div class="elementor-element elementor-element-2a8c58e elementor-widget elementor-widget-image" data-id="2a8c58e" data-element_type="widget" data-widget_type="image.default"> <div class="elementor-widget-container"> <img loading="lazy" decoding="async" width="720" height="480" src="https://www.datalakehouse.io/wp-content/uploads/2023/04/Snowflake-Warehouse-Monitoring-Details.png" class="attachment-large size-large wp-image-15020" alt="Snowflake warehouse monitoring details" srcset="https://www.datalakehouse.io/wp-content/uploads/2023/04/Snowflake-Warehouse-Monitoring-Details.png 720w, https://www.datalakehouse.io/wp-content/uploads/2023/04/Snowflake-Warehouse-Monitoring-Details-300x200.png 300w" sizes="(max-width: 720px) 100vw, 720px" /> </div> </div> <div class="elementor-element elementor-element-99e5d43 elementor-widget elementor-widget-text-editor" data-id="99e5d43" data-element_type="widget" data-widget_type="text-editor.default"> <div class="elementor-widget-container"> <p><span style="font-weight: 400;">And here’s another for very transactional Query History details in a transactional view:</span></p> </div> </div> <div class="elementor-element elementor-element-dc9e589 elementor-widget elementor-widget-image" data-id="dc9e589" data-element_type="widget" data-widget_type="image.default"> <div class="elementor-widget-container"> <img loading="lazy" decoding="async" width="720" height="480" src="https://www.datalakehouse.io/wp-content/uploads/2023/04/Transactional-View-of-Snowflake-Query-History.png" class="attachment-large size-large wp-image-15021" alt="transactional view of query history in Snowflake" srcset="https://www.datalakehouse.io/wp-content/uploads/2023/04/Transactional-View-of-Snowflake-Query-History.png 720w, https://www.datalakehouse.io/wp-content/uploads/2023/04/Transactional-View-of-Snowflake-Query-History-300x200.png 300w" sizes="(max-width: 720px) 100vw, 720px" /> </div> </div> <div class="elementor-element elementor-element-3cde16f elementor-widget elementor-widget-text-editor" data-id="3cde16f" data-element_type="widget" data-widget_type="text-editor.default"> <div class="elementor-widget-container"> <p><span style="font-weight: 400;">Build your Own?</span></p><p><span style="font-weight: 400;">Snowsight has provided Snowflake customers with the ability to use the new data exploration and dashboarding capabilities to roll out their own reports. If a data engineer or data analyst is bored at their organization and their manager happens to be ok with them focusing away from high-value tasks that they should be working on, they could indeed build their own, using Snowflake&#8217;s amazing new UI. </span></p><p><br /><span style="font-weight: 400;">These would be one-off unsupported configurations for your company and technically, at the moment, only people with a Snowflake login would be able to access the reports but there are some really </span><a href="https://medium.com/snowflake/monitoring-snowflake-with-snowsight-e9990a2898f1" target="_blank" rel="noopener"><span style="font-weight: 400;">cool examples</span></a><span style="font-weight: 400;"> of getting some basic Snowflake usage information visualized by </span><a href="https://medium.com/@ashish.patel_73802" target="_blank" rel="noopener"><span style="font-weight: 400;">Ashish Patel</span></a><span style="font-weight: 400;">:</span></p> </div> </div> <div class="elementor-element elementor-element-4691e77 elementor-widget elementor-widget-image" data-id="4691e77" data-element_type="widget" data-widget_type="image.default"> <div class="elementor-widget-container"> <img loading="lazy" decoding="async" width="720" height="480" src="https://www.datalakehouse.io/wp-content/uploads/2023/04/Snowflake-Usage-Data-Visualization-By-Ashish-Patel.png" class="attachment-large size-large wp-image-15022" alt="Snowflake usage data visualization by Ashish Patel" srcset="https://www.datalakehouse.io/wp-content/uploads/2023/04/Snowflake-Usage-Data-Visualization-By-Ashish-Patel.png 720w, https://www.datalakehouse.io/wp-content/uploads/2023/04/Snowflake-Usage-Data-Visualization-By-Ashish-Patel-300x200.png 300w" sizes="(max-width: 720px) 100vw, 720px" /> </div> </div> <div class="elementor-element elementor-element-23c7ba8 elementor-widget elementor-widget-text-editor" data-id="23c7ba8" data-element_type="widget" data-widget_type="text-editor.default"> <div class="elementor-widget-container"> <p><span style="font-weight: 400;">And, prolific writer and Data Vault 2.0 expert, </span><a href="https://medium.com/@patrickcuba" target="_blank" rel="noopener"><span style="font-weight: 400;">Patrick Cuba</span></a><span style="font-weight: 400;"> also showed some clever use cases </span><a href="https://medium.com/snowflake/data-vault-on-snowflake-snowsight-dashboards-4fafc695b499" target="_blank" rel="noopener"><span style="font-weight: 400;">here</span></a><span style="font-weight: 400;"> as well:</span></p> </div> </div> <div class="elementor-element elementor-element-23ac2ed elementor-widget elementor-widget-image" data-id="23ac2ed" data-element_type="widget" data-widget_type="image.default"> <div class="elementor-widget-container"> <img loading="lazy" decoding="async" width="720" height="480" src="https://www.datalakehouse.io/wp-content/uploads/2023/04/Data-Vault-Growth-Heatgrid-Snowsight-Dashboard.png" class="attachment-large size-large wp-image-15023" alt="Snowsight dashboard showing data vault hub and link growth heatgrid" srcset="https://www.datalakehouse.io/wp-content/uploads/2023/04/Data-Vault-Growth-Heatgrid-Snowsight-Dashboard.png 720w, https://www.datalakehouse.io/wp-content/uploads/2023/04/Data-Vault-Growth-Heatgrid-Snowsight-Dashboard-300x200.png 300w" sizes="(max-width: 720px) 100vw, 720px" /> </div> </div> <div class="elementor-element elementor-element-b141bc1 elementor-widget elementor-widget-image" data-id="b141bc1" data-element_type="widget" data-widget_type="image.default"> <div class="elementor-widget-container"> <img loading="lazy" decoding="async" width="720" height="480" src="https://www.datalakehouse.io/wp-content/uploads/2023/04/Data-Vault-Daily-Statistics-Snowsight-Dashboard.png" class="attachment-large size-large wp-image-15024" alt="Snowsight dashboard showing data vault daily statistics" srcset="https://www.datalakehouse.io/wp-content/uploads/2023/04/Data-Vault-Daily-Statistics-Snowsight-Dashboard.png 720w, https://www.datalakehouse.io/wp-content/uploads/2023/04/Data-Vault-Daily-Statistics-Snowsight-Dashboard-300x200.png 300w" sizes="(max-width: 720px) 100vw, 720px" /> </div> </div> <div class="elementor-element elementor-element-f8b3dee elementor-widget elementor-widget-text-editor" data-id="f8b3dee" data-element_type="widget" data-widget_type="text-editor.default"> <div class="elementor-widget-container"> <p><span style="font-weight: 400;">Enter DataLakeHouse.io </span><a href="https://www.datalakehouse.io/platform/snowflake-usage-analytics/"><span style="font-weight: 400;">Snowflake Usage Analytics</span></a></p><p><span style="font-weight: 400;">All good data engineers and data workers understand that their skills are valuable, but even more important is the value their skills bring to the business users by way of solutions.  So, a great data engineer or analytics engineer understands that they can build a prototype or a proof of concept, but it makes much more sense to incorporate a solution that is already built, supported, maintained, and continuously enhanced, so they can focus on the high-value tasks that make them a superstar in the eyes of their business partners.  And to support all of those die-hard data engineers and data analysts, we’ve built the first real Snowflake Usage Analytics offering that any Snowflake customer can use right away. </span></p><p><span style="font-weight: 400;">Here’s a quick look at just a few of the dashboards all backed by dbt models that you can use in your own organization and customize at will.  It takes less than 30 minutes to set up and you’ll almost instantly get an over 300% increase in visibility to what’s actually happening in your Snowflake accounts.</span></p><p><span style="font-weight: 400;">300% Increase in Visibility, Really?</span></p><p><span style="font-weight: 400;">Facts. DLH.io Snowflake Usage Analytics has over 70 views and tabular outputs showing perspectives into Snowflake queries, warehouse spend, allocation of resources, long running queries, user activities, application usage, query errors, and more. </span></p><p> </p><p><span style="font-weight: 400;">Based on the section above in this article, compare 70 usage reports to only the 5 or 7 reports offered out-of-the-box from Snowflake and we’re batting over a 1000% increase in visibility into your Snowflake account(s).  But let’s just pretend we’re comparing dashboards to the 5 or 7 reports and we’ll say that our key 15 sections give you 3x what the out-of-the-box Snowflake UI provides in immediately available output.</span></p><p> </p><p><span style="font-weight: 400;">Just as a preview take a look at some of the core dashboards we offer that illuminate your Snowflake account usage…</span></p><p> </p><p><span style="font-weight: 400;">Cost Analysis shows an easily viewable breakdown of what your spend is by warehouse and other dimensions based on a date filter, which allows you to hone in on areas that should be increasing in spend or those that should be trending on a predetermined baseline.</span></p> </div> </div> <div class="elementor-element elementor-element-b74adef elementor-widget elementor-widget-image" data-id="b74adef" data-element_type="widget" data-widget_type="image.default"> <div class="elementor-widget-container"> <img loading="lazy" decoding="async" width="720" height="480" src="https://www.datalakehouse.io/wp-content/uploads/2023/04/DLH.io-Snowflake-Query-Analysis-Dashboard.png" class="attachment-large size-large wp-image-15026" alt="DLH.io Snowflake query analysis dashboard" srcset="https://www.datalakehouse.io/wp-content/uploads/2023/04/DLH.io-Snowflake-Query-Analysis-Dashboard.png 720w, https://www.datalakehouse.io/wp-content/uploads/2023/04/DLH.io-Snowflake-Query-Analysis-Dashboard-300x200.png 300w" sizes="(max-width: 720px) 100vw, 720px" /> </div> </div> <div class="elementor-element elementor-element-aca9341 elementor-widget elementor-widget-text-editor" data-id="aca9341" data-element_type="widget" data-widget_type="text-editor.default"> <div class="elementor-widget-container"> <p><span style="font-weight: 400;">Analyze the Queries of your Snowflake account to get details on load and consumption. This is an advanced view incorporating a set of data similar to what’s used in the default Snowflake UI for Snowsight, but much enhanced by the ability to drill into details and view across roles, users, and warehouses.</span></p> </div> </div> <div class="elementor-element elementor-element-d2d502f elementor-widget elementor-widget-image" data-id="d2d502f" data-element_type="widget" data-widget_type="image.default"> <div class="elementor-widget-container"> <img loading="lazy" decoding="async" width="720" height="480" src="https://www.datalakehouse.io/wp-content/uploads/2023/04/DLH.io-Snowflake-Query-Analysis-Dashboard.png" class="attachment-large size-large wp-image-15026" alt="DLH.io Snowflake query analysis dashboard" srcset="https://www.datalakehouse.io/wp-content/uploads/2023/04/DLH.io-Snowflake-Query-Analysis-Dashboard.png 720w, https://www.datalakehouse.io/wp-content/uploads/2023/04/DLH.io-Snowflake-Query-Analysis-Dashboard-300x200.png 300w" sizes="(max-width: 720px) 100vw, 720px" /> </div> </div> <div class="elementor-element elementor-element-6a620f9 elementor-widget elementor-widget-text-editor" data-id="6a620f9" data-element_type="widget" data-widget_type="text-editor.default"> <div class="elementor-widget-container"> <p><a href="https://app.datalakehouse.io/welcome/register"><span style="font-weight: 400;">Try it</span></a><span style="font-weight: 400;"> out Now for your Snowflake Account</span></p><p><span style="font-weight: 400;">Let this be your official invitation to sign up for DLH.io, connect your Snowflake account, and start getting the best visibility into your Snowflake account currently available on any platform today!</span></p> </div> </div> </div> </div> </div> </section> </div>