Expose custom fields

[mjrsnyder]

Firstly, thanks for building these packages!

Having access to custom fields would add a lot of value to the Asana data in our DW. Would it be possible to add them as an object to the task model? Adding them as a separate model would be fine.

I'm happy to help work on this but I would appreciate input on how best to implement it.

Thanks!

[kristin-bagnall]

Hey Charlie, thank you! If you'd like to work on this, that would be great! Here is some info to get you going. LMK if you have any questions along the way.

---

A good example of how we've done this in the pass is in our salesforce model.

Once you identify the models you'd like to include passthrough columns to, the steps include the following. I've linked examples of this work for each item.

Source package:

• Update dbt_project.yml file to include passthrough variables
• Update staging models to utilize passthrough columns. Note this needs to be done in two places - here and here. - Update README configuration to call out use of passthrough columns

Transform package:

• Update dbt_project.yml file to include passthrough columns
• Update any applicable models so that the passthrough columns flow through to final models. Example of final model here.
• Update README

[kristin-bagnall]

@mjrsnyder I just created new releases for the packages. You'll be able to upgrade to asana version 0.3.1 once you see it on the hub here (I expect this to take no less than 1 day).

[wesseljt]

@fivetran-kristin Thanks for you and are your team's responsiveness!