Skip to main content

endpoint_accesses_list_only

Lists endpoint_accesses in a region or regions, for all properties use endpoint_accesses

Overview

Nameendpoint_accesses_list_only
TypeResource
DescriptionResource schema for a Redshift-managed VPC endpoint.
Idaws.redshift.endpoint_accesses_list_only

Fields

NameDatatypeDescription
endpoint_statusstringThe status of the endpoint.
vpc_endpointobjectThe connection endpoint for connecting to an Amazon Redshift cluster through the proxy.
addressstringThe DNS address of the endpoint.
endpoint_namestringThe name of the endpoint.
vpc_security_group_idsarrayA list of vpc security group ids to apply to the created endpoint access.
resource_ownerstringThe AWS account ID of the owner of the cluster.
subnet_group_namestringThe subnet group name where Amazon Redshift chooses to deploy the endpoint.
portintegerThe port number on which the cluster accepts incoming connections.
endpoint_create_timestringThe time (UTC) that the endpoint was created.
cluster_identifierstringA unique identifier for the cluster. You use this identifier to refer to the cluster for any subsequent cluster operations such as deleting or modifying. All alphabetical characters must be lower case, no hypens at the end, no two consecutive hyphens. Cluster name should be unique for all clusters within an AWS account
vpc_security_groupsarrayA list of Virtual Private Cloud (VPC) security groups to be associated with the endpoint.
regionstringAWS region.

Methods

NameAccessible byRequired Params
list_resourcesSELECTregion

SELECT examples

Lists all endpoint_accesses in a region.

SELECT
region,
endpoint_name
FROM aws.redshift.endpoint_accesses_list_only
WHERE region = 'us-east-1';

Permissions

For permissions required to operate on the endpoint_accesses_list_only resource, see endpoint_accesses