Connector Improvement: MARKETO _FIVETRAN_DELETED column
Please enhance the Marketo Connector to include a _FIVETRAN_DELETED column in destination tables, regardless of whether a row has already been deleted. It's not practical for us to wait until rows have been deleted before adding predicates to our data warehouse ETL processes. We would like to add the predicate "WHERE _FIVETRAN_DELETED = 0" to our ETL code before any rows are actually deleted so that we can avoid using these rows to populate our data warehouse.
Ideally, all of the Marketo tables should include _FIVETRAN_DELETED. If you can only add this feature to a limited number of tables, then please use this list of tables.
ACTIVITY_ADD_TO_WEBCASTS_ATTENDEE_DATA |
ACTIVITY_CLICK_EMAIL |
ACTIVITY_EMAIL_BOUNCED |
ACTIVITY_EMAIL_BOUNCED_SOFT |
ACTIVITY_EMAIL_DELIVERED |
ACTIVITY_FILL_OUT_FORM |
ACTIVITY_OPEN_EMAIL |
ACTIVITY_SEND_EMAIL |
ACTIVITY_TYPE |
ACTIVITY_UNSUBSCRIBE_EMAIL |
ACTIVITY_VISIT_WEBPAGE |
CAMPAIGN |
LEAD |
PROGRAM |
PROGRAM_TAG |
0
Please sign in to leave a comment.
Comments
0 comments