Shopify bug can lead to multiple events with the same transaction id

[rlh1994]

Describe the bug

Shopify currently has a bug [citation needed] that leads to multiple events being sent with the same transaction id, all of them transaction events, but these are valid unique events with different event ids. This leads to the transactions model failing when it tries to upsert and finds multiples with the same id.

Steps to reproduce

N/A

Expected results

Only the first transaction event with that Id would be processed.

Actual results

All are processed as if they were distinct transactions

Screenshots and log output

System information

The contents of your packages.yml file:

# contents goes here

Which database are you using dbt with?

• postgres
• redshift
• bigquery
• snowflake
• other (specify: ____________)

The output of dbt --version:

<output goes here>

The operating system you're using:

The output of python --version:

Additional context

Are you interested in contributing the fix?

[rlh1994]

Can't reproduce