Fivetran offers a pre-built connector into ServiceNow to grab data and send it out to other systems like Snowflake. From a recent setup, we wound up doing a bit of back and forth to get everything aligned coming out of ServiceNow into Fivetran so I wanted to highlight a few things. All of the info I'm showing here was pulled from https://fivetran.com/docs/connectors/applications/servicenow.
1. Table Access - Fivetran recommends giving the Service Account admin access along with snc_read_only. This may wind up being a no-go with your security team, but you should consider it just to get things going once the initial setup is complete.
2. Partial Syncs - Fivetran determines what to sync on a incremental sync by accessing the sys_updated_on field. Ensure your Service Account has access to this field everywhere you want the data extracted to avoid full syncs every time.
3. Joining Tables - Be prepared to join tables in the destination system to get access to reference data
4. Reference Data - Reference fields will be split into links and values as they pass through Fivetran
5. Field Types - There is a set list of supported field types in Fivetran's documentation. Anything not on that list won't show up and can lead to mismatched counts. No screen shot for this one, but the full list of 37 fields is available at https://fivetran.com/docs/connectors/applications/servicenow#syncingcolumnsfromparenttablestochildta...
