Affan Tariq
Snowflake Data Engineer at Data Prism
Tunes Snowflake for cost and speed, from warehouse sizing and query caching to forecasting spend before a migration.
- Experience
- Snowflake Data Engineer at Data PrismSnowflake cost optimization, query performance, cost forecasting
- On the blog
- 9 articles written
About Affan
Affan is the Snowflake Data Engineer at Data Prism. Affan works on the Snowflake accounts behind client reporting, where most of the bill comes from compute that runs longer than it needs to.
Client work covers warehouse sizing and auto-suspend settings, query caching and materialized views, and storage choices like transient tables and Time Travel retention. Before a migration, it includes modelling what Snowflake will cost, so finance sees the number before the invoice.
On the blog, Affan writes about Snowflake pricing, cost monitoring and optimization, query performance, and how Snowflake compares with Redshift.
What Affan writes about
Pick a topic to filter the articles below
Latest articles
- Snowflake Cost Optimization: 9 Techniques That Cut the BillSnowflake Consulting
- How CFOs Should Think About Snowflake PricingSnowflake Consulting
- The Complete Guide to Snowflake Cost OptimizationSnowflake Consulting
- dbt Fusion Cost Optimization Guide: Snowflake & BigQuerySnowflake Consulting
- How Does Snowflake's Auto-Suspend Feature Help in Cost Management?Snowflake Consulting
- How Can Query Caching Improve Snowflake Performance?Snowflake Consulting
- Snowflake vs Redshift: Which Data Warehouse To Choose?Snowflake Consulting
- Snowflake Pricing & Cost Guide: Everything You Need to KnowSnowflake Consulting