Live data from Hacker News

Snowflake S-1

sec.gov

31–40 of 103 posts

Re: Snowflake S-1

#32

Snowflake is the go to data warehouse in my opinion. Redshift and BigQuery are fine, but Snowflake is head and shoulders above. Good community around it and tools for it (dbt - works on other warehouse though). They have the mindshare in the data warehouse market. There's so much they can do from a user experience perspective to make it even better. The integration with Numeracy was a trainwreck, but the fundamentals…

But, also very expensive. You can do queries on a spark cluster for tiny fractions of what they charge. But, snowflake makes things easy for the "decision makers" (who know SQL). So, all good.

Re: Snowflake S-1

#33

What is the difference between a "Data Warehouse", a "Data Lake" and a plain old managed SQL Server instance I run on Azure?

Data Warehouse is usually a relational database designed for large OLAP analysis with features like column-oriented storage, vectorized processing, and distributed scale-out architecture. Since it's a database, the focus is on strong schemas and structured data, although all major systems also support JSON datatypes now.

Data Lake is usually object storage or other large storage pool with raw files. These can be different formats like JSON, AVRO, Parquet containing with strong schemas or unstructured data. Processing can be done by engines like Spark, Presto, Drill, etc that support less advanced SQL but more robust access across data files and storage locations. The point is to serve as a general dumping ground or "lake" of all the data and then manage it afterwards (including cleaning and moving important records to a data warehouse).

SQL Server is a single-node OLTP relational database but most database engines are fast enough now that you can do everything you need up to hundreds of millions of rows. Best SQL and feature support with full update capabilities. Some DBs like SQL Server have also added OLAP features like columnstore tables to further delay or eliminate the need for a data warehouse.

Re: Snowflake S-1

#35
post #19

Wow, Sales + Marketing pretty much 1.5x their revenue ($265M), swinging them from +50% operating margins to -150-200% net margins. They are really trying to cram this product down people's throats, huh?

It's absurd. How can you trust any of their "growth" numbers? For all we know, they are paying people $10 to give them $8 in revenue.

Or is it $8/year for several years? The question is what is Snowflake’s net-churn rate.

Re: Snowflake S-1

#36
Will they be contributing back to FoundationDB(FDB)? I ask this because they had used FDB since 2014 to build the Snowflake metadata store, and they've supposedly advanced FDB in the process, and I assume some of those advances are generic and would benefit all FBD users. Now that they'll have the IPO cash, I hope they will contribute back. For example, I know FDB maintainers would love help with optimizing FDB for EKS and other managed K8s platforms on major clouds. Congrats on the IPO! I might buy a few shares :-)

Re: Snowflake S-1

#37
They're going to have to add a new section "daily S-1 filings" if this keeps up, we can put it next to the show hn link.

Re: Snowflake S-1

#38

5 S-1 filings on the front page right now, mostly from tech companies I've heard of. Why the sudden spike?

We're near the top of a huge an unprecedented bubble in tech stocks. Top 5 stocks are tech and are 23% of the S&P 500, all time highs in the middle of a pandemic with the global economy stuttering. That's a greater concentration than the year 2000. So it's a good time to IPO for tech stocks.

Re: Snowflake S-1

#39

Dumb question, given the filing today what is the earliest date it will be listed on the NYSE? Google time between S-1 and IPO gives a bunch of wishy washy answers.

I had the exact same question. Pg 127 seems to give the answer.

> Date Available for Sale in the Public : The 91st day after the date of this prospectus (First Release).

Edit: Seems like I was wrong. This is for current shareholders. I saw somewhere on the internet sometime in October. That's a wild guess though.

Re: Snowflake S-1

#40

What is the difference between a "Data Warehouse", a "Data Lake" and a plain old managed SQL Server instance I run on Azure?

SQL instance is fast and for transactional systems - like stock exchange, purchasing something,... called schema on write.

DW is for analytics and reporting.

Data Lake is like many DWs together and other, often "garbage" data, which "might" be useful in future analysis, ML and stuff. It's the unstructured graveyard of data (joking). Schema is defined on read.

Post reply on HN