SnowfLake Usage in Power BI
Get Insights about your SnowfLake Account Usage in Power BI by using the predefined but extensible Report. Just edit the Parameters like SnowURL, Cost, Username and Password – Refresh!
More Info:
https://powerbi.microsoft.com/fr-fr/blog/power-bi-enables-connectivity-to-snowflake/
Content:
Compute Cost:
There is a Power BI Parameter called CostperCredit. Please enter your actual costs here.
Compute Cost Forecast
Based on Power BI native functionality. It needs proper Data to work correctly.
Storage Cost
The Parameter in Power BI is called StorageCostsperTB. Please enter here your actual Cost per Terabyte.
Query History
Analyze your queries on Warehouse, Schema, Role, User or Database Level.
Long Running Query Traffic
In and Outbound Data Transfer
Execution Time vs Mega Byte scanned
Cloud Service Layer Queries
You will not be charged for this queries as far as i know. [Update 2.11.2019] There are now charges for that kind of workload. https://www.snowflake.com/blog/whats-new-with-the-snowflake-cloud-services-billing-model/
Used Views & Tables
Database: SNOWFLAKE
Schema: ACCOUNT_USAGE
Views: QUERY_HISTORY, WAREHOUSE_METERING_HISTORY, STORAGE_USAGE
Currently the Pbix is available on request only, contact me:
Visits: 2066