turbot/kubernetes_insights

Query: container_input

Usage

powerpipe query kubernetes_insights.query.container_input

Steampipe Tables

SQL

with containers as (
select
distinct c ->> 'name' as container_name,
name,
context_name
from
kubernetes_pod,
jsonb_array_elements(containers) as c
)
select
container_name as label,
concat(container_name,name) as value,
json_build_object(
'name', name,
'context_name', context_name
) as tags
from
containers
order by
container_name;