Skip to content
AWS for Query.Farm

aws.groundstation.describe_contact

Example SQL Queries

SELECT * FROM
aws.groundstation.describe_contact
WHERE
"contact_id" = 'VALUE';

Description

Describes an existing contact.

Table Definition

Column NameColumn Data Type
contact_id Required Input Column

UUID of a contact.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
contact_status

Status of a contact.

VARCHAR
dataflow_list

List describing source and destination details for each dataflow edge.

STRUCT(
    "destination" STRUCT(
        "config_details" STRUCT(
            "antenna_demod_decode_details" STRUCT(
                "output_node" VARCHAR
            ),
            "endpoint_details" STRUCT(
                "aws_ground_station_agent_endpoint" STRUCT(
                    "agent_status" VARCHAR,
                    "audit_results" VARCHAR,
                    "egress_address" STRUCT(
                        "mtu" BIGINT,
                        "socket_address" STRUCT(
                            "name" VARCHAR,
                            "port" BIGINT
                        )
                    ),
                    "ingress_address" STRUCT(
                        "mtu" BIGINT,
                        "socket_address" STRUCT(
                            "name" VARCHAR,
                            "port_range" STRUCT(
                                "maximum" BIGINT,
                                "minimum" BIGINT
                            )
                        )
                    ),
                    "name" VARCHAR
                ),
                "endpoint" STRUCT(
                    "address" STRUCT(
                        "name" VARCHAR,
                        "port" BIGINT
                    ),
                    "mtu" BIGINT,
                    "name" VARCHAR,
                    "status" VARCHAR
                ),
                "health_reasons" VARCHAR[],
                "health_status" VARCHAR,
                "security_details" STRUCT(
                    "role_arn" VARCHAR,
                    "security_group_ids" VARCHAR[],
                    "subnet_ids" VARCHAR[]
                )
            ),
            "s3_recording_details" STRUCT(
                "bucket_arn" VARCHAR,
                "key_template" VARCHAR
            )
        ),
        "config_id" VARCHAR,
        "config_type" VARCHAR,
        "dataflow_destination_region" VARCHAR
    ),
    "error_message" VARCHAR,
    "source" STRUCT(
        "config_details" STRUCT(
            "antenna_demod_decode_details" STRUCT(
                "output_node" VARCHAR
            ),
            "endpoint_details" STRUCT(
                "aws_ground_station_agent_endpoint" STRUCT(
                    "agent_status" VARCHAR,
                    "audit_results" VARCHAR,
                    "egress_address" STRUCT(
                        "mtu" BIGINT,
                        "socket_address" STRUCT(
                            "name" VARCHAR,
                            "port" BIGINT
                        )
                    ),
                    "ingress_address" STRUCT(
                        "mtu" BIGINT,
                        "socket_address" STRUCT(
                            "name" VARCHAR,
                            "port_range" STRUCT(
                                "maximum" BIGINT,
                                "minimum" BIGINT
                            )
                        )
                    ),
                    "name" VARCHAR
                ),
                "endpoint" STRUCT(
                    "address" STRUCT(
                        "name" VARCHAR,
                        "port" BIGINT
                    ),
                    "mtu" BIGINT,
                    "name" VARCHAR,
                    "status" VARCHAR
                ),
                "health_reasons" VARCHAR[],
                "health_status" VARCHAR,
                "security_details" STRUCT(
                    "role_arn" VARCHAR,
                    "security_group_ids" VARCHAR[],
                    "subnet_ids" VARCHAR[]
                )
            ),
            "s3_recording_details" STRUCT(
                "bucket_arn" VARCHAR,
                "key_template" VARCHAR
            )
        ),
        "config_id" VARCHAR,
        "config_type" VARCHAR,
        "dataflow_source_region" VARCHAR
    )
)[]
Show child fields
dataflow_list[]
Show child fields
dataflow_list[].destination

Dataflow details for the destination side.

Show child fields
dataflow_list[].destination.config_details

Additional details for a Config, if type is dataflow endpoint or antenna demod decode.

Show child fields
dataflow_list[].destination.config_details.antenna_demod_decode_details

Details for antenna demod decode Config in a contact.

Show child fields
dataflow_list[].destination.config_details.antenna_demod_decode_details.output_node

Name of an antenna demod decode output node used in a contact.

