Often data coming from an API Call, or when being extracted from one or more source systems, may require some Business Logic applied to it before it’s presented to users. Or users encounter a scenario where a large amount of data needs to be extracted from a source system to form the basis of multiple different Datasets. In these scenarios, it can be desirable to create a Datamart table which stores a physical copy of the data in the Nathean Analytics Datamart for other datasets to query from.

Standard Datamart tables are dropped and replaced when the Dataset which creates them is refreshed but can also be configured to be appended to on a more regular interval (e.g. a daily refresh might update the last 7 days figures while a weekly refresh might update figures from before that)

Architecture Diagram of a Datamart Dataset:
Datamarting Architecture

Revision: 1
Last modified: May 21, 2020

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment