Analytics

Snowflake Usage Analytics

5 min

the most popular analytics offering in datalakehouse allows the viewing of comprehensive snowflake costs snowflake cost calculators surface usage and costs, available to the account administrator role under the account > billing & usage tab these insights are largely presented as data, not as historical trends as a result, this excludes in depth analysis of the various parameters that affect usage and costs, and levers you can pull to control them rest assured, snowflake does a good job of making the usage statistics and costs easily visible via their standard interface however, some organizations may need more detail it infrastructure leads and business sponsors of initiatives that leverage snowflake to achieve important business outcomes would need to review usage statistics and costs on a more frequent basis data analytics tools provide deeper insight on snowflake costs and usage this is where datalakehouse io comes into play prior to deploying snowflake usage analytics, complete the pre install items pre install items new datalakehhouse io customer if datalakehouse io is not already landing data into your snowflake target, follow these steps which will create the necessary users, warehouse, databases, etc in order to get this dashboard configured in datalakehouse io, the following script will need to be run in snowflake modify the role, username & password to fit your naming convention and existing names existing datalakehouse io customer if datalakehouse io is already landing data into your snowflake target, follow these steps in order to get this dashboard configured in datalakehouse io, the following script will need to be run in snowflake modify the role, username & password to fit your naming convention and existing names create a snowflake source connector create a what is a source connection? docid\ dalfu3jvof0g4 if7atke to snowflake that will be used for creating and running the sync bridge install the package install the snowflake usage analytics package by following the how to access analytics docid\ sd11vm7awa81b7nq1ze4n steps with a user who has the org admin role in datalakehouse io