Snowflake Training – Advanced Engineer
Optimize costs and performance
"Thanks to this training, we analyze our consumption and adjust the settings independently."
"An immediate win: better performance and significant savings on our Snowflake credits."
"The trainer makes complex topics simple and immediately applicable."
Snowflake – Senior Engineer
Objectives
On completion of the course, you will be able to :
-
- Autonomously optimize and control compute costs in Snowflake while ensuring high performance
- Analyze sources of consumption
- Adjust the execution settings
- Leveraging internal optimization mechanisms
- Implement effective cost and performance governance
Program
Introduction and fundamentals of optimization
-
- Understanding the Snowflake billing model and its optimization levers.
- Compute architecture: virtual warehouses, cloud services, automatic mechanisms.
Advanced virtual warehouse management
-
- Sizing, scaling, and multi-cluster strategies.
- Key settings: auto-suspend, auto-resume, resource monitors.
- Best practices for balancing costs, throughput, and competition.
Query and workload optimization
-
- Analysis of execution plans and identification of bottlenecks.
- SQL optimization techniques, logical partitioning (micro-partitions), pruning.
- Management of heterogeneous workloads: data engineering, BI, data science.
Governance and cost management
-
- Monitoring of computing, storage, queries, and pipelines.
- Leveraging Account Usage views and observability dashboards.
- Implementation of a monitoring and alerting model (quotas, budgets, monitors).
Data lifecycle optimization
-
- Impact of clustering, time travel, and fail-safe on costs.
- Strategies for reducing storage without compromising security.
- Best practices for transient data (staging, ELT).
Synthesis workshop
-
- Scenario: comprehensive audit of a Snowflake environment.
- Development of a comprehensive optimization plan combining performance and costs.
Teaching methods and resources
Alternating presentation/explanation phases and situational exercises.
Case studies reproducing real optimization scenarios.
Quizzes throughout the course to validate knowledge acquired.
Assessment methods
The trainer ensures that trainees carry out practical exercises to validate the application of concepts and answers to quizzes.
Technical resources
-
- Trainee reception in a dedicated training room
- Trainees must bring their own professional computer to access in-house resources.
- Projected training support documents.
- Paper version of the training material provided at the start of the session.
- Electronic version of the training material sent after the course.
Updated: December 2, 2025
3 days (21 hours)
1 650 € HT / person
Target audience
-
- Data developers/engineers
- Analysts
- Database administrators
Prerequisites
-
- Good knowledge of SQL and Snowflake
Location
-
- On-site at the client's premises & remotely
Accessibility
People with disabilities who would like to take this course are invited to contact us directly, so that we can examine together the possibilities of taking the course.
Access procedures and deadlines
Within 1 month.
Contact us by e-mail(formations@bilinksolutions.com) to find out about scheduled sessions or to arrange a date.
Trainer
Business intelligence expert, 15 years' experience