Required Knowledge, Skills, and Abilities
Snowflake performance specialist
- Familiar withzero copy cloningand usingtime travelfeatures to clone table
- Familiar in understandingSnowflake query profileand what each step does andidentifying performance bottlenecks from query profile
- Understanding of when a table needs to be clustered
- Choosing the right cluster keyas a part of table design to help query optimization
- Working with materialized views andbenefits vs cost scenario
- How Snowflake micro partitions are maintained and what are the performance implications wrt micro partitions/ pruningetc
- Horizontal vs vertical scaling. When to do what.Concept of multi cluster warehouse and autoscaling
- Advanced SQL knowledge including window functions, recursive queriesand ability to understand and rewritecomplex SQLs as a part of performance optimization