Skip to content
AWS for Query.Farm

aws.directconnect.describe_locations

Example SQL Queries

SELECT * FROM
aws.directconnect.describe_locations;

Description

Lists the Direct Connect locations in the current Amazon Web Services Region. These are the locations that can be selected when calling CreateConnection or CreateInterconnect.

Table Definition

Column NameColumn Data Type
locations

The locations.

STRUCT(
    "location_code" VARCHAR,
    "location_name" VARCHAR,
    "region" VARCHAR,
    "available_port_speeds" VARCHAR[],
    "available_providers" VARCHAR[],
    "available_mac_sec_port_speeds" VARCHAR[]
)[]
Show child fields
locations[]
Show child fields
locations[].available_mac_sec_port_speeds[]
locations[].available_port_speeds[]
locations[].available_providers[]
locations[].location_code

The code for the location.

locations[].location_name

The name of the location. This includes the name of the colocation partner and the physical site of the building.

locations[].region

The Amazon Web Services Region for the location.