Skip to main content

endpoint_authorizations

Creates, updates, deletes, gets or lists an endpoint_authorizations resource.

Overview

Nameendpoint_authorizations
TypeResource
Idaws.redshift.endpoint_authorizations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
allowed_all_vpcsbooleanIndicates whether all VPCs in the grantee account are allowed access to the cluster.
allowed_vpcsstringThe VPCs allowed access to the cluster.
authorize_timestringThe time (UTC) when the authorization was created.
cluster_identifierstringThe cluster identifier.
cluster_statusstringThe status of the cluster.
endpoint_countintegerThe number of Redshift-managed VPC endpoints created for the authorization.
granteestringThe Amazon Web Services account ID of the grantee of the cluster.
grantorstringThe Amazon Web Services account ID of the cluster owner.
statusstringThe status of the authorization action.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_endpoint_authorizationselectregionClusterIdentifier, Account, Grantee, MaxRecords, MarkerDescribes an endpoint authorization.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)
AccountstringThe Amazon Web Services account ID of either the cluster owner (grantor) or grantee. If Grantee parameter is true, then the Account value is of the grantor.
ClusterIdentifierstringThe cluster identifier of the cluster to access.
GranteebooleanIndicates whether to check authorization from a grantor or grantee point of view. If true, Amazon Redshift returns endpoint authorizations that you've been granted. If false (default), checks authorization from a grantor point of view.
MarkerstringAn optional pagination token provided by a previous DescribeEndpointAuthorization request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by the MaxRecords parameter.
MaxRecordsintegerThe maximum number of records to include in the response. If more records exist than the specified MaxRecords value, a pagination token called a Marker is included in the response so that the remaining results can be retrieved.

SELECT examples

Describes an endpoint authorization.

SELECT
allowed_all_vpcs,
allowed_vpcs,
authorize_time,
cluster_identifier,
cluster_status,
endpoint_count,
grantee,
grantor,
status
FROM aws.redshift.endpoint_authorizations
WHERE region = '{{ region }}' -- required
AND ClusterIdentifier = '{{ ClusterIdentifier }}'
AND Account = '{{ Account }}'
AND Grantee = '{{ Grantee }}'
AND MaxRecords = '{{ MaxRecords }}'
AND Marker = '{{ Marker }}'
;