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 during a sync run when Polytomic encountered this row as newly-created.
• _polytomic_updated_at: the timestamp during a sync run when Polytomic encountered this row as newly-updated.
• _polytomic_deleted_at: the timestamp when Polytomic first detected that this row was hard-deleted. Note that this detection may occur before a sync run especially if CDC (Change Data Capture) is enabled at the source. Note that if the source row is soft-deleted, this column will remain marked as null.

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.