GuidesRecipesAPI ReferenceChangelog
HomeSee demo
Guides

Polytomic timestamp columns

By default, Polytomic will create three datetime columns in your destination store for each bulk sync table:

  • _polytomic_created_at: the timestamp of the sync run that created this row for the first time.
  • _polytomic_updated_at: the timestamp of the sync run that last updated this row.
  • _polytomic_deleted_at: the timestamp of the sync run that detected the row as hard-deleted in the source system. The value for this column remains null if the row is only soft-deleted in the source system.

You can turn off the writing of these columns by going to Advanced settings in Stage 4 of your sync configuration and ticking the Exclude Polytomic timestamp columns box.