steampipe plugin install awssteampipe plugin install aws

Table: aws_glue_connection

An AWS Glue connection is a Data Catalog object that stores connection information for a particular data store. Connections store login credentials, URI strings, virtual private cloud (VPC) information, and more. Creating connections in the Data Catalog saves the effort of having to specify all connection details every time you create a crawler or job. You can use connections for both sources and targets.

Examples

Basic info

select
  name,
  connection_type,
  creation_time,
  description,
  region
from
  aws_glue_connection;

List connection properties for JDBC connections

select
  name,
  connection_type,
  connection_properties ->> 'JDBC_CONNECTION_URL' as connection_url,
  connection_properties ->> 'JDBC_ENFORCE_SSL' as ssl_enabled,
  creation_time
from
  aws_glue_connection
where
  connection_type = 'JDBC';

List mongodb connections with ssl disabled

select
  name,
  connection_type,
  connection_properties ->> 'CONNECTION_URL' as connection_url,
  connection_properties ->> 'JDBC_ENFORCE_SSL' as ssl_enabled,
  creation_time
from
  aws_glue_connection
where
  connection_type = 'JDBC'
  and connection_properties ->> 'JDBC_ENFORCE_SSL' = 'false';

List connection vpc details

select
  c.name as connection_name,
  s.vpc_id as vpc_id,
  s.title as subnet_name,
  physical_connection_requirements ->> 'SubnetId' as subnet_id,
  physical_connection_requirements ->> 'AvailabilityZone' as availability_zone,
  cidr_block,
  physical_connection_requirements ->> 'SecurityGroupIdList' as security_group_ids
from
  aws_glue_connection c
  join aws_vpc_subnet s on physical_connection_requirements ->> 'SubnetId' = s.subnet_id;

.inspect aws_glue_connection

AWS Glue Connection

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
arn	text	The Amazon Resource Name (ARN) of the connection.
connection_properties	jsonb	These key-value pairs define parameters for the connection.
connection_type	text	The type of the connection. Currently, SFTP is not supported.
creation_time	timestamp with time zone	The time that this connection definition was created.
description	text	The description of the connection.
last_updated_by	text	The user, group, or role that last updated this connection definition.
last_updated_time	timestamp with time zone	The last time that this connection definition was updated.
match_criteria	jsonb	A list of criteria that can be used in selecting this connection.
name	text	The name of the connection definition.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
physical_connection_requirements	jsonb	A map of physical connection requirements, such as virtual private cloud (VPC) and SecurityGroup, that are needed to make this connection successfully.
region	text	The AWS Region in which the resource is located.
title	text	Title of the resource.

turbot/aws