So, I’ve been messing around with this thing called Snowflake lately, specifically trying to build a mod, and let me tell you, it’s been a journey. I decided to call it “skx” because, why not, right? I started by looking for parts, specifically a snowflake dial, and hands. I hit up a bunch of different sellers, trying to find the right pieces. It was kind of a pain, honestly.
I did a ton of research, trying to figure out how to get the look of the dial just right. I ended up going through like, 20 different designs. I spent many nights, just tweaking things. I finally got to a point where I had this skeleton dial design that worked with NH35 and NH38, which was a huge relief.
Then there was the whole thing about figuring out Snowflake’s structure. I learned that these things called “warehouses” are basically just compute resources. You can scale them up, like giving them more power, or scale them out, which is like adding more of them. I messed around with both, trying to get the best performance without breaking the bank.
I also learned that each time you run a query, it uses those warehouses. Then, I tried to figure out how to find the cost of each query by combining the time it took to run with the size of the warehouse it ran on. It was a bit tricky, but I got there in the end. I found some cool tricks to make things run faster, like optimizing how I was storing data and how I was writing my queries. It was a lot of trial and error, but I did figure out a few things that really made a difference.
Here’s a quick rundown of what I did:
- Searched for snowflake dial and hands from various sellers.
- Designed a skeleton dial that’s compatible with NH35 and NH38 after numerous revisions.
- Explored Snowflake’s structure, including warehouses and how they relate to query execution.
- Experimented with scaling up and scaling out warehouses to optimize performance.
- Calculated the cost of each query based on execution time and warehouse size.
- Found some tricks to make things run faster.
My Final Thoughts
Building this “skx” mod in Snowflake was definitely a challenge, but it was also super rewarding. I learned a ton about how Snowflake works, and I’m pretty happy with how it turned out. I still have a question about whether there are snowflake dials to try a more vintage-snowflake style titanium milsub, but anyway. I think I’m going to keep tinkering with it, just to see what else I can do. This is how I play with Snowflake recently, so I decided to share it with you guys. Hopefully, you found it useful!
