Hi Steve, currently a single GoodData datasource does not allow to add multiple Snowflake warehouses, but there are several options how to achieve scalability:
• one purely on the Snowflake side might be to utilize the
Multi-cluster warehouses and scaling policy that allows to scale the compute either manually or automatically based on the load while having one warehouse.
• or you can use the newly released option in GoodData -
datasource per client where you can create additional datasources (i.e. with different Snowflake warehouses) and assign them to some of your client workspaces to override the datasource from the parent workspace. This way you can have full control over which warehouse is used for which client workspace and for example isolate your biggest/most important workspaces.
We are also planning further performance improvements to our FlexQuery engine in the future to bring better performance (i.e. pre-fetching of some data to speed up the calculation etc.)