aws_resources
Unified table for all AWS resources (EC2, RDS, Lambda, S3, EKS, ElastiCache, VPC, security groups, IAM roles, SQS, SNS, DynamoDB).
-
id
Primary key - Unique identifier for the row.
-
arn
string - Amazon Resource Name (ARN) for the resource.
-
resource_type
string - Type of AWS resource (ec2, rds, lambda, s3, eks, elasticache, vpc, security_group, iam_role, sqs, sns, dynamodb).
-
identifier
string - Resource-specific identifier, unique per connection, resource type, and region. For IAM roles, SQS queues, SNS topics, and DynamoDB tables this is the ARN so resources stay distinct across AWS accounts.
-
name
string - Human-readable name or identifier for the resource.
-
region
string - AWS region where the resource is located (e.g., us-east-1, us-west-2).
-
availability_zone
string - Availability zone where the resource is running (null for regional or global resources such as Lambda, EKS, VPC, IAM, SQS, SNS, DynamoDB).
-
state
string - Current operational state of the resource (running, available, active, stopped, etc.).
-
properties
jsonb - JSON object containing resource-specific attributes
-
created_at
date - Timestamp when the resource was created in AWS.
-
connection_id
Foreign key - ID of the Data Cloud connection importing the resource.
-
api_accessible
boolean - Whether the resource is currently accessible via AWS API. False indicates the resource may have been deleted from AWS.