[Bug] `stg_fivetran_log__log` sometimes failing unique test

[fivetran-catfritz]

Is there an existing issue for this?

• [X] I have searched the existing issues

Describe the issue

In stg_fivetran_log__log, the combination of columns log_id and created_at may not provide unique records as there are multiple event_subtypes and message_data records for those logs. As a result this table may fail a uniqueness test. Possibly batch updates in the connector.

Relevant error log or model output

See Catherine for screenshots/longer history as these are related to our data.

Expected behavior

Test passes.

dbt Project configurations

fivetran_log_using_triggers: false

Package versions

packages:

• git: https://github.com/fivetran/dbt_fivetran_log.git revision: customer/lord-skinner-update

What database are you using dbt with?

bigquery

dbt Version

1.3

Additional Context

No response

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

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

[fivetran-catfritz]

This is a duplicate of #34. Closing issue.