Xero package

This dbt package:

• Contains a DBT dimensional model based on Xero data from DataLakeHouse.io connector.
• The main use of this package is to provide a stable Snowflake dimensional model that will provide useful insights.

Models

The primary ouputs of this package are fact and dimension tables as listed below. There are several intermediate models used to create these models. Documentation can be found here.

Type	Model	Raw tables involved
Dimension	W_XER_ACCOUNTS_D	ACCOUNT
Dimension	W_XER_ASSETS_D	ASSET ASSET_TYPE
Dimension	W_XER_CURRENCY_D	Manually built
Dimension	W_XER_CONTACTS_D	CONTACTS CONTACT_GROUP_MEMBER CONTACT_GROUP
Dimension	W_XER_DATE_D	Manually built
Dimension	W_XER_EMPLOYEES_D	EMPLOYEE
Dimension	W_XER_ITEMS_D	ITEM
Fact	W_XER_JOURNAL_F	ORDER ORDER_LINE_ITEM ORDER_LINE_ITEM_MODIFIER
Fact	W_XER_PAYMENTS_F	PAYMENT
Fact	W_XER_INVOICES_F	INVOICE INVOICE_LINE_ITEM
Fact	W_XER_PURCHASE_ORDERS_F	PURCHASE_ORDER PURCHASE_ORDER_LINE_ITEM
Fact	W_XER_RECEIPTS_F	RECEIPT RECEIPT_LINE_ITEM

ERD of Dimensional Model

Data Lineage Graph

Installation Instructions

Check dbt Hub for the latest installation instructions, or read the docs for more information on installing packages.

Include in your packages.yml

packages:
  - package: datalakehouse/dlh_xero
    version: [">=0.1.0"]

Configuration

By default, this package uses DEVELOPER_SANDBOX as the source database name and DEMO_XERO as schema name. If this is not the where your Xero data is, change ther below variables configuration on your dbt_project.yml:

# dbt_project.yml

...

vars:    
    source_database: DEVELOPER_SANDBOX
    source_schema: DEMO_XERO
    target_schema: XERO

Database support

Core:

• Snowflake

Contributions

Additional contributions to this package are very welcome! Please create issues or open PRs against main. Check out this post on the best workflow for contributing to a package.

• Fork and ⭐ this repository :)
• Check it out and ⭐ the DataLakeHouse.io core repository;