sumaaithal/snowflake_dynamic_pipelines ? reverse-engineered prompt

Build me a Snowflake demo project that creates synthetic customer, product, and order data, then turns it into a simple analytics pipeline with Dynamic Tables. I want a setup script that creates the warehouse, databases, and sample raw tables, then a staging layer that cleans up the data and pulls fields out of a semi structured order column, and finally a fact table that joins customers and orders together.

Please also include a second script that shows how to manage the pipeline, like changing refresh timing, checking refresh history, and filtering out bad records. Keep it simple and easy to run in order, so I can use it as a working example of chained Dynamic Tables and data quality checks in Snowflake. If you need to, look up the current Snowflake docs online while building it.