Loading data into a warehouse

Loading data into a 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 a warehouse.

Introduction#

What is a warehouse?

A warehouse is where Adverity loads your mapped target fields so they’re available for Data Conversations, Explore, and Present. You can use a warehouse managed by Adverity or connect your own external warehouse.

Why do I need to load data into a warehouse?

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

Which warehouses can I use?

You can use a Snowflake warehouse managed by Adverity, or connect your own external warehouse. For information about connecting an external warehouse, see Connecting an external data warehouse.

Note

If your setup uses 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?#

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