Sitemap

Member-only story

Optimizing Snowflake (6) — Cost Optimization using 3rd party services

4 min readSep 25, 2024

--

When you want to analyse the Snowflake credit usage using readymade apps, there are several apps, either native or streamlit, published by 3rd parties in the Dataproducts/Marketplace section. When doing a search on cost optimization, several services are displayed.

Press enter or click to view image in full size

These are the ones available, seems that many news ones are showing up regularly: NTT, KPI Partners, Snoptimizer, Watchkeeper, Dataradar, Infostrux, InstaQuery, Select.

In this article, we will explore the possibilities of the free NTT service.

Press enter or click to view image in full size
Press enter or click to view image in full size

The setup is super easy, ACCOUNTADMIN privileges required. After installation, we go through some configuration options. We need to give the app access to the Snowflake.Account_usage schema (using the IMPORTED PRIVILEGES), plus the app will execute task to refresh the data from the Snowflake schema into the NTT specific schema’s.

--

--

Johan
Johan

Written by Johan

I am a freelance data engineer. My main focus is Snowflake, but I am always eager to learn new things. Python and AWS are my main side interests