[Bug] Test error on balance transactions

[benigls]

Is there an existing issue for this?

• [X] I have searched the existing issues

Describe the issue

I encountered a test error in the recurly__balance_transactions model about duplicate balance_transaction_id. See the log below

07:47:04  Failure in test unique_recurly__balance_transactions_balance_transaction_id (models/recurly.yml)
07:47:04    Got 1644 results, configured to fail if != 0
07:47:04  
07:47:04    compiled Code at target/compiled/recurly/models/recurly.yml/unique_recurly__balance_transactions_balance_transaction_id.sql

Looking at one of the accounts in our recurly dashboard, I see that they have multiple failed transactions, see the photo below

The failed transaction also appeared in the raw dataset inside the transaction table

-- query
select invoice_id, payment_method_card_type, created_at, status_code from raw.recurly.transaction where invoice_id = '...'

I believe that the multiple failed transactions are causing the test failures because the transaction table is included in the recurly__balance_transactions model.

Relevant error log or model output

No response

Expected behavior

The package would handle multiple failed transactions with no test error.

dbt Project configurations

recurly_database: raw recurly_schema: recurly

recurly__using_credit_payment_history: false

Package versions

• package: fivetran/recurly version: 0.3.0

What database are you using dbt with?

bigquery

dbt Version

1.4.3

Additional Context

No response

Are you willing to open a PR to help address this issue?

• [ ] Yes.
• [ ] Yes, but I will need assistance and will schedule time during our office hours for guidance
• [X] No.

[fivetran-avinash]

Thanks for bringing this to our attention @benigls! This is the same issue that @dylanwatt was reporting on, but this is the repo where we'll be submitting the PR, so thanks for creating it here. We plan on making this fix by at least the coming sprint.

[fivetran-avinash]

Hi @benigls, we've deploye test fixes to our packages in our latest releases to dbt_recurly. Try it out and let us know what you think!