Start Free Trial Book a Demo
Live Online Workshop Thursday, July 17, 2026 2:00 PM IST · 10:30 AM CET 90 min

Snowflake Query Optimization
Live Workshop

A hands-on session for data engineers and Snowflake practitioners. Diagnose real warehouse inefficiencies, apply proven query rewrites, and learn a repeatable governance model to sustain savings over time.

30–50%
avg cost reduction
90min
live session
3
hands-on labs
Free
for all attendees
Register Free View Agenda
Reserve your seat
Confirmation + calendar invite sent immediately.
Live Q&A with the instructor
Recording access (48 hours post-event)
Lab workbook & query templates PDF
30-day Anavsan trial access

Free event. No spam. Unsubscribe at any time.

🎉
You're registered!
Check your inbox for the confirmation email and calendar invite. See you on July 17.
Workshop Outcomes

What you'll leave with

Practical techniques you can apply to your Snowflake environment the same week — not abstract theory.

01 · Visibility
Read your account_usage like a pro
Query QUERY_HISTORY, WAREHOUSE_METERING_HISTORY, and STORAGE_USAGE to identify your top 5 credit consumers in under 10 minutes.
02 · Diagnosis
Spot the 5 most expensive query patterns
Full table scans, excessive spilling, inefficient joins, over-sized warehouses, and unpartitioned large tables — with live examples.
03 · Rewrites
Apply proven query rewrites
Side-by-side before/after comparisons with measured credit impact. Includes a rewrite template you can clone for your own queries.
04 · Sizing
Right-size warehouses without downtime
How to use query profiling and the spilling signal to choose the right warehouse size — and when multi-cluster actually helps.
05 · Governance
Build a repeatable optimization process
The 4-stage accountability loop: detect → assign → simulate → prove. How to set up resource monitors and ownership routing that sticks.
06 · Tooling
Automate the detection you'll forget
How Anavsan APEX surfaces anomalies, routes ownership, and closes the loop — live demo using a real Snowflake account.
Session Agenda

90 minutes. No filler.

Every segment is timed. Q&A is built into the session, not tacked on.

0:00
Context
Why most Snowflake cost projects fail — and the 4-gap model
Quick framing: the accountability matrix, what visibility/ownership/simulation/enforcement actually mean, and why detection alone is not enough.
0:10
Lab 1
Finding your top spenders in account_usage
Live SQL. Three queries that surface your highest-cost warehouses, queries, and users. Attendees follow along with provided queries.
0:25
Lab 2
Query rewrite clinic — 3 patterns, live before/after
Full table scan fix, excessive spilling via CTE reorder, and a JOIN optimization that cut one attendee's daily warehouse bill by 40%.
0:45
Lab 3
Warehouse sizing framework & resource monitor setup
The decision tree for warehouse size. Setting resource monitors, credit quotas, and automated suspension — with policies that don't block production.
1:05
Demo
Anavsan APEX live demo — close the loop automatically
See how APEX detects a warehouse anomaly, routes it to an engineer with full context, validates the fix with a simulation, and records the saving for leadership.
1:20
Q&A
Open Q&A — bring your real workload questions
Live questions from attendees. The instructor addresses specific use cases — Snowpark, DBT pipelines, Cortex AI costs, multi-account setups.
Your Instructor

Led by Snowflake practitioners

A
Arun K.
Co-founder, Anavsan · 10+ years Snowflake & cloud data architecture
Arun has worked with 50+ data teams on Snowflake cost governance, from early-stage startups to enterprises spending $2M+ annually. He built the accountability gap framework that underpins Anavsan's APEX engine. In this workshop he shares the exact patterns, queries, and decision trees he uses in every cost review engagement.
Who Should Attend

Built for the people who own the bill

Data Engineers
Responsible for query performance and warehouse efficiency
Data Architects
Designing cost-efficient pipelines and storage models
FinOps Teams
Tracking and chargeback Snowflake credits across teams
Analytics Engineers
Running dbt or similar pipelines on Snowflake compute
Engineering Managers
Accountable for team-level cloud spend and velocity
CTOs & VP Eng
Building a culture of FinOps accountability across orgs
FAQ

Common questions

Yes, completely free. There is no paywall, no credit card required, and no upsell during the session. We run these workshops to share knowledge and build relationships with the Snowflake community. The only thing you'll see at the end is a short demo of Anavsan.
No. Labs 1–3 require only a Snowflake account with ACCOUNTADMIN or SYSADMIN role access to account_usage views. All query templates are provided in a workbook sent 24 hours before the session. The Anavsan demo is a separate, optional segment at the end.
A recording will be shared with registered attendees within 48 hours of the session. It will not be published publicly, so registration is required to receive access.
Intermediate. You should be comfortable writing SQL and have worked with Snowflake for at least a few months. We won't cover Snowflake basics — this is a hands-on optimization session. If you're just starting with Snowflake, you'll still learn a lot, but some content may move faster than you'd like.
We cap this at 150 attendees to ensure the Q&A is meaningful and the instructor can address specific questions. Previous sessions have filled up 5–7 days before the event date.
Limited to 150 seats

Save your spot now

July 17, 2026 · 2:00 PM IST · Live online · Free

Register Free →