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 Megabyte scanned
Cloud Service Layer Queries
You will not be charged for these 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:
Related reading: Power BI Dataflows now support data integration with Snowflake, Snowflake Summit Highlights and the Snowflake Vision, and On-premises Data Solutions to Snowflake on Azure.
Views: 2215