icons
Lineage Graph

Welcome!

Welcome to the auto-generated documentation for your dbt project!

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 --models 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

445 search results

stg_quickbooks__payment model

...Table containing all payment records. The payment can be applied for a part...

columns: payment_id, payment_id columns: unapplied_amount, unapplied_amount columns: total_amount, total_amount Show 7 more
...--To disable this model, set the using_payment variable within your dbt_pro...

stg_quickbooks__deposit_line_tmp model

columns: deposit_id, deposit_id columns: index, index columns: _fivetran_synced, _fivetran_synced Show 21 more
...--To disable this model, set the using_deposit variable within your dbt_pro...

stg_quickbooks__transfer model

...Table containing records of transfers. A Transfer represents a transaction ...

columns: transfer_id, transfer_id columns: amount, amount columns: from_account_id, from_account_id Show 3 more
...--To disable this model, set the using_transfer variable within your dbt_pr...

stg_quickbooks__invoice_line model

...Table containing individual records from invoices....

columns: invoice_id, invoice_id columns: index, index columns: amount, amount Show 13 more
...--To disable this model, set the using_invoice variable within your dbt_pro...

stg_quickbooks__invoice_line_bundle model

...Table containing lines of an invoice which were bundled....

columns: invoice_id, invoice_id columns: index, index columns: class_id, class_id Show 9 more
...--To disable this model, set the using_invoice_bundle variable within your ...

stg_quickbooks__invoice_linked_txn model

...Mapping table for invoices records to respective estimate and payment objec...

columns: invoice_id, invoice_id columns: payment_id, payment_id columns: estimate_id, estimate_id Show 1 more
...--To disable this model, set the using_invoice variable within your dbt_pro...

stg_quickbooks__deposit_tmp model

columns: id, id columns: _fivetran_deleted, _fivetran_deleted columns: _fivetran_synced, _fivetran_synced Show 16 more
...--To disable this model, set the using_deposit variable within your dbt_pro...

stg_quickbooks__credit_memo model

...Table containing credit memo records. A credit memo is a refund or credit o...

columns: credit_memo_id, credit_memo_id columns: balance, balance columns: doc_number, doc_number Show 8 more
...--To disable this model, set the using_credit_memo variable within your dbt...

stg_quickbooks__bill_payment_line_tmp model

columns: bill_payment_id, bill_payment_id columns: index, index columns: _fivetran_synced, _fivetran_synced Show 11 more
...--To disable this model, set the using_bill_payment variable within your db...

stg_quickbooks__credit_memo_line model

...Table containing individual records of credit memos....

columns: credit_memo_id, credit_memo_id columns: index, index columns: amount, amount Show 7 more
...--To disable this model, set the using_credit_memo variable within your dbt...

stg_quickbooks__vendor_credit_line model

...Table containing individual vendor credit line items....

columns: vendor_credit_id, vendor_credit_id columns: index, index columns: account_expense_customer_id, account_expense_customer_id Show 12 more
...--To disable this model, set the using_vendor_credit variable within your d...

stg_quickbooks__purchase_line_tmp model

columns: index, index columns: purchase_id, purchase_id columns: _fivetran_synced, _fivetran_synced Show 15 more
...select * from {{ var('purchase_line') }}...

stg_quickbooks__bundle_item model

...Mapping table containing all bundle and item combinations...

columns: bundle_id, bundle_id columns: item_id, item_id columns: item_quantity, item_quantity Show 0 more
...--To disable this model, set the using_invoice_bundle variable within your ...

stg_quickbooks__bill_tmp model

columns: id, id columns: _fivetran_deleted, _fivetran_deleted columns: _fivetran_synced, _fivetran_synced Show 17 more
...--To disable this model, set the using_bill variable within your dbt_projec...

stg_quickbooks__refund_receipt_line model

...Table containing individual line items of a refund transaction....

columns: refund_id, refund_id columns: index, index columns: amount, amount Show 7 more
...--To disable this model, set the using_refund_receipt variable within your ...

stg_quickbooks__purchase_tmp model

columns: id, id columns: _fivetran_deleted, _fivetran_deleted columns: _fivetran_synced, _fivetran_synced Show 23 more
...select * from {{ var('purchase') }}...

stg_quickbooks__estimate model

...Table containing estimates. An estimate represents a proposal for a financi...

columns: estimate_id, estimate_id columns: class_id, class_id columns: created_at, created_at Show 8 more
...--To disable this model, set the using_estimate variable within your dbt_pr...

stg_quickbooks__payment_line model

...Table containing individual line items recorded within a payment....

columns: payment_id, payment_id columns: index, index columns: amount, amount Show 4 more
...--To disable this model, set the using_payment variable within your dbt_pro...

stg_quickbooks__payment_line_tmp model

columns: index, index columns: payment_id, payment_id columns: _fivetran_synced, _fivetran_synced Show 9 more
...--To enable this model, set the using_payment variable within your dbt_proj...

stg_quickbooks__bill_payment_tmp model

columns: id, id columns: _fivetran_deleted, _fivetran_deleted columns: _fivetran_synced, _fivetran_synced Show 17 more
...--To disable this model, set the using_bill_payment variable within your db...
Show 425 more