Loading data into Data Warehouse

Loading data into Data Warehouse#

You’ve collected and harmonized your data. Now it’s time to make it available for analysis. This guide shows you how to load your mapped data into Data Warehouse.

Introduction#

What is Data Warehouse?

Data Warehouse is where Adverity loads your mapped target fields so they’re available for Data Conversations, Explore, and Present. By default, Adverity manages the storage for Data Warehouse. You can also connect your own external warehouse.

Why do I need to load data into Data Warehouse?

Loading data into Data Warehouse enables Adverity’s analytics features. Once your data is in Data Warehouse, you can query it with Data Conversations, build visualizations in Explore, and create dashboards in Present.

How is Data Warehouse storage configured?

By default, Adverity manages the storage for Data Warehouse. You can also connect your own external warehouse. For information about connecting an external warehouse, see Connecting an external data warehouse.

Note

If your setup uses Dashboards without warehouses, the data needs to be loaded into an Dashboards destination. For instructions, see Loading data into Dashboards.

Loading data into Data Warehouse#

Note

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

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

To load your data from a datastream into Data 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 Data 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 Data 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 Data 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 Data Warehouse, then click image3 Reload in the Load task stage.

    image4

This video guide explains how to load your data into Data Warehouse.

What’s next?#

Your data is now available for Adverity analytics. You can also send it to external tools. Continue to the next guide: Loading data into external destinations.

Or, start working with your data:

Contents