How do I get the most recent status of a deal?
You can get the latest status entry from the
Deal_History table. Despite multiple entries for a
deal Id in this table, there will only be one active entry with _fivetran_active = true at a time which reflects the latest details of a deal.
Deal_History table may contain multiple entries for one deal.