Data Warehouse
This article details Data Warehouse in the Brinqa Platform, why Brinqa uses it, and how it processes data.
What is Data Warehouse?
Data Warehouse is an Online Analytical Processing (OLAP) data store that allows the Brinqa Platform to store and deliver large-scale data snapshots. Processing calculated data points at scale, such as over 100 million findings, had the potential to cause performance issues throughout the Brinqa Platform. To improve efficiency, Brinqa performs necessary calculation during data orchestration, takes a nightly snapshot of relevant data, and then updates the OLAP data store. Data Warehouse then delivers this data across various parts of the Brinqa Platform.
Identify the data store source
You can quickly identify the data store source for any data displayed in the Brinqa Platform. When viewing data in a list view, such as the Vulnerability list view (Findings > Vulnerabilities), point the cursor over the clock icon next to the total record count as shown in the screenshot below. A tooltip appears providing the following information:
-
Data store: Indicates whether data is retrieved from Data Warehouse (OLAP) or the Graph database (OLTP).
-
Time to load: Shows how long it took for the data to load.
-
Data was last updated on: Displays the timestamp of the most recent data snapshot.
-
Show query: Click the drop-down to view the BQL query used to retrieve the data.
How to enable Data Warehouse
Users with the System administrator role can enable or disable Data Warehouse. To do so, follow these steps:
-
Navigate to Administration > System > Advanced.
-
Locate the Data Warehouse section and toggle Enable Data Warehouse to enable or disable it.
Enabling Data Warehouse requires additional work from your Brinqa Support team to help ensure that any data mismatches are resolved. Please work with your Brinqa Support team to verify that Data Warehouse is running smoothly and that data orchestration is not affected.