Snowflake - Use Different Warehouse per Dataset/Workbook

  • Describe Feature
    I would like a way to change which Snowflake Warehouse that sigma uses based on the dataset or workbook being accessed.
  • What is the use case?
    We have many different datasources, some in the billions of rows and others only a few million. Currently we have to set single Warehouse for Sigma to use in Snowflake, which has to be big enough for the large sources but overpowered for the smaller. It would be great if each Dataset could be assigned a different Warehouse, so that we do not consume a large number of credits for small datasets.
  • How often would this feature be used?
    Every time a new dataset and workbook is created.
  • What is the impact of this feature on your organization?
    This would enable a huge increase in cost-efficiency of compute credit usage, as we can more easily right-size the warehouse based on the data size.

Thoughts on this product request:

Can’t you already do this, by creating 2 separate Snowflake connections. One connected to your large warehouse and the second connected to your small warehouse. Depending on how your data is organized (small tables on db A and large tables on db B OR if all tables are on 1 db) you can select the desired WH for each dataset by selected the connection desired when creating the dataset. I think this does exactly what you’re looking for. Let me know your thoughts!