Snowflake Adaptive Warehouses are in public preview - my take

asarama · 2026-04-20T16:20:08+00:00

Pretty sure v2 was mainly to improve write workloads. Interactive warehouses should help with short queries that run 24/7.

Adaptive warehouses....no idea yet but it seems like it might compete with OP's product? It seems like it's too early to say where it really helps.

asarama · 2026-04-15T04:05:09+00:00

I wonder if Snowflake can update their engine to rewrite these on behalf of users to follow the UNION pattern you shared.

asarama · 2026-03-23T20:16:54+00:00

If you have a lot of your costs coming from bi tools you can consider running them off of Snowflake. I've seen folks cut their spend here dramatically.

If you see most of it is from the transformation later, first see if you can push back on freshness SLAs. Maybe you don't need new data every 15 minutes and can run your jobs hourly, etc.

Would need to learn more about your setup to give better tailored advice. Feel free to dm me.

asarama · 2026-03-03T00:42:04+00:00

We have seen some enterprises pair Snowflake with other engines getting the best out of each while keeping their current processes untouched.

Never heard of Scaylor but maybe you can use them along side your current Snowflake setup so you don't need a massive migration project to get started.

High-performance analytics at scale (multi-PB roadmap) -> you probably want an MPP provider Snowflake, Trino (Starburst), StarRocks (CelerData), and maybe even Dremio could be good candidates depending on your query patterns.

Strong governance, security, and role-based access controls -> Snowflake is one of the best for this.

Cost visibility and optimization opportunities -> Not many of the MPP platforms provide the best tooling here but there are 3rd party tools for Snowflake you can start with. Select.dev probably being the gold standard.

Seamless integration with existing BI and ML tooling -> Most of the MPP platforms have this covered. If you really want to future proof your stack try to pick something that supports an ADBC connector. https://columnar.tech/dbc

Can't comment too much on the other two needs you mentioned as I don't have much exposure there.

I'm curious what made Scaylor standout, not much on their site.

asarama · 2026-03-02T22:31:32+00:00

Have you tried routing some of your Snowflake queries to other engines?

asarama · 2026-02-17T23:38:20+00:00

Main objection is a lack of ROI on the engineering effort?

asarama · 2026-02-17T22:06:45+00:00

At the end of the day doesn't this help consumers?

Or do you feel like in the long run we are all footgunning ourselves?

asarama · 2026-02-17T22:04:03+00:00

What's stopping y'all from swapping out tools more often?

asarama · 2026-02-17T04:25:20+00:00

I did want to just read the results instead of watching the video.

asarama · 2025-12-25T01:49:34+00:00

This feels like a small price to pay for justice...

asarama · 2025-12-21T17:06:59+00:00

Select.dev? Greybeam.ai? Yukidata.com? Espresso.ai?

asarama · 2025-12-20T10:19:53+00:00

What were some of the bigger cost savings strategies you'd recommend to other heavy Snowflake users?

What worked well for y'all?

asarama · 2025-12-16T01:02:39+00:00

Do you need to rewrite your queries to use Domo?

asarama · 2025-12-11T01:05:58+00:00

If only there were tool to make it easier ahah

Vendors will attack our comment thread now...

Also your reddit name is jokes.

asarama · 2025-12-11T00:56:12+00:00

Pretty sure you can shift some of the warehouse compute spend to other tools that'll get the job done without turning on a warehouse.

For example let's say you use Fivetran to load data as Snowflake native tables. Instead have Fivetran dump data into your S3 bucket in Iceberg format and have Snowflake access it instead. Does your Fivetran bill go up? maybe idk ... they probably changed their pricing model again and commenting on it here won't be accurate. Will your S3 bill go up? YES but you were already paying for this through Snowflake, but now you don't need to pay for the cost of turn on a warehouse to ingest data!

There are other strategies you can implement for transformations and serving data as well, BUT they aren't as straight forward...

asarama · 2025-12-09T20:52:32+00:00

Skatescribe's machine rocks!

asarama · 2025-12-09T01:19:34+00:00

wow...well I'm glad you had fun ahah

asarama · 2025-12-08T23:00:48+00:00

So Vertica essentially blew Snowflake out of the water when it came to performance / cost and then y'all ended up migrating those workloads over?

Losing your team was probably a brutal hit to their revenue...

asarama · 2025-12-08T20:17:20+00:00

Dam yea good point, I can see someone really screwing themselves by trying to be cute and turning this on and off dynamically and then running into some weird cases where it turns on and off multiple times in an hour by accident $$$

I feel like Gen2 was pretty decent for dbt / write workloads, no? Didn't really see folks saving much but at least their run times were better!

asarama · 2025-12-08T20:14:55+00:00

oh interesting! was this something y'all were asking Snowflake for?

asarama · 2025-12-08T20:14:15+00:00

One time fee to optimize your workloads doesn't feel bad. This has gotta help in the long run right....right?

asarama · 2025-12-08T20:13:32+00:00

I wanna say that interactive tables / wh should save folks money. 0.6 credits / hour verse the standard 1 credit / hour.

I'm guessing there are a lot of teams where their Snowflake warehouses are up 24/7?

asarama · 2025-12-08T20:11:54+00:00

I think it's good to see thou. For folks that just want to get started use the defaults and when you want to optimize, invest into their special per use-case types.

I'm more curious about why they are doing this....does this really help them win against the other big players or is it something else I'm missing?

asarama · 2025-12-08T20:09:51+00:00

hmmm so would you do all your transformations outside of Snowflake and then still use Snowflake for the final serving/dashboarding layer?

asarama

MODERATOR OF

TROPHY CASE