@StephanieAlba adding to @Walter_C no of workspaces will depend on design that you are planning
1. you can based on business unit
2. you can just go by Dev/Qa/Tst/Prd for CICD Practices wise
3. if you go based on above approach, UC schema/catalog wise we need to be well prepared (eg: dev catalog--> dev_silver, dev_bronze, dev_gold schemas) and segregate permissions in schema level