ClickHouse, a cloud analytical database provider, has built an internal data warehouse (DWH) using ClickHouse Cloud as the main database, Airflow as a scheduler, and various other tools such as Superset for business intelligence. The DWH stores data from multiple sources, including customer data, financial information, and usage metrics, and uses a hierarchical architecture to manage the data. To ensure security and compliance with regulations, the system implements strict access controls, uses Google groups to control user permissions, and has a process in place for handling sensitive data such as PII and GDPR requirements. While the DWH has been successful in delivering an experience that users love, there are areas for improvement, including introducing a third logical layer to manage complex metrics, integrating Airflow with DBT for additional functionality, and refining naming conventions to improve user understanding. Overall, the system has achieved impressive results, with over 70 monthly active users, hundreds of dashboards, and thousands of charts, and stores approximately 13 TB of data in a compressed format.