When you set up a warehouse for a Snowflake datasource, it's important to pick the right warehouse size to execute the rules and profiling efficiently. Choosing the right size also helps manage costs and performance effectively.
The warehouse should be multi cluster with Min 1 and Max 4 as an optimal configuration.
Refer to the table below for recommendation on Warehouse sizing.
| Data size | Number of columns | Warehouse size |
|---|---|---|
| < 10 million records | < 100 | Small |
| 10 million - 50 million records | 100 - 300 | Medium |
| 50 million - 120 million records | 100 - 500 | Large |
| 120 million+ records | 100-500 | X-Large |