Table: aws_lightsail_container_services
This table shows data for Lightsail Container Services.
The primary key for this table is arn.
Relations
The following tables depend on aws_lightsail_container_services:
Columns
| Name | Type |
|---|---|
| _cq_id | uuid |
| _cq_parent_id | uuid |
| account_id | utf8 |
| region | utf8 |
| arn (PK) | utf8 |
| tags | json |
| container_service_name | utf8 |
| created_at | timestamp[us, tz=UTC] |
| current_deployment | json |
| is_disabled | bool |
| location | json |
| next_deployment | json |
| power | utf8 |
| power_id | utf8 |
| principal_arn | utf8 |
| private_domain_name | utf8 |
| private_registry_access | json |
| public_domain_names | json |
| resource_type | utf8 |
| scale | int64 |
| state | utf8 |
| state_detail | json |
| url | utf8 |
Example Queries
These SQL queries are sampled from CloudQuery policies and are compatible with PostgreSQL.
Unused Lightsail container services
WITH
deployment
AS (
SELECT
DISTINCT container_service_arn
FROM
aws_lightsail_container_service_deployments
)
SELECT
'Unused Lightsail container services' AS title,
cs.account_id,
cs.arn AS resource_id,
'fail' AS status
FROM
aws_lightsail_container_services AS cs
LEFT JOIN deployment ON deployment.container_service_arn = cs.arn
WHERE
deployment.container_service_arn IS NULL;