[Feature] Add more context for fivetran_id in ymls

[fivetran-reneeli]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

We added more fields to the unique test for the apple_search_ads__search_term_report end model so now it is the following (Pr #18):

        - search_term_text
        - match_type
        - date_day
        - keyword_id
        - ad_group_id
        - campaign_id
        - organization_id

But in the respective staging model it is:

        - _fivetran_id
        - date_day

Once we figure out how _fivetran_id gets generated (which fields do the engineers use to hash) and if it's the same fields as the aforementioned then we should add more to the definition in the yml. If not, we should consider swapping it out to use those fields.

Describe alternatives you've considered

na

Are you interested in contributing this feature?

• Yes.
• Yes, but I will need assistance and will schedule time during your office hours for guidance.
• No.

Anything else?

na