Troubleshooting data warehouse connectivity

This document examines some potential issues that can affect the performance of the Data Productivity Cloud connectivity to your cloud data warehouse, and suggests configuration fixes or workarounds that will resolve those issues.

---

Snowflake

Warehouse size imposes a restriction on the number of connections that can be made

The number of connections that can be made to the Snowflake warehouse can directly affect Data Productivity Cloud pipeline performance. A pipeline will use concurrent threads to efficiently write multiple updates to the same Snowflake table. If the warehouse doesn't support the number of threads being used, it risks locking target records and causing write failures.

This is a limitation of the Snowflake warehouse size, and the solution is to ensure that the warehouse is right-sized to handle the update load put on it.