Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Transformations: XERO dbt Fix

Completed
bernhard feldmann User

INnthe Xero DBT project, that create sthe balance sheet report, tehre is a test for unique rows. thew test checks:

- source_relation
            - date_month
            - account_name

but this is not enough as sometimes, the same account name appears multiple times, becaus ethe company created a new one, os the test should also include:
            - account_code

the file is xero.yml
name of model: xero__balance_sheet_report

 

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Jimmy Fivetranner

    Hi Bernhard,

    This sounds pretty reasonable. I've added account_code in the uniqueness test for the xero__balance_sheet_report model to our backlog. We just need to ensure implementation won't cause side effects.

    Updates on this feature will be posted on this thread as progress is made.

    Thanks,
    Jimmy

  • bernhard feldmann User

    Thanks @jimmy, please let me know when this is being rolled out.

  • Jimmy Fivetranner

    Hi Bernhard,

    Go ahead and update to the latest version of this package. We've removed the test to solve for this and dbt fusion conformance. 

    When we do add the test back we will make sure to run the test on account_id, date_month, and source_relation to avoid issues where accounts have the same name.

    Thank you!

    Jimmy