Capturing exposures data

[kon-mal]

Thanks for creating this package - we have found it very useful in our dbt projects!

One thing we found missing was capturing information about exposures defined within our dbt projects. Especially, we were interested in exposing to our end users latest update times of different output models feeding the different exposures. We can extract the latest run of each model from the FCT_DBT__MODEL_EXECUTIONS model but exposures are not captured in any of the models.

Based on your work, we have created three models to capture this information and would be very keen to explore if you'd be interested in incorporating it into your package. Similar to your models capturing data on MODELS we built:

• a staging model extracting metadata about exposures from manifest.json (STG_DBT__EXPOSURES),
• a dimension model expanding exposure-model relations into separate row (DIM_DBT__EXPOSURES),
• a fact model joining exposures and latest update times of each output model feeding them (FCT_DBT__EXPOSURES_UPDATES).

Let me know if that's something you'd be interested in!

[kgpayne]

Hey @kon-mal 👋 Thanks for raising this issue and for your work on exposures! Sounds very useful. Would you be willing to raise a PR with the additional models? I'd love to have a look, and do some testing too 👍

[kon-mal]

Thanks @kgpayne! I raised a PR with the models. Looking forward to your feedback!

[kgpayne]

Merged and included in Release 0.4.1 🚀 Thanks again @kon-mal 🙏