| I'm curious about what your data warehouse looks like, including schema designs, tech stack, etc. Shopify: Follow a strict star schema design pattern. Our data is stored in HDFS, and we use PySpark for ETLs, and store resulting datasets in Amazon's Redshift. |