Learn how to deep dive into your logs using SQL

Logging is a critical part of the software development lifecycle - enabling developers to debug their apps, DevOps/SRE teams to troubleshoot performance issues, and security admins to analyze access patterns.

In this session, Google Cloud Product Manager, Afrina M, and Senior Staff Software Engineer, Summit Tuladhar, will demonstrate how to efficiently deep dive into your logs, including:
- Walk through the essential tools you need to perform network and security analytics, and application troubleshooting using log data
- Show you how to perform log analysis using SQL
- Demonstrate how to use tools such as Logs Explorer, Log Analytics, and alerting

02:45 Google Cloud Operations overview
05:31 Structured vs unstructured logs
09:26 Collecting logs to use SQL (managed and do-it-yourself)
13:39 Log Analytics in Google Cloud Logging
14:45 Why SQL?
15:55 Powerful search function
16:50 Logging use cases
17:05 Troubleshooting use case (developers and DevOps)
18:21 High volume network analysis use case (IT)
19:26 Investigating audit logs use case (security)
20:25 Live demo
32:20 Security insights using SQL
39:40 Resources and next steps
41:10 Q&A

Resources

[niesfisch]

how do i get the "Chart" view you showcased at 24:48? i am only able to see the "Results" pane. thanks!