CODEWITHSUNDEEP
sqlsnowflake-cloud-data-platform
Erick Salas-Chaverri
Erick Salas-Chaverri

Reputation: 138

Is Snowflake equivalent of SQL WITH(NOLOCK)

Is Snowflake the equivalent of SQL WITH(NOLOCK)?

I was working on update operations on SnowFlake tables but in some cases, I faced deadlock. are there any recommendations to deal with these situations?

Upvotes: 5

Views: 6754

Answers (1)

Mike Walton
Mike Walton

Reputation: 7339

SQL WITH NOLOCK is actually more like a dirty read, which means you could get partially updated data when you run a SELECT against a table that is being updated. Snowflake never provides a dirty read. You will always get the pre-update dataset returned to you until the update is committed. So, in that regard, I believe they are different.

Upvotes: 4

Related Questions