Ember Crooks

Ember Crooks

Ember is always curious and thrives on change. She has built internationally recognized expertise in IBM Db2, spent a year working with high-volume MySQL, and is now learning Snowflake. Ember shares both posts about her core skill sets and her journey learning Snowflake. Ember lives in Denver and work from home
  • Joined: April 14, 2013
  • Articles: 590
  • Comments: 605

Three Years at Snowflake!

At the risk of posting two navel-gazing posts too close together, this month represents my three-year anniversary of working at Snowflake. I joined three years ago on a referral from a friend after getting laid off. PIVOT I’ve done a…

Geo-Partitioning My Life

After almost three years at Snowflake, I’m making a move – literally. I’ve signed a contract with Snowflake Germany and will be relocating to Berlin, where I’ll keep doing essentially the same job, just from a different corner of the…

Performance Impacts of Concurrency

Queries in Snowflake try to use the entire standard warehouse. So what happens when we’re running dozens of queries on the same warehouse at the same time, and each of those queries is attempting to use all of the resources…

Using Cortex Code (CLI)

There is a mandate at work to use AI. This makes some sense as people are somewhat resistant to change, and I do work for a company that is all about AI. I’ve incorporated LLMs into my workflow in several…

Snowflake Generation 2 Warehouses

When using Snowflake, compute and storage are fully separated. This means choosing different sizes (and types) of compute to use against the same data for different purposes. Even at the same time. It used to be that size was the…

Thoughts on Benchmarking

Benchmarking is a topic I’ve seen discussed for my entire career working with databases. We used to watch the TPC-C results published, when I was working with primarily OLTP systems, and was amazed to see software I worked with every…