Update to warehouse connection and transaction guidelines

In order to protect the integrity and stability of the Warehouse for customers, we are rolling out some new guidelines for direct connections to the Warehouse, including connection limits and polling best practices. Check out the Limits guide for more details.

What’s changing?

In order to ensure the integrity and stability of the Data Warehouse, Benchling is implementing limits related to warehouse connections and transactions. These limits are designed to ensure that syncing data and serving queries is timely, reliable, and performant. These limits include:

1. A limit on the number of concurrent open connections to the Warehouse per user.
2. A limit on the total number of concurrent open connections per Warehouse
3. A new set of best practices on transactions and polling has been published.
   1. Polling should be limited to no more than a few times a minute
   2. Transactions that interfere with data snyc may be disconnected, particularly long-running transactions that hold locks on frequently updated tables.

Check out the Limits guide for more details on these changes.

When is this happening?

These updates are now live! Please read through the Limits guide for more specific information.