# Loading Pre-aggregated Data into Raw Vault. **URL:** \ **Category:** Data Vault 2.0\ **Tags:** raw\ **Created:** [January 17, 2023, 10:50am UTC](https://forum.data-community.org/t/loading-pre-aggregated-data-into-raw-vault/562 "2023-01-17T10:50:23Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![MarkyMark](https://avatars.discourse-cdn.com/v4/letter/m/958977/32.png) [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Post date:** [January 17, 2023, 10:50am UTC](https://forum.data-community.org/t/loading-pre-aggregated-data-into-raw-vault/562/1 "2023-01-17T10:50:23Z")
We have a software engineering team who help land data from various different 3rd party applications. Some of these involve API calls that return effectively the output of what would be a report in the same application. For example, we have pre-aggregated call data for our contact call centres landed on our data platform via API. So, my question is how do I bring in pre-aggregated data into a raw data vault? ---
**Author:** ![AHenning](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@AHenning](https://forum.data-community.org/u/AHenning)\ **Post date:** [January 18, 2023, 6:47am UTC](https://forum.data-community.org/t/loading-pre-aggregated-data-into-raw-vault/562/2 "2023-01-18T06:47:10Z")
Hello! First, try to get the unaggregated data. But if that is not possible there is no differerence in handling preaggregated data and non aggregated data. Aggregated data is on another grain but business keys, relations an descriptive data can still be modeled. Do you have a sample of your pre aggregated data? Good luck! ---
**Author:** ![Nat](https://avatars.discourse-cdn.com/v4/letter/n/8c91f0/32.png) [@Nat](https://forum.data-community.org/u/Nat)\ **Post date:** [January 18, 2023, 5:00pm UTC](https://forum.data-community.org/t/loading-pre-aggregated-data-into-raw-vault/562/3 "2023-01-18T17:00:35Z")
Is it clear what business concepts are represented in the aggregated data - it seems like calls per day per contact centre, so you’d have at least a contact centre hub. If it’s just contact centre, then I think you’d make a sat called something like sat\_contactcentre\_daily\_call\_total which has the relevant date in it. Are there other hub concepts there? If there’s more than one hub then you’d need a link and linksat. ---
**Author:** ![patrickcuba](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/patrickcuba/32/19_2.png) [@patrickcuba](https://forum.data-community.org/u/patrickcuba)\ **Post date:** [February 5, 2023, 9:25pm UTC](https://forum.data-community.org/t/loading-pre-aggregated-data-into-raw-vault/562/4 "2023-02-05T21:25:45Z")
Hey Mark, These sound like JSON payloads, consider a satellite table with the JSON content in place but identify the business keys to have it hooked off a hub or a link table. > **[Data Vault on Snowflake: Handling Semi-Structured Data](https://medium.com/snowflake/data-vault-on-snowflake-handling-semi-structured-data-f3d1ffcc3f65)** > > Snowflake continues to set the standard for Data in the Cloud by taking away the need to perform maintenance tasks on your data platform… ---
**Author:** ![RhysHanscombe](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/rhyshanscombe/32/394_2.png) [@RhysHanscombe](https://forum.data-community.org/u/RhysHanscombe)\ **Post date:** [December 1, 2025, 2:45pm UTC](https://forum.data-community.org/t/loading-pre-aggregated-data-into-raw-vault/562/5 "2025-12-01T14:45:48Z")