How Does Fivetran Use the ServiceNow System Tables?

Question

How does Fivetran use the ServiceNow sys_audit and sys_audit_delete tables? Is read access required, and does deleting data from those tables impact syncs?

Environment

Connector: ServiceNow

Answer

We don't require access to the sys_audit table. We don't use it to detect new or updated records during syncs, and cleaning up or archiving data in this table doesn't affect sync behavior. Since this table can be very large, we recommend excluding it from your connection schema.

However, we require the ability to query the sys_audit_delete table because we use it to detect records that were deleted between syncs. You don't need to include this table in your connection schema. If you delete data from this table between syncs, we may miss delete events that occurred during that time. Deleting older entries, such as those from before the last successful sync, won't affect the sync process.