Putting transformational modeling into practice
In the last chapter, we deployed our sample physical model. Here, we will populate it with data and create a transformational model to satisfy a business requirement using the techniques and best practices covered in the preceding sections.
Transformational modeling requires data. The script to populate our operational schema with sample data can be found in the Git repository for this chapter. Please run the script titled create_physical_model_w_data.sql to recreate the physical model and load it with data from the SNOWFLAKE_SAMPLE_DATA database if you have not already done so.
After running the script, all the transactional tables in the schema will have been populated with data. However, the LOYALTY_CUSTOMER table is not transactional; it needs to be created through a transformational model. Just as the data model in the previous chapters took shape after getting to know the workings of our company by communicating with the business...
