The current guidance would depend on a few factors:
- how much data you currently have
- what type of queries you would be running (e.g simple queries with no joins or common table expressions will require fewer resources)
- how often will you be running the queries
We currently recommend starting at either a medium or large. However you can scale up or down at any point. We suggest Large but if you are just trying things out and are the only developer then starting at a medium may be sufficient for your testing purposes.
More information about scaling and considerations:
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#scaling-up-vs-scaling-out
Scaling can be easily done by following these steps:
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#resizing-a-warehouse