This is the second post of a six-part series of posts explaining how we make analyzing Quickbooks data easier by creating cached data sets from complex queries, resulting in simplified tables that anyone at our company is able to easily understand. Part 1: Introduction + Shadow Schema Strategy Explanation Part 2: The Quickbooks Shadow Schema (You are here) Part 3: Budgets Table Part 4: Cash Movements Table Part 5: Expenses Table Part 6: Revenue Table This is the schema creation script for the shadow schema. I’ll outline how I load the data in a separate post and link it here … Continue reading Simplifying Stitch ETL’s Quickbooks Data in Redshift: The Shadow Schema