[Discussion] Update tests or models for multiple application_id records for a given opportunity_id

[fivetran-catfritz]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

As of v0.6.0 and with our test data (will be provided in internal ticket), we sometimes have multiple application_id records associated with a given opportunity_id. This causes uniqueness test failures for lever__opportunity_enhanced and its upstream int models, which we should resolve.

How would you implement this feature?

We need to determine if the model needs to be adjusted to ensure only one record per opportunity_id is created, or if we should update the combination of column tests to add application_id.

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

• Yes.
• Yes, but I will need assistance.
• No.

Anything else?

No response

[fivetran-catfritz]

According to the Lever API Docs:

Candidates can be applied to multiple job postings, meaning that candidates can have multiple applications. A candidate or contact may have multiple applications, each of which will be on a unique Opportunity. An Opportunity will have no more than one Application.

However, when reviewing our test data, we occasionally see multiple applications associated with a single opportunity. Given this discrepancy and the uncertainty around whether our test data can be trusted as a source of truth, we will maintain the current state of the tests for now.

We'll keep this ticket open for input from anyone with additional insights!