aws_resources
Unified table for all AWS resources (EC2, RDS, Lambda, S3, EKS, ElastiCache).
-
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).
-
identifier
string - Resource-specific unique identifier
-
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 resources like Lambda, EKS).
-
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.