4 ms·
Snowflake is a data warehouse though. Completely different use case. If your data can be done via PG, highly recommend that over SF. Especially with this conce
by thejosh 4y ago
Snowflake is a data warehouse though. Completely different use case.
If your data can be done via PG, highly recommend that over SF. Especially with this concept.
Snowflake is great when you use a tool like dbt, their modern SQL approach and functions are fantastic. Downsides is it's pretty pricey, and can catch you out.
- iknownothow 4y agoWe already use DBT and the data is less than 10TB, something Postgres can handle well. And most of the data is concentrated in a few tables. With a serverless approach I'd be happy to allocate 10x resources for just a query or two and for the rest a minimal server is fine. I manage the data warehouse mostly alone because Postgres offers guarantees, unique constraints, triggers and relationships between columns of different tables. It does the work of two engineers. Snowflake is fast but not Postgres compatible. In order to move to Snowflake, I have to write tests and maintain them which Postgres does for me for free. I'd stick with Postgres at least until 20TB before considering Snowflake.