Query: ec2_launch_configurations_for_ebs_snapshot

select
  launch_config.launch_configuration_arn as launch_configuration_arn
from
  aws_ec2_launch_configuration as launch_config,
  jsonb_array_elements(launch_config.block_device_mappings) as bdm,
  aws_ebs_snapshot as s
where
  bdm -> 'Ebs' ->> 'SnapshotId' = s.snapshot_id
  and s.snapshot_id = $1;