dataflow_list[].destination.config_details.endpoint_details

Information about the endpoint details.

Show child fields
dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint

An agent endpoint.

Show child fields
dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.agent_status

The status of AgentEndpoint.

dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.audit_results

The results of the audit.

dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.egress_address

The egress address of AgentEndpoint.

Show child fields
dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.egress_address.mtu

Maximum transmission unit (MTU) size in bytes of a dataflow endpoint.

dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.egress_address.socket_address

A socket address.

Show child fields
dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.egress_address.socket_address.name

Name of a socket address.

dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.egress_address.socket_address.port

Port of a socket address.

dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address

The ingress address of AgentEndpoint.

Show child fields
dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.mtu

Maximum transmission unit (MTU) size in bytes of a dataflow endpoint.

dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.socket_address

A ranged socket address.

Show child fields
dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.socket_address.name

IPv4 socket address.

dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.socket_address.port_range

Port range of a socket address.

Show child fields
dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.socket_address.port_range.maximum

A maximum value.

dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.socket_address.port_range.minimum

A minimum value.

dataflow_list[].destination.config_details.endpoint_details.aws_ground_station_agent_endpoint.name

Name string associated with AgentEndpoint. Used as a human-readable identifier for AgentEndpoint.

dataflow_list[].destination.config_details.endpoint_details.endpoint

A dataflow endpoint.

Show child fields
dataflow_list[].destination.config_details.endpoint_details.endpoint.address

Socket address of a dataflow endpoint.

Show child fields
dataflow_list[].destination.config_details.endpoint_details.endpoint.address.name

Name of a socket address.

dataflow_list[].destination.config_details.endpoint_details.endpoint.address.port

Port of a socket address.

dataflow_list[].destination.config_details.endpoint_details.endpoint.mtu

Maximum transmission unit (MTU) size in bytes of a dataflow endpoint.

dataflow_list[].destination.config_details.endpoint_details.endpoint.name

Name of a dataflow endpoint.

dataflow_list[].destination.config_details.endpoint_details.endpoint.status

Status of a dataflow endpoint.

dataflow_list[].destination.config_details.endpoint_details.health_reasons[]
dataflow_list[].destination.config_details.endpoint_details.health_status

A dataflow endpoint health status. This field is ignored when calling CreateDataflowEndpointGroup.

dataflow_list[].destination.config_details.endpoint_details.security_details

Endpoint security details including a list of subnets, a list of security groups and a role to connect streams to instances.

Show child fields
dataflow_list[].destination.config_details.endpoint_details.security_details.role_arn

ARN to a role needed for connecting streams to your instances.

dataflow_list[].destination.config_details.endpoint_details.security_details.security_group_ids[]
dataflow_list[].destination.config_details.endpoint_details.security_details.subnet_ids[]
dataflow_list[].destination.config_details.s3_recording_details

Details for an S3 recording Config in a contact.

Show child fields
dataflow_list[].destination.config_details.s3_recording_details.bucket_arn

ARN of the bucket used.

dataflow_list[].destination.config_details.s3_recording_details.key_template

Key template used for the S3 Recording Configuration

dataflow_list[].destination.config_id

UUID of a Config.

dataflow_list[].destination.config_type

Type of a Config.

dataflow_list[].destination.dataflow_destination_region

Region of a dataflow destination.

dataflow_list[].error_message

Error message for a dataflow.

dataflow_list[].source

Dataflow details for the source side.

Show child fields
dataflow_list[].source.config_details

Additional details for a Config, if type is dataflow-endpoint or antenna-downlink-demod-decode

Show child fields
dataflow_list[].source.config_details.antenna_demod_decode_details

Details for antenna demod decode Config in a contact.

Show child fields
dataflow_list[].source.config_details.antenna_demod_decode_details.output_node

Name of an antenna demod decode output node used in a contact.

dataflow_list[].source.config_details.endpoint_details

Information about the endpoint details.

Show child fields
dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint

An agent endpoint.

Show child fields
dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.agent_status

The status of AgentEndpoint.

dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.audit_results

The results of the audit.

dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.egress_address

The egress address of AgentEndpoint.

Show child fields
dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.egress_address.mtu

Maximum transmission unit (MTU) size in bytes of a dataflow endpoint.

dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.egress_address.socket_address

