Loading data into a warehouse

Loading data into a warehouse#

Introduction#

This guide describes how to load data into a warehouse so it is available for Data Conversations, Explore & Present.

After collecting and harmonizing your data in Adverity, loading it into a warehouse makes mapped data available across Adverity for analysis and visualization.

What is a warehouse?

A warehouse (managed by Adverity or your own external warehouse) is where Adverity loads mapped target fields so they are available for Data Conversations, Explore, and Present.

Note

If in your setup you use Explore & Present without warehouses, the data needs to be loaded into an Explore & Present destination. For instructions, see Loading data into Explore & Present.

Loading data into a warehouse#

Note

You need to create a datastream, fetch data, and apply Data Mapping before you can load into a warehouse. See Collecting data and Applying Data Mapping.

This example uses a warehouse managed by Adverity. If you use an external warehouse, follow the same steps for your connected warehouse.

To load your data from a datastream into a warehouse, follow these steps:

  1. Go to the Datastreams page.

  2. Click the datastream that contains the data you want to use in Adverity.

  3. Enable the toggle for the warehouse.

    image1

  4. In the Load data? pop-up window, click Yes, load data if you want to automatically load your previously collected data into the warehouse. The following data extracts will be loaded:

    • All data extracts with the status collected if no other destinations are enabled for the datastream

    • All data extracts with the status loaded if the data extracts have already been sent to the warehouse or external destinations

    Alternatively, click Skip to re-load the data extracts manually.

    image2

  5. If you clicked Skip in the previous step, to manually load the data you have already collected, scroll to the All tasks tab to find the data extract you want to load into the warehouse, then click image3 Reload in the Load task stage.

    image4

This video guide explains how to load your data into a warehouse managed by Adverity.

What’s next?#

Click the button below to go to the next Getting Started guide: Loading data into external destinations.

Or, continue working with your data:

Contents