Using Federated Queries to Power External Reporting with Presto

Learn how Varsity Tutors leverages Presto for federated queries across multiple databases in this technical presentation. Discover the implementation of external reporting capabilities for their Schools platform, including student assessments and progress reports. Explore their journey in selecting Presto over other technologies, and dive into their data architecture that utilizes AWS services like MySQL, Postgres, Redshift, and S3. Gain insights into their security handling for cross-account writes, their use of Ahana Cloud as a managed Presto service, and their methodology for performing upserts in their reporting database.