AWS CloudTrail Service Usage Dashboard

This dashboard visualizes AWS service usage based on CloudTrail logs analyzed with DuckDB and Tailpipe - our homemade CSPM solution.

DIY Cloud Security Posture Management: This dashboard demonstrates how you can build effective cloud security monitoring tools using open-source technologies instead of expensive commercial CSPM solutions.

About This Dashboard

This visualization is powered by a simple React component that loads CloudTrail analysis data stored as JSON in the public directory.

The data was generated using the following Tailpipe SQL query:

        tailpipe query "SELECT event_source, COUNT(*) AS count 
FROM aws_cloudtrail_log 
WHERE event_time > current_date - interval '7 day' 
GROUP BY event_source 
ORDER BY count DESC" --output json > dashboard_data.json