A few typos:
> I'll have to infer, assume and hypothesis.
*hypothesize
> No transactions, not indices, nearly no constraints
*no indices
---
Also I would be surprised if Snowflake documentation at this introductory level does not exist.
there are a few levels of "certification" that Snowflake offers for professionals who are expected to understand how Snowflake works at a fairly detailed level -- and I am sure official documentation exists to cater to this group starting with a technical introduction/overview of capabilities etc.