Snowflake, the Missing Primer

https://calpaterson.com/drafts/snowflake.html

by efge • 2 years ago

7 4 2 years ago

clevel• 2 years ago

There is some misinformation in this article. For instance, Snowflake absolutely supports transactions for most operations, DML operations always occur in a single transaction but any INSERT, UPDATE, SELECT, etc can absolutely be lumoed with other operations in a single transaction safely.

calpaterson2• 2 years ago

Sorry - this was a draft that I published accidentally while fixing a typo in another article and which someone apparently submitted it here before I could take it down.

It should 404 now. Perhaps next week :)

albert_e• 2 years ago

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.

calpaterson2• 2 years ago

Sorry - this was an early draft of a future post that somehow was submitted here. I've removed it now, thanks for proofreading :)

Snowflake, the Missing Primer

Related Stories