Skip to main content

relays

Creates, updates, deletes, gets or lists a relays resource.

Overview

Namerelays
TypeResource
Idaws.mailmanager.relays

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
authenticationobjectThe authentication attribute—contains the secret ARN where the customer relay server credentials are stored.
created_timestampstring (date-time)The timestamp of when the relay was created.
last_modified_timestampstring (date-time)The timestamp of when relay was last updated.
relay_arnstringThe Amazon Resource Name (ARN) of the relay.
relay_idstringThe unique relay identifier. (pattern: <code>[a-zA-Z0-9-]+</code>)
relay_namestringThe unique name of the relay. (pattern: <code>[a-zA-Z0-9-_]+</code>)
server_namestringThe destination relay server address. (pattern: <code>[a-zA-Z0-9-.]+</code>)
server_portintegerThe destination relay server port.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_relayselectregionFetch the relay resource and it's attributes.
list_relaysselectregionLists all the existing relay resources.
create_relayinsertregion, RelayName, ServerName, ServerPortCreates a relay resource which can be used in rules to relay incoming emails to defined relay destinations.
update_relayupdateregion, RelayIdUpdates the attributes of an existing relay resource.
delete_relaydeleteregionDeletes an existing relay resource.

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)

SELECT examples

Fetch the relay resource and it's attributes.

SELECT
authentication,
created_timestamp,
last_modified_timestamp,
relay_arn,
relay_id,
relay_name,
server_name,
server_port
FROM aws.mailmanager.relays
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates a relay resource which can be used in rules to relay incoming emails to defined relay destinations.

INSERT INTO aws.mailmanager.relays (
ClientToken,
RelayName,
ServerName,
ServerPort,
Authentication,
Tags,
region
)
SELECT
'{{ ClientToken }}',
'{{ RelayName }}' /* required */,
'{{ ServerName }}' /* required */,
{{ ServerPort }} /* required */,
'{{ Authentication }}',
'{{ Tags }}',
'{{ region }}'
RETURNING
relay_id
;

UPDATE examples

Updates the attributes of an existing relay resource.

UPDATE aws.mailmanager.relays
SET
RelayId = '{{ RelayId }}',
RelayName = '{{ RelayName }}',
ServerName = '{{ ServerName }}',
ServerPort = {{ ServerPort }},
Authentication = '{{ Authentication }}'
WHERE
region = '{{ region }}' --required
AND RelayId = '{{ RelayId }}' --required;

DELETE examples

Deletes an existing relay resource.

DELETE FROM aws.mailmanager.relays
WHERE region = '{{ region }}' --required
;