paulf-999/snowflake_projects ? reverse-engineered prompt

Build me a Snowflake setup project that can quickly stand up a fresh data warehouse with some example data and the basic objects needed to get started.

I want a simple, practical setup that includes the usual Snowflake things like roles, databases, schemas, warehouses, and a few sensible defaults so it feels like a real starter environment instead of a toy demo. If it makes sense, include a version that also shows how to connect Snowflake to S3, since I may want to extend it later.

Please make it easy to run from the command line with clear scripts and setup steps, and keep it organized so I can reuse parts of it for different projects. If there are any current best practices or Snowflake changes I should know about, look up the latest docs online before you wire it all together.