Writing Example Queries

• Sample Guidelines
• Basic Examples
• Advanced Examples

Sample Guidelines

To help you get started on creating useful example queries, we've compiled a list of potential topics that can be used as guidelines and includes some basic and advanced examples of these from existing tables.

Please note though that the topics below are just suggestions and example queries are not limited to just these topics.

• Security
  • Access policies
  • Credential expiration and rotation
  • Encryption
  • Versioning
• Operations
  • Audit logging
  • Data retention and backups
  • Tagging
• Cost management
  • Capacity optimization
  • Underutilized resources

Basic Examples

aws_s3_bucket

aws_ebs_volume

Advanced Examples

Joining information from the AWS EC2 instance and volume tables

Joining information from the Azure Compute virtual machine and network security group tables

Querying complex jsonb columns for AWS S3 buckets