We ran a load test Snowflake as the database. This run was done on 2nd & 3rd May 2024. We benchmarked our system to 35 requests per minute due to MERGE statements blocking the tables. For numbers less than 35 it was working perfectly fine.

But all of a sudden, the 35 requests per minute load test started showing regressive results, with MERGE statements getting BLOCKED. The code is the same (we have tagged our code for a particular release), package versions are same, & load test scenarios are same. The situation has worsened to the point that loads like 20 & even 10 are getting failed.

I have tried upgrading the snowflake-sdk but no gain.

Tech stack:

1. AWS API Gateway + Lambda with Nodejs
2. Artillery for load testing

I tried reducing the load but surprisingly at lower load it is failing. I also tried upgrading the snowflake-sdk but didn’t work.