DownloadCreate AI Presentation

Strategies to Optimize Snowflake Cost

Reducing Cost and Improving Performance in Snowflake

Introduction

  • Overview of the importance of optimizing Snowflake cost
  • Introduction to the speakers and their expertise
  • Agenda for the presentation
  • Highlighting key accomplishments in reducing cost

Snowflake Deployment at Insta

  • Overview of Snowflake deployment at Insta
  • Number of users and warehouses
  • Queries per month and data usage
  • Access control settings for data security

Accomplishments and Cost Reduction

  • Summary of cost reduction achievements
  • Reducing storage cost by 33%
  • Optimizing query runtime and performance
  • Example of query runtime reduction

Observe, Analyze, and Optimize

  • Importance of observation and analysis for cost optimization
  • Query profiling and metrics
  • Query fingerprinting and tagging
  • Accountability and ownership

Analyzing Query Profile

  • Understanding query profile for optimization
  • Identifying expensive nodes and aggregates
  • Optimizing table scans through filtering and clustering
  • Monitoring caching and spilling

Optimizing Warehouse Size

  • Determining optimal warehouse size
  • Factors to consider for scaling
  • Importance of minimizing byte scan
  • Balance between vertical and horizontal scaling

Storage and Cloning Optimization

  • Maximizing storage efficiency
  • Using transient and temporary tables
  • Optimizing time travel and cloning
  • Monitoring and managing retained by clone bytes

Conclusion

  • Summarizing key learnings and takeaways
  • Importance of early cost detection and optimization
  • Role of accountable individuals in driving optimization
  • Appreciation for the audience's time and attention

Related Presentations

AI Shaping Our Global Future

Revolutionizing Enterprise Workflows with AI Automation

Computer Vision

Computer Vision

COMPUTER VISION

COMPUTER VISION

Other Free PPT Tools

Topic to PPT using AI

Generate engaging presentations quickly from just a keyword. Ideal for students and educators needing fast, content-rich slides.

Create PPT from Topic
AI

YouTube to PPT using AI

Turn YouTube videos into informative slide presentations. Excellent for marketers and creators looking to expand their video content's reach.

Create PPT from YouTube
AI

AI PitchDeck Generator

Turn Pitch Deck into informative slide presentations. Excellent for business and startup looking to present his business.

Create PPT from Pitch Deck
AI

Text to PPT using AI

Generate engaging presentations quickly from just a keyword. Ideal for students and educators needing fast, content-rich slides.

Create PPT from Text
AI

URL to PPT using AI

Effortlessly convert any web page into a comprehensive presentation. Perfect for professionals and researchers presenting web-based data.

Create PPT from URL
AI

PDF to PPT using AI

Convert PDF files to PowerPoint slides easily. Essential for analysts and consultants dealing with detailed reports.

Create PPT from PDF
AI