Skip to main content

registration_associations

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

Overview

Nameregistration_associations
TypeResource
Idaws.pinpoint_sms_voice_v2.registration_associations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
iso_country_codestringThe two-character code, in ISO 3166-1 alpha-2 format, for the country or region. (pattern: <code>[A-Z]{2}</code>)
phone_numberstringThe phone number associated with the registration in E.164 format. (pattern: <code>+?[1-9][0-9]{1,18}</code>)
resource_arnstringThe Amazon Resource Name (ARN) of the origination identity that is associated with the registration.
resource_idstringThe unique identifier for the origination identity. For example this could be a PhoneNumberId or SenderId.
resource_typestringThe origination identity type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_registration_associationsselectregionRetrieve all of the origination identities that are associated with a registration.
create_registration_associationinsertregion, RegistrationId, ResourceIdAssociate the registration with an origination identity such as a phone number or sender ID.

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

Retrieve all of the origination identities that are associated with a registration.

SELECT
iso_country_code,
phone_number,
resource_arn,
resource_id,
resource_type
FROM aws.pinpoint_sms_voice_v2.registration_associations
WHERE region = '{{ region }}' -- required
;

INSERT examples

Associate the registration with an origination identity such as a phone number or sender ID.

INSERT INTO aws.pinpoint_sms_voice_v2.registration_associations (
RegistrationId,
ResourceId,
region
)
SELECT
'{{ RegistrationId }}' /* required */,
'{{ ResourceId }}' /* required */,
'{{ region }}'
RETURNING
iso_country_code,
phone_number,
registration_arn,
registration_id,
registration_type,
resource_arn,
resource_id,
resource_type
;