inventory level model

[fivetran-jamie]

Are you a current Fivetran customer?

fivetran made PR

What change(s) does this PR introduce?

• adds inventory level model and an intermediate model supporting it
• removed duplicative/deprecated columns from order_lines (just to avoid failures for now, will come back to this model in earnest later)
• enhances product model with new tables (I thought product and inventory_level would overlap more in the DAG, but this didn't really happen. consider this an early start on the "enhancing existing models" task)

Did you update the CHANGELOG?

• [ ] Yes
• [ ] nope!! will save it for the documentation task

Does this PR introduce a breaking change?

• [ ] Yes (please provide breaking change details below.)
• [x] No (please provide an explanation as to how the change is non-breaking below.)

Did you update the dbt_project.yml files with the version upgrade (please leverage standard semantic versioning)? (In both your main project and integration_tests)

• [ ] Yes

Is this PR in response to a previously created Bug or Feature Request

• [ ] Yes, Issue/Feature [link bug/feature number here]
• [X] No but inventory modeling has come up plenty with customers

How did you test the PR changes?

• [x] Buildkite
• [x] Local (please provide additional testing details below)

Select which warehouse(s) were used to test the PR

• [x] BigQuery
• [ ] Redshift
• [ ] Snowflake
• [ ] Postgres
• [ ] Databricks
• [ ] Other (provide details below)

Provide an emoji that best describes your current mood

⚡ **Feedback** We are so excited you decided to contribute to the Fivetran community dbt package! We continue to work to improve the packages and would greatly appreciate your [feedback](https://www.surveymonkey.com/r/DQ7K7WW) on our existing dbt packages or what you'd like to see next.

[fivetran-jamie]

@fivetran-joemarkiewicz yeah so re: daily inventory -- available inventory quantity is only stored as-of-today. a daily model would be possible by taking a snapshot of this model each day. i think it would be worth highlighting that pathway in the README or somewhere, in addition to a community/blog post

[fivetran-joemarkiewicz]

@fivetran-joemarkiewicz yeah so re: daily inventory -- available inventory quantity is only stored as-of-today. a daily model would be possible by taking a snapshot of this model each day. i think it would be worth highlighting that pathway in the README or somewhere, in addition to a community/blog post

Ahhh yes this conversation is coming back to me! Yeah let's do the community/blog post after the fact. Thanks for reminding me!