The _polytomic_id column

Unique row identifier

When using Polytomic's Bulk Syncs to move data into data warehouses, databases, or cloud storage buckets, every row in the destination will have a column named _polytomic_id (in addition to our timestamp columns ). This column will contain a unique value for that row. Its value is calculated in the following manner:

• If the source table has a single primary key, _polytomic_id will be a literal copy of that. Salesforce is an example: many of its tables come with a native Id primary key. In those situations _polytomic_id will contain the same value as Salesforce's Id field.
• If the source table has multiple primary keys, _polytomic_id will be a hash of those primary keys. For example, in the case of the Facebook Ads ad_insights table, _polytomic_id will be a hash of these columns on the ad_insights table: (account_id, ad_id, adset_id, campaign_id).
• If the source has no primary keys, _polytomic_id will be a hash of all columns in the row. This means that any change to any column in your source data will result in a different _polytomic_id for the row on next sync.

Finding out primary keys

You can see the set of primary keys in your Polytomic bulk sync table configuration. Any primary key will be marked with a key icon per example screenshot below: