![rw-book-cover](https://miro.medium.com/v2/resize:fit:1200/1*MhayKULXe3ED0E4vkSQkrg.png) ## Metadata - Author: [[alban-perillat-merceroz|Alban Perillat Merceroz]] - Full Title:: Give Meaning to 100 Billion Events a Day — Part II - Category:: #🗞️Articles - URL:: https://medium.com/teads-engineering/give-meaning-to-100-billion-events-a-day-part-ii-how-we-use-and-abuse-redshift-to-serve-our-data-bc23d2ed3e07 - Finished date:: [[2023-04-15]] ## Highlights > ![](https://miro.medium.com/v2/resize:fit:1400/1*SKOtPIeqf-2jpnz1oToTqQ.png) ([View Highlight](https://read.readwise.io/read/01gy2ma4nwdzc1hqeac5gxb255)) It would have been interesting to know what were those operations exactly. > The Analytics Service is a rather **central piece** that performs some operations and business logic that would be too complex to model as SQL ([View Highlight](https://read.readwise.io/read/01gy2ma9fqnkhxvysx50pwwyyh)) Now 100 > **maximum number of concurrent queries** on BigQuery *(Google allows up to 50 by default)* ([View Highlight](https://read.readwise.io/read/01gy2m718hntbxfw94vb2x1mad))