Are there use cases where you might be using more than 3 warehouses?
Yes, for sure. We actually have a current client where we have put this into use. The 3 by 2 system works perfectly when everything is constrained to simply moving data from the source, transforming for production, and loading into Sisense. The use case for a fourth warehouse comes in handy when you have "too many hands in the cookie jar". For instance, this client has an entire research team that is actively using Snowflake daily to improve their data quality. This team was previously using the PROD_WAREHOUSE (meant only to move data from production database to Sisense). This was causing a conflict over the compute resource and a jump in Snowflake costs. We fixed this by adding a RESEARCH_WAREHOUSE. This fourth warehouse allowed us to better understand how compute resources were being used, where costs were coming from, and allowed Sisense dashboards to not be impacted by backend queries being written on the same warehouse.
