Linking AWS End User Messaging as a source
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

The AWS End User Messaging connector syncs SMS and voice resources from AWS End User Messaging (formerly Amazon Pinpoint SMS) into PostHog. It reads from one AWS region, so connect one source per region you use.
This source syncs account-level resource data from the SMS and Voice v2 API. The API does not return sent or received messages. To analyze message events, send them from a configuration set to an event destination such as Amazon S3, then connect that bucket with the S3 source.
Prerequisites
You need an AWS account with End User Messaging SMS enabled in the region you want to sync.
You also need an IAM user or role with the sms-voice:Describe* actions, or only the specific actions for the tables you select:
sms-voice:DescribePhoneNumberssms-voice:DescribePoolssms-voice:DescribeSenderIdssms-voice:DescribeConfigurationSetssms-voice:DescribeOptOutListssms-voice:DescribeOptedOutNumberssms-voice:DescribeKeywordssms-voice:DescribeRegistrationssms-voice:DescribeVerifiedDestinationNumberssms-voice:DescribeProtectConfigurationssms-voice:DescribeSpendLimitssms-voice:DescribeAccountAttributessms-voice:DescribeAccountLimits
Some tables depend on other tables during sync (fan-out). If you select these tables, grant permissions for their parent tables too:
opted_out_numbers - Also requires
sms-voice:DescribeOptOutLists, because PostHog first lists opt-out lists and then queries opted-out numbers from each one.keywords - Also requires
sms-voice:DescribePhoneNumbersandsms-voice:DescribePools, because PostHog first lists phone numbers and pools and then queries keywords from each one.
Adding a data source
- In PostHog, go to the Sources tab of the data pipeline section.
- Click + New source and click Link next to this source.
- Enter your credentials (see Configuration below) and click Next.
- Select the tables you want to sync, choose a sync method and frequency, then click Import.
Once the syncs are complete, you can start querying this data in PostHog.
When linking AWS End User Messaging, you need:
- AWS access key ID - The access key ID for your IAM user or role (starts with
AKIA...). - AWS secret access key - The corresponding secret access key.
- AWS region - The region to sync from, like
us-east-1. - AWS session token (optional) - Only required if you are using temporary STS credentials. Temporary credentials expire, so update them before the next scheduled sync.
Creating IAM credentials
- In the AWS Console, go to IAM > Users and create a new user (or use an existing one).
- Attach a policy with the following permissions:
If you only want to sync specific tables, replace sms-voice:Describe* with the individual actions listed in Prerequisites.
- Create an access key for the user under Security credentials > Access keys.
- Copy the Access key ID and Secret access key. You need both when linking the source in PostHog.
Sync modes
Each table can be synced in one of several modes, depending on what the source supports:
- Webhook (when available) – the source pushes changes to PostHog in real time. Fastest freshness, lowest ongoing cost, and the only mode that reliably captures updates and deletes.
- Incremental – only new or updated rows are synced on each run, using a cursor field (such as an
updated_attimestamp). Cheaper than a full refresh, but deletes aren't captured. - Append only – new rows are appended using a cursor field; existing rows are never updated. Ideal for immutable, append-only tables like event logs.
- Full refresh – the whole table is reloaded on every sync. Use it when a table has no reliable cursor or when you need deletions reflected.
See sync methods for a full explanation of how each mode works and how to choose between them.
All tables use full refresh sync because the SMS and Voice v2 API has no time filter parameter that would enable incremental sync.
Configuration
| Option | Description |
|---|---|
AWS access key IDType: text Required: True | |
AWS secret access keyType: password Required: True | |
AWS session tokenType: password Required: False | Temporary credentials expire. Update them before the next scheduled sync. |
AWS regionType: text Required: True |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
phone_numbers | Origination phone numbers in the account, with their type, capabilities, and status. | Full refresh | — | — |
pools | Pools of origination identities, with their two-way and opt-out settings. | Full refresh | — | — |
sender_ids | Sender IDs in the account, with their country, message types, and registration state. | Full refresh | — | — |
configuration_sets | Configuration sets, with their event destinations and default sending settings. | Full refresh | — | — |
opt_out_lists | Opt-out lists in the account. | Full refresh | — | — |
opted_out_numbers | Destination phone numbers in each opt-out list, with the time they opted out. | Full refresh | — | — |
keywords | Keywords on each phone number and pool, with the message and action for each keyword. | Full refresh | — | — |
registrations | Registrations for phone numbers and sender IDs, with their type, status, and versions. | Full refresh | — | — |
verified_destination_numbers | Destination phone numbers that are verified for sending from a simulator or sandbox account. | Full refresh | — | — |
protect_configurations | Protect configurations that control which countries messages can go to. | Full refresh | — | — |
spend_limits | Monthly spend limits for text, voice, and media messages. | Full refresh | — | — |
account_attributes | Account attributes, such as the account tier and the default protect configuration. | Full refresh | — | — |
account_limits | Account quotas, with the quantity in use and the maximum for each resource type. | Full refresh | — | — |
Available tables
- phone_numbers - Origination phone numbers in the account, with their type, capabilities, and status.
- pools - Pools of origination identities, with their two-way and opt-out settings.
- sender_ids - Sender IDs in the account, with their country, message types, and registration state.
- configuration_sets - Configuration sets, with their event destinations and default sending settings.
- opt_out_lists - Opt-out lists in the account.
- opted_out_numbers - Destination phone numbers in each opt-out list, with the time they opted out.
- keywords - Keywords on each phone number and pool, with the message and action for each keyword.
- registrations - Registrations for phone numbers and sender IDs, with their type, status, and versions.
- verified_destination_numbers - Destination phone numbers that are verified for sending from a simulator or sandbox account.
- protect_configurations - Protect configurations that control which countries messages can go to.
- spend_limits - Monthly spend limits for text, voice, and media messages.
- account_attributes - Account attributes, such as the account tier and the default protect configuration.
- account_limits - Account quotas, with the quantity in use and the maximum for each resource type.
Troubleshooting
- If you see "AWS rejected the access key ID", check that the access key ID is correct and that the key is still active in IAM.
- If you see a signature error, re-enter the secret access key. If you are using temporary credentials, the session token may have expired.
- If you see "AWS session token expired", connect again with current credentials.
- If you see "AWS denied access", grant the IAM user or role the
sms-voice:Describe*actions for the tables you select. For fan-out tables likeopted_out_numbersandkeywords, also grant the parent table actions listed in Prerequisites. - If you see "Enable AWS End User Messaging SMS", enable the service in your AWS account and region, then try again.
If your sync is failing or data looks wrong, see the Data warehouse troubleshooting guide. If that doesn't help, contact support – we're happy to help.





