Ask HN: Is our data warehouse setup normal or over-complicated?

A developer describes their company's multi-step data warehouse pipeline for customer-facing reports, involving MySQL, DMS, Glue jobs, two S3 data lakes, canonical transformations, Redshift, and QuickSight. Embedding reports requires lambda-generated iframe URLs and manual access management, making the process slow and cumbersome.