Simplifying Stitch ETL’s Quickbooks Data in Redshift: Budgets Table

This is the third post of a six-part series of posts explaining how we make analyzing Quickbooks data easier by creating cached data sets from complex queries, resulting in simplified tables that anyone at our company is able to easily understand.

This is the Budgets table, which is a rather simple query that just creates a cleaner table summarizing the budgets for each account in Quickbooks.

SELECT budget.name AS "Budget Name",
budget.startdate AS "Budget Start Date",
budget.enddate AS "Budget End Date",
account.acctnum || ' ' || account.fullyqualifiedname AS "Account",
detail.amount AS "Amount",
detail.budgetdate AS "For Date"
FROM quickbooks.quickbooks_budgets budget
JOIN quickbooks.quickbooks_budgets__budgetdetail detail ON budget.id = detail._sdc_source_key_id
JOIN quickbooks.quickbooks_accounts account ON detail.accountref__value = account.id

Up Next:

Simplifying Stitch ETL’s Quickbooks Data in Redshift: Cash Movements Table

Previous Post:

Simplifying Stitch ETL’s Quickbooks Data in Redshift: The Shadow Schema

I'm the Analytics Therapist at Redox, a quickly growing technology platform that enables organizations to send healthcare data back and forth. Here, I write about our journey to become a data-driven organization, and the technical challenges I've faced along the way. All views and opinions are my own and do not represent those of my employer.