Introduction to the Data Warehouse page#
Note
This feature is being rolled out gradually. Expect it to become available soon.
The Data Warehouse page shows an overview of the data stored in the warehouse for the current workspace.
In Adverity, a warehouse is used as an internal destination for your data so that it can be used in other Adverity products. You need to load data into a warehouse in order to:
Send data to some external destinations. This is noted in the destination guides where relevant.
By default, Adverity manages the warehouse storage for you. Instead, you can store your data in your own external warehouse. For more information, see Connecting an external data warehouse.
Note
Only fields mapped with Data Mapping are loaded into the warehouse. Source fields that are not mapped remain in local storage. For more information, see Applying Data Mapping to a datastream.
Permissions#
The Data Warehouse page uses existing warehouse access permissions — no new permissions are required.
Access type |
Who has it |
|---|---|
View |
Any user with warehouse access for their workspace. Users can view datastream types and datastreams, and preview up to 50 rows of warehouse data. Users only see data in workspaces they have access to. |
Delete |
The administrator in the root workspace can delete any data. A user with the Administrator group who is assigned to a workspace can delete datastreams from that workspace or its child workspaces. |
Warehouse indicator and configuration#
The name of the warehouse currently used for the workspace is displayed in the top-right corner of the Data Warehouse page.
To configure which warehouse is used for a workspace, go to Administration. For more information, see:
Connecting an external data warehouse — how to connect your own external warehouse.
Configuring data warehouses for workspaces — how to assign a specific warehouse to individual workspaces.
Data displayed on the page reflects the state of the warehouse at the time of the last sync. The data is refreshed overnight every day. To sync the state manually, click Refresh now.
Data Warehouse summary#
The Data Warehouse page shows the following summary widgets at the top of the page:
- Total rows
The total number of rows stored in the warehouse across all datastreams.
- Data breakdown
The number of datastreams and data sources that have data loaded into the warehouse.
- Used dimensions and metrics
The number of dimensions and metrics currently stored in the warehouse.
- Total range of data
The date range covered by data currently stored in the warehouse, showing the earliest and latest dates across all loaded data.
Data sources and datastreams#
The Data Warehouse page lists your data sources grouped with their datastreams. Data sources are sorted in descending order by the number of datastreams they contain. For each data source, you can see the number of datastreams with data loaded into the warehouse.
Each datastream is shown as a tile. Each tile shows:
The datastream name.
Whether loading into the warehouse is enabled for this datastream.
The workspace the datastream belongs to.
Managing data#
You can manage the data stored in the warehouse at both the data source and the datastream level by clicking Manage data on the relevant data source or datastream tile.
Data preview#
Clicking Manage data opens the data preview page for the selected data source or datastream. The data preview page shows:
A table with the first 50 rows of data currently stored in the warehouse for the selected data source or datastream.
The following statistics:
Which datastreams provided the data.
When data was last loaded into the warehouse.
The total number of rows stored.
The number of days covered by the stored data.
The number of fields (columns) stored.
Filtering data#
On the data preview page, you can filter the data shown in the preview using the following filters:
Date range — shows only data within the selected date range.
Datastreams — shows only data from the selected datastreams within the selected data source.
Deleting data#
To delete data from the warehouse, click 
Delete data above the data
table on the data preview page, then confirm the action in the dialog.
If you have applied any filters, only the filtered data will be deleted.
Only users with Administrator permissions can delete data.
Note
Deleting data removes it from the warehouse but does not affect data extracts in local storage and does not disable warehouse loading for the datastream. To stop loading data from a datastream into the warehouse, disable the warehouse loading toggle on the datastream. For more information, see Loading data into Data Warehouse.