When executing more than eight concurrent, independent connections into Snowflake that either update or insert into a single table, you could encounter the following error:
Exceeded limit of the number of statements that can be queued on a target resource.
The behavior is by design. If the queue is full, subsequent jobs requesting a lock on the resource produce the compilation error.
Retry the DML operation in a given connection. Only one DML operation is allowed on a single object (table) at a time, and there can only be eight DML operations at most waiting in the queue. If the wait queue exceeds eight operations, the error is generated.
All Snowflake Clients