Snowflake CPU Usage Power BI Report Template
Originally published: 10/10/2024 20:56
Publication number: ELQ-15396-1
View all versions & Certificate
certified

Snowflake CPU Usage Power BI Report Template

The Snowflake Usage Report Template was created to bring easy and quick visibility to monitor Snowflake CPUs

Description
The Snowflake Usage Report Template for Power BI was created to bring easy and quick visibility to monitor how Snowflake is performing.

 

It will assist with:
· Optimize Your Storage Usage and Reduce Compute Costs
· Improve Snowflake Warehouse Performance
· Monitor Snowflake Credit Usage Across Your Organization
· Provide Forecasting Analysis to Project Future Usage Possibilities


The Snowflake Usage Report Template contains pre-made SQL queries used to extract data from the Snowflake database. *These queries may not work with a custom snowflake infrastructure. If that is the case, please contact your Snowflake administrator.


Below are the tables in the Snowflake Usage report Template and the Snowflake queries used toextract data from the snowflake source system. 


To get started, establish theconnection to Snowflake and apply the SQL queries to each table:


VW_REP_SNOWFLAKE_STORAGE_USAGE_MONTHLY_SUMMARY  - This table contains the data used to display storage details from snowflake


VW_REP_SNOWFLAKE_WAREHOUSE_METERING_HISTORY - This table contains the meter history from snowflake

VW_REP_DATE_DIMENSION - This table contains date dimension data from snowflake


VW_REP_SNOWFLAKE_PIPE_USAGE_HISTORY - This table contains the pipeline usage from snowflake


VW_REP_SNOWFLAKE_QUERY_HISTORY - This table contains query history from snowflake


The remaining tables do not require data source connections. 

This Best Practice includes
1 pbix, 1 instruction guide

Acquire business license for $25.00

Add to cart

Add to bookmarks

Discuss


0.0 / 5 (0 votes)

please wait...