Guides
Primary Keys
Guides
Primary Keys
How Bracket uniquely identifies records
Summary
To support safe syncing, Bracket matches records based on their primary key. Below, we layout what Bracket uses for primary keys depending on the data source, and if there is any prep work needed from you.
| Tool | Primary key | Preparation needed? |
|---|---|---|
| Postgres | Unique field created by Bracket or user | Potentially, see guide |
| Salesforce | Salesforce Record ID | No |
| Hubspot | Hubspot record ID | No |
| Airtable | Airtable record ID | No |
| Google Sheets | Unique field created by user | Yes, see guide |
| MySQL | Unique field created by user | Yes |
| MongoDB | MongoDB object ID | No |
| Firestore | Firestore document ID | No |
| Snowflake | Unique field created by user | Yes, see guide |
| Notion | Notion object ID | No |