turbot/steampipe-mod-aws-compliance

Control: Glue connection SSL should be enabled

Description

Ensure Glue connection encryption SSL is enabled.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.glue_connection_ssl_enabled

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_compliance.control.glue_connection_ssl_enabled --share

SQL

This control uses a named query:

select
arn as resource,
case
when connection_properties ->> 'JDBC_ENFORCE_SSL' = 'true' then 'ok'
else 'alarm'
end as status,
case
when connection_properties ->> 'JDBC_ENFORCE_SSL' = 'true' then name || ' SSL enabled.'
else name || ' SSL disabled.'
end as reason
, region, account_id
from
aws_glue_connection;

Tags