How Twitter maximizes performance with BigQuery

How Twitter maximizes performance with BigQuery

Twitter Google collab on BigQuery → https://goo.gle/3fJW7Qd

How does a tweet go from one person to hundreds of millions of people? How does the data process so quickly? In this episode of Architecting with Google Cloud, Priyanka chats with Gary and Saurabh from Twitter about how data from over 200 million users goes through the Twitter data center and Google Cloud. Watch along and learn how data stored across tens of thousands of BigQuery tables in Google Cloud runs millions of queries each month.

Chapters:

0:00 - Intro

1:39 - How does Twitter process data?

2:20 - How does Twitter’s data get to Google Cloud?

3:34 - Twitter’s data migration architecture

4:40 - Use cases for BigQuery at Twitter

6:00 - How does Twitter manage storage?

7:49 - How does Twitter organize data?

10:31 - Data storage hierarchy & provisioning

12:06 - How does Twitter secure & monitor data?

13:24 - Twitter’s challenges for data at scale

14:21 - BigQuery at Twitter

15:10 - Wrap up

Priyanka’s LinkedIn → https://goo.gle/3Md4kZA
Gary’s LinkedIn → https://goo.gle/3V5jLHd
Saurabh’s LinkedIn → https://goo.gle/3Cc4JH4

Architecting with Google Cloud playlist → https://goo.gle/ArchitectingWithGoogleCloud
Subscribe to Google Cloud Tech → https://goo.gle/GoogleCloudTech

#ArchitectingWithGoogleCloud