Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Snowflake, the Missing Primer

calpaterson.com

Post reply on HN
Print view View original

1–7 of 7 posts

Re: Snowflake, the Missing Primer

#3

Post by clevel »

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.

Re: Snowflake, the Missing Primer

#4

Post by calpaterson »

clevel wrote: post #3

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.

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 :)

Re: Snowflake, the Missing Primer

#5

Post by [deleted] »

calpaterson wrote: post #4
clevel wrote: post #3

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.

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 :)

[deleted]

Re: Snowflake, the Missing Primer

#6

Post by albert_e »

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.

Re: Snowflake, the Missing Primer

#7

Post by calpaterson »

albert_e wrote: post #6

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 offici…

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