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: