* F1 Query teamF1 Query is the preferred SQL query engine for OLTP, OLAP, ETL workloads at Google. Users include major Google products, like Google Ads, Google Analytics, Payments, etc; internal data pumpers; as well as 10k+ ad hoc interactive human users.Projects:** F1 Query team - Table ServiceTable Service is a new unified service providing standardized Table API for performant and compliant access to all structured data at Google. Serving a growing user base across multiple Product Areas.- Snapshot / Incremental SQL read.- Integration with structured data sources, like Napa (Google’s planet-scale data warehouse).- Integration with processing tools, like Procella, Conduit, Flume, etc.- Full productionization for reliability, performance, maintainability, and usability.** F1 Query team - Vectorization (Aggregation)Vectorize aggregation components in F1 query execution engine. The vectorization improved aggregation CPU efficiency by 2.5X.- Vectorization for aggregation, including rewriting a reusable performant columnar execution kernel for aggregation.** F1 Query team - F1 LightningF1 Lightning is a HTAP solution for Google. F1 Lightning syncs data from Spanner in real time and maintains data in formats optimized for analytics with additional features like indexing and materialized views. Major Google products use F1 Lightning, including Google Ads, Payments, Shopping, etc.- Multi-key lookup queries over Lightning, achieving 2X CPU efficiency compared with F1 Query + Spanner.- Query-time failover mechanisms, significantly improving the availability of Lightning.* Geyser teamGeyser is a continuous database change triggering & processing pipeline service, also offering ETL mode for Geyser pipeline startup & recovery.− Reliability and automation for legacy Geyser service.Relevant papers:F1 Lightning Paper (2020): https://dl.acm.org/doi/10.14778/3415478.3415553F1 Query Paper (2018): https://dl.acm.org/doi/abs/10.14778/3229863.3229871