A socket address.

Show child fields
dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.egress_address.socket_address.name

Name of a socket address.

dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.egress_address.socket_address.port

Port of a socket address.

dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address

The ingress address of AgentEndpoint.

Show child fields
dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.mtu

Maximum transmission unit (MTU) size in bytes of a dataflow endpoint.

dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.socket_address

A ranged socket address.

Show child fields
dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.socket_address.name

IPv4 socket address.

dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.socket_address.port_range

Port range of a socket address.

Show child fields
dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.socket_address.port_range.maximum

A maximum value.

dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.ingress_address.socket_address.port_range.minimum

A minimum value.

dataflow_list[].source.config_details.endpoint_details.aws_ground_station_agent_endpoint.name

Name string associated with AgentEndpoint. Used as a human-readable identifier for AgentEndpoint.

dataflow_list[].source.config_details.endpoint_details.endpoint

A dataflow endpoint.

Show child fields
dataflow_list[].source.config_details.endpoint_details.endpoint.address

Socket address of a dataflow endpoint.

Show child fields
dataflow_list[].source.config_details.endpoint_details.endpoint.address.name

Name of a socket address.

dataflow_list[].source.config_details.endpoint_details.endpoint.address.port

Port of a socket address.

dataflow_list[].source.config_details.endpoint_details.endpoint.mtu

Maximum transmission unit (MTU) size in bytes of a dataflow endpoint.

dataflow_list[].source.config_details.endpoint_details.endpoint.name

Name of a dataflow endpoint.

dataflow_list[].source.config_details.endpoint_details.endpoint.status

Status of a dataflow endpoint.

dataflow_list[].source.config_details.endpoint_details.health_reasons[]
dataflow_list[].source.config_details.endpoint_details.health_status

A dataflow endpoint health status. This field is ignored when calling CreateDataflowEndpointGroup.

dataflow_list[].source.config_details.endpoint_details.security_details

Endpoint security details including a list of subnets, a list of security groups and a role to connect streams to instances.

Show child fields
dataflow_list[].source.config_details.endpoint_details.security_details.role_arn

ARN to a role needed for connecting streams to your instances.

dataflow_list[].source.config_details.endpoint_details.security_details.security_group_ids[]
dataflow_list[].source.config_details.endpoint_details.security_details.subnet_ids[]
dataflow_list[].source.config_details.s3_recording_details

Details for an S3 recording Config in a contact.

Show child fields
dataflow_list[].source.config_details.s3_recording_details.bucket_arn

ARN of the bucket used.

dataflow_list[].source.config_details.s3_recording_details.key_template

Key template used for the S3 Recording Configuration

dataflow_list[].source.config_id

UUID of a Config.

dataflow_list[].source.config_type

Type of a Config.

dataflow_list[].source.dataflow_source_region

Region of a dataflow source.

end_time

End time of a contact in UTC.

TIMESTAMP_S
error_message

Error message for a contact.

VARCHAR
ground_station

Ground station for a contact.

VARCHAR
maximum_elevation

Maximum elevation angle of a contact.

STRUCT(
    "unit" VARCHAR,
    "value" DOUBLE
)
Show child fields
maximum_elevation.unit

Elevation angle units.

maximum_elevation.value

Elevation angle value.

mission_profile_arn

ARN of a mission profile.

VARCHAR
post_pass_end_time

Amount of time after a contact ends that you’d like to receive a CloudWatch event indicating the pass has finished.

TIMESTAMP_S
pre_pass_start_time

Amount of time prior to contact start you’d like to receive a CloudWatch event indicating an upcoming pass.

TIMESTAMP_S
region

Region of a contact.

VARCHAR
satellite_arn

ARN of a satellite.

VARCHAR
start_time

Start time of a contact in UTC.

TIMESTAMP_S
tags

Tags assigned to a contact.

MAP(VARCHAR, VARCHAR)
visibility_end_time

Projected time in UTC your satellite will set below the receive mask. This time is based on the satellite's current active ephemeris for future contacts and the ephemeris that was active during contact execution for completed contacts. 

TIMESTAMP_S
visibility_start_time

Projected time in UTC your satellite will rise above the receive mask. This time is based on the satellite's current active ephemeris for future contacts and the ephemeris that was active during contact execution for completed contacts. 

TIMESTAMP_S