After running Snowflake in production for 5+ years I would rather have my data on something like Parquet/Iceberg (which Snowflake fully supports...) than in the table format Snowflake has.

It's not that deep

▲

gigatexal a day ago | parent [-]

Ok. And this flexibility is only really possible since they did a lot of work to make external and internal tables roughly equivalent in performance.

▲

thejosh a day ago | parent | next [-]

Yeah, performance depends.

I think a hybrid approach works best (store on Snowflake native and iceberg/tables where needed), and allows you the benefit of Snowflake without paying the cost for certain workloads (which really adds up).

We're going to see more of this (either open or closed source), since Snowflake has acquired Crunchydata, and the last major bastion is "traditional" database <> Snowflake.

	▲	gigatexal a day ago \| parent \| next [-]
		I had no idea they did. This pg lake announcement dropped that nugget and i was surprised.
	▲	gigatexal a day ago \| parent \| prev [-]
		Agreed btw.

▲

nxm a day ago | parent | prev [-]

They didn't do it out of good will. They realized that's where the market was going and if their query engine didn't perform as well as others on top of iceberg, then they'd be another Oracle in the long-term.