Welcome!
Welcome to the auto-generated documentation for your dbt project!
Navigation
You can use the Project and Database navigation tabs on the left side of the window to explore the models
in your project.
Project Tab
The Project tab mirrors the directory structure of your dbt project. In this tab, you can see all of the
models defined in your dbt project, as well as models imported from dbt packages.
Database Tab
The Database tab also exposes your models, but in a format that looks more like a database explorer. This view
shows relations (tables and views) grouped into database schemas. Note that ephemeral models are not shown
in this interface, as they do not exist in the database.
Graph Exploration
You can click the blue icon on the bottom-right corner of the page to view the lineage graph of your models.
On model pages, you'll see the immediate parents and children of the model you're exploring. By clicking the Expand
button at the top-right of this lineage pane, you'll be able to see all of the models that are used to build,
or are built from, the model you're exploring.
Once expanded, you'll be able to use the --select and --exclude model selection syntax to filter the
models in the graph. For more information on model selection, check out the dbt docs.
Note that you can also right-click on models to interactively filter and explore the graph.
More information
- What is dbt?
- Read the dbt viewpoint
- Installation
- Join the dbt Community for questions and discussion
327 search results
stg_xero__invoice_line_item_tmp model
columns:
_dbt_source_relation,
_dbt_source_relation
Show -2 more
{{
fivetran_utils.union_data(
table_identifier='invoice_line_item',
database_variable='xero_database',
schema_variable='xero_schema',
default_database=target.database,
default_schema='xero',
default_variable='invoice_line_item'
)
}}
stg_xero__invoice_line_item model
Each record in this able represents an invoice line item in Xero.
columns:
_fivetran_synced,
_fivetran_synced
columns:
account_code,
account_code
columns:
line_item_description,
line_item_description
Show 11 more
with base as (
select *
from {{ ref('stg_xero__invoice_line_item_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_xero__invoice_line_item_tmp')),
staging_columns=get_invoice_line_item_columns()
)
}}
{{ fivetran_utils.add_dbt_source_relation() }}
from base
),
final as (
select
_fivetran_synced,
account_code,
description as line_item_description,
discount_entered_as_percent,
discount_rate,
invoice_id,
item_code,
line_amount,
line_item_id,
quantity,
tax_amount,
tax_type,
unit_amount
{{ fivetran_utils.source_relation() }}
from fields
)
select * from final
stg_xero__invoice model
Each record in this table represents an invoice in Xero.
columns:
invoice_id,
invoice_id
columns:
contact_id,
contact_id
columns:
invoice_date,
invoice_date
Show 15 more
with base as (
select *
from {{ ref('stg_xero__invoice_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_xero__invoice_tmp')),
staging_columns=get_invoice_columns()
)
}}
{{ fivetran_utils.add_dbt_source_relation() }}
from base
),
final as (
select
-- IDs
invoice_id,
contact_id,
-- dates
date as invoice_date,
updated_date_utc as updated_date,
planned_payment_date,
due_date,
expected_payment_date,
fully_paid_on_date,
_fivetran_synced,
currency_code,
currency_rate,
invoice_number,
reference,
sent_to_contact as is_sent_to_contact,
status as invoice_status,
type,
url
{{ fivetran_utils.source_relation() }}
from fields
)
select * from final
stg_xero__credit_note_tmp model
columns:
_dbt_source_relation,
_dbt_source_relation
Show -2 more
{{ config(enabled=var('xero__using_credit_note', True)) }}
{{
fivetran_utils.union_data(
table_identifier='credit_note',
database_variable='xero_database',
schema_variable='xero_schema',
default_database=target.database,
default_schema='xero',
default_variable='credit_note'
)
}}
stg_xero__credit_note model
columns:
credit_note_id,
credit_note_id
columns:
contact_id,
contact_id
columns:
source_relation,
source_relation
Show 0 more
{{ config(enabled=var('xero__using_credit_note', True)) }}
with base as (
select *
from {{ ref('stg_xero__credit_note_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_xero__credit_note_tmp')),
staging_columns=get_credit_note_columns()
)
}}
{{ fivetran_utils.add_dbt_source_relation() }}
from base
),
final as (
select
credit_note_id,
contact_id
{{ fivetran_utils.source_relation() }}
from fields
)
select * from final
stg_xero__contact_tmp model
columns:
_dbt_source_relation,
_dbt_source_relation
Show -2 more
{{
fivetran_utils.union_data(
table_identifier='contact',
database_variable='xero_database',
schema_variable='xero_schema',
default_database=target.database,
default_schema='xero',
default_variable='contact'
)
}}
stg_xero__contact model
Each record in this table represents a contact in Xero.
columns:
contact_id,
contact_id
columns:
contact_name,
contact_name
columns:
source_relation,
source_relation
Show 0 more
with base as (
select *
from {{ ref('stg_xero__contact_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_xero__contact_tmp')),
staging_columns=get_contact_columns()
)
}}
{{ fivetran_utils.add_dbt_source_relation() }}
from base
),
final as (
select
contact_id,
name as contact_name
{{ fivetran_utils.source_relation() }}
from fields
where _fivetran_deleted = False
)
select * from final
stg_xero__bank_transaction_tmp model
columns:
_dbt_source_relation,
_dbt_source_relation
Show -2 more
{{ config(enabled=var('xero__using_bank_transaction', True)) }}
{{
fivetran_utils.union_data(
table_identifier='bank_transaction',
database_variable='xero_database',
schema_variable='xero_schema',
default_database=target.database,
default_schema='xero',
default_variable='bank_transaction'
)
}}
stg_xero__bank_transaction model
columns:
bank_transaction_id,
bank_transaction_id
columns:
contact_id,
contact_id
columns:
source_relation,
source_relation
Show 0 more
{{ config(enabled=var('xero__using_bank_transaction', True)) }}
with base as (
select *
from {{ ref('stg_xero__bank_transaction_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_xero__bank_transaction_tmp')),
staging_columns=get_bank_transaction_columns()
)
}}
{{ fivetran_utils.add_dbt_source_relation() }}
from base
),
final as (
select
bank_transaction_id,
contact_id
{{ fivetran_utils.source_relation() }}
from fields
)
select * from final
stg_xero__account_tmp model
columns:
_dbt_source_relation,
_dbt_source_relation
Show -2 more
{{
fivetran_utils.union_data(
table_identifier='account',
database_variable='xero_database',
schema_variable='xero_schema',
default_database=target.database,
default_schema='xero',
default_variable='account'
)
}}
stg_xero__account model
Each record in this table represents an account in Xero.
columns:
account_id,
account_id
columns:
account_name,
account_name
columns:
account_code,
account_code
Show 4 more
with base as (
select *
from {{ ref('stg_xero__account_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_xero__account_tmp')),
staging_columns=get_account_columns()
)
}}
{{ fivetran_utils.add_dbt_source_relation() }}
from base
),
final as (
select
account_id,
name as account_name,
code as account_code,
type as account_type,
class as account_class,
_fivetran_synced
{{ fivetran_utils.source_relation() }}
from fields
)
select * from final
xero_organization_data seed
columns:
organisation_id,
organisation_id
columns:
financial_year_end_month,
financial_year_end_month
columns:
financial_year_end_day,
financial_year_end_day
Show 0 more
xero_journal_line_data seed
columns:
journal_line_id,
journal_line_id
columns:
account_code,
account_code
columns:
account_id,
account_id
Show 9 more
xero_journal_data seed
columns:
journal_id,
journal_id
columns:
created_date_utc,
created_date_utc
columns:
journal_date,
journal_date
Show 4 more
xero_invoice_line_item_data seed
columns:
_fivetran_synced,
_fivetran_synced
columns:
account_code,
account_code
columns:
description,
description
Show 11 more
xero_invoice_data seed
xero_credit_note_data seed
xero_contact_data seed
columns:
contact_id,
contact_id
columns:
name,
name
columns:
_fivetran_deleted,
_fivetran_deleted
Show 0 more