Back

Exit the Data Table Editor and go to the Data Library page.

Data Table Name

Name of the data table. You can edit by entering a new one and clicking .

Data Table Settings

Displays the data source that you will connect to. Click   to select another data source. Other data table definitions are displayed including the description and the auto refresh period (in seconds).

NOTE:  Auto Refresh is disabled for data table in data store and connectors that only work on uploaded data or Upload File load type. These include the following connectors:

• File Data
• Text Entry
• SVG
• MS Excel
• Text
• JSON
• XML

Data Table Parameters

Add or manage data table parameters.

Search Columns

Allows searching of columns on the Data Preview.

Collapse Data Profile Pane

Collapse the Data Profile pane. Click  to expand the Data Profile pane.

Data Profile Pane

Displays the following information:

• Rows of Data Profile (i.e., Value Count, Distinct, Missing)
• Data Profile Histogram

Data Preview

Executes the queries to return and display preview of the data table you are creating.

NOTE: The maximum number of rows displayed in the Data Preview is 1000.

Calculated Columns

Allows you to view and manage the calculated columns.

New Column Options

Allows you to add any of the following columns:

• Auto Key
• Calculated
• Ranking
• Time Bucket
• Identity, Sign, Manual, Equal Density, and Equal Distance numeric buckets
• Text Grouping

Group and Sort Columns

When the Column Order is set to Sorted, the columns are grouped by type (Text, Date/Time,
then Numeric) and sorted alphabetically.

Column Profiling

Perform column profiling either for the Top 1000 Rows or All Rows.

Connector Settings

Displays the connector settings of the data source and allows for limiting the amount of data to be returned.

Data Policy

Allows you to set the data policy for data tables in the Data Library.

Import to Data Store

Allows you to import the data table to a data store.

Clear and Import to Data Store

Allows you to clear the earlier imported data and import again to the data store.

Save Data Table

Saves the data table definition.

Row Limits Settings

Allows setting of the row limit of data sources.

Refresh Preview

Allows you to refresh the data preview.

Collapse Data Preview

Collapse the Data Preview pane. Click   to expand the Data Preview pane.

Transform Settings

Allows you to perform the following:

• Pivoting or unpivoting retrieved data.

• Transforming data to enable time series analysis including interpolation.

• Running an R or Python script for data transformation.

• Lists of orders to be reconstructed into an Order Book and conflated for output display.

Column Settings

Allows you to perform the following:

• View the column data type

• Rename the column names

• Select the numeric or Date/Time format

• Select the numeric default aggregation

• Define the Min and Max range of numeric columns

• Define custom sort order

Error Message

Allows you to enter custom Error Message that will be displayed when an error occurs while fetching data. Can be parameterized.

Includes Aggregate Data

Allows you to retrieve external aggregates.

Export Raw Data

Specify the set of columns to be included when exporting raw data

Data Table ID

Id of the data table. Can be used for parsing of server logs.

Data Log Details

Details of the data log which includes the data source name, response time, and duration (ms).

Parameters

Parameters on the data table.

Logs

Logs of the last query.