Question 1

Which objects can I select?

Accepted Answer

Admins, companies, contacts, conversations, conversation parts, tags, teams, tickets, ticket parts and ticket types. Conversation parts and ticket parts are the ones worth understanding, since they hold the individual messages rather than the thread header.

Question 2

What reads incrementally?

Accepted Answer

Contacts and conversations do an initial load and then refresh on updated at. Tickets and ticket parts do the same after an initial history load. Conversation parts are refreshed for whichever conversations that incremental process surfaced. Admins, companies, tags, teams and ticket types are a full API scan on every ETL run, which is acceptable because they are small reference tables.

Question 3

Do deletes come through?

Accepted Answer

Not reliably, and this is the main caveat. The connector has no Intercom delete or tombstone feed. Objects read by full scan can have missing records reconciled by the bulk sync when destination deletes are enabled, but for incrementally read objects a hard delete is not reliably detected. Archiving usually arrives as an ordinary update instead, wherever Intercom exposes the status field.

Question 4

What does the connection need?

Accepted Answer

OAuth, and one detail catches people out: Intercom requires an account with read and write permission even though Polytomic is only reading. There is no token to paste into hosted Polytomic, you click connect and authorize. A dedicated Intercom user is optional but makes the audit trail clearer later.

Question 5

Why keep support data in Postgres?

Accepted Answer

Because the join is the whole point. Conversation volume per account, response times by plan tier, ticket counts against renewal dates: none of those can be answered inside Intercom on its own. Once conversations sit beside your account tables, they become ordinary SQL rather than an export and a spreadsheet.

Sync Intercom to PostgreSQL

Sync Intercom to PostgreSQL with Polytomic

Conversations and tickets

Incremental on updated at

Reference tables read whole

Or sync PostgreSQL to Intercom

Trusted by businesses worldwide

Step-by-step integration guide

Connect Intercom in Polytomic

Connect PostgreSQL in Polytomic

Create a sync between Intercom and PostgreSQL

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect Intercom with PostgreSQL?