Creating Data Extracts
One of the methods in accessing data is by retrieving only the required results into memory, by querying on demand, pushing aggregation and filtering tasks to underlying big data repositories, or queryable data extracts.
This is commonly known as a ROLAP implementation, where the product is dynamically writing data queries to the underlying data repository and retrieving aggregated and filtered datasets. Given the on-demand nature of this method it is more suitable for exploratory data analysis but requires dynamic query generation.
This section discusses the steps and guidelines on how to create data extracts.
- On the Data Library page, click
.
The New Data Extract dialog displays.
- Enter the name of the data extract then click
.
The Extract Settings page displays.
Section Description 1 Connector drop-down list
Includes the non-streaming connectors to extract data from.
2 Extract Name
Name of the data extract. Click the
button to go back to the Data Library page.3 Convert to Data Table
Click
to convert the data extract to data table and import into data store.A notification displays and “Data Table” is appended to the file name of the converted data extract.
4 Save
Save the changes made on the Extracts tab.
5 Refresh Data
Refresh the data after modifying and saving changes on the Data Extract page.
You can also opt to click Cancel Refresh Data
.6 Details
Display the details of the data extract including the number of rows, columns, cells,
status, and the last time it was updated.7 Connectors
Select the connector that will be used for the data extract.
8 Refresh Data Preview
Refresh the data preview.
9 Expand Data Preview
Expand the Data Preview panel.
- Define the data extract settings of any of the following data sources:
- Click
to save and display the details of the data extract. - Click
then 
to display the data preview. - Click to go back to the Data Library page. The new data extract is added to the list.
(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.