I would recommend following these guides when building it in Snowflake, a lot of the work should already be done for you.
https://medium.com/snowflake/monitoring-snowflake-with-snowsight-e9990a2898f1
https://medium.com/snowflake/monitoring-your-snowflake-organization-with-snowsight-b1acd470dc17
Keep in mind, Snowflake’s Snowsight feature is considered a very basic BI layer and would recommend Tableau if you need additional features.
Also, Tableau already has a pre-built dashboard- https://www.tableau.com/blog/monitor-understand-snowflake-account-usage
Data Engineering and BI BLOG 