Data source details

Click a data source listed in the data source management home to view various attributes of that data source. The following subsections describe each area of the data source details. Note that a data source represents a Druid database table stored in Metatron and necessarily includes a timestamp column as a time-series table.

../../_images/manage_datasource_02.png

Common top area

  1. Name: Name of the data source. Click on it if you want modify it.
  2. Description: Description of the data source. Click on it if you want modify it.
  3. Last update: Shows who and when last updated the data source.
  4. Delete: Click this icon to display a menu that allows you to delete the data source.
  5. Tab selection: Each tab displays a specific set of attributes of the data source. Depending upon the type of data source, not all of the three tabs may be displayed. For details on each tab, refer to the relevant subsection below.

Data information area

This area displays basic information of the data source.

../../_images/manage_datasource_03.png
  1. Data type: Type of the imported source data from which the data source has been created.

  2. Status: Displays the availability of the data source.

  3. Size: Displays the size of the data source.

  4. Duration: Displays the time range of the timestamps included in the data source.

  5. Timestamp setting: Displays the granularities defined when the data source was created.

    • Query Granularity: Defines the minimum time period by which data is queried. This ensures faster returns by aggregating data per granularity interval.
    • Segment Granularity: In Druid, a data source is stored into multiple segments to be processed over multiple nodes in the distributed cluster environment. This granularity setting defines the time intervals into which the data source is partitioned.
    • Histogram: A graph displaying the size of the data stored within each time interval in Kbytes. This histogram is can be rendered because the Druid engine timestamps every table record.

Publish area

In this area, you can check and set which workspaces have access to the data source.

../../_images/manage_datasource_04.png
  1. Allow all workspaces to use this data source: Select this check box to make the data source available in all workspaces.
  2. Edit: Used to allow specific workspaces to access the data source. This button will disappear if the data source is set as open data.
  3. Number of shared workspaces: Displays how many workspaces have access to the data source.

Change data schema

The top section of the column details tab provides a user interface to filter columns by the criteria you define. Columns that meet the criteria are displayed on the left. You can also edit column settings.

Column view/settings

../../_images/manage_datasource_05.png
  1. Search data: Searches for columns by the column name you type in.
  2. Role: Displays all, dimension, or measure columns.
  3. Type: Displays the columns whose data type is selected.
  4. View all: Clears all filter settings in the Search data, Role, and Type options and returns to view all columns.
  5. Configure schema: Click this button to prompt a window to edit the current column settings.
  6. Column list: Lists table columns.
  7. Column information: Displays attributes of the selected column.
  8. Column settings: Displays the metadata of the selected column.
  9. Statistics: Displays the row count and other statistical values of the selected column.

Configure the schema

Provides a user interface for editing the name and type of columns.

../../_images/manage_datasource_06.png
  1. Role: Displays whether the column is a dimension or measure.
  2. Name: Displays the actual name of the column.
  3. Logical name: Allows you to edit the logical name of the column displayed in the system.
  4. Type: Allows you to edit the logical type (character/integer/date, etc.) of the column.
  5. Format: Allows you to edit the display format of the column in the case of the column being a timestamp type.
  6. Description: Allows you to add a detailed description of the column.

Analyze data statistics

The Monitoring tab reports the usage of the data source.

Change of transaction

Displays the trend of data source transactions over time.

../../_images/manage_datasource_07.png

Changes of data size

Displays the trend of the data source size over time.

../../_images/manage_datasource_08.png

Query distribution (during last one week)

../../_images/manage_datasource_09.png
  • Query distribution by user (during last one week): Displays a pie chart of query percentages by user for the past week.
  • Query distribution by elapsed time (during last one week): Displays a pie chart of query percentages by execution time for the past week.

Query log

Used to view a detailed history of each performed query.

../../_images/manage_datasource_10.png
  1. Date: Set a time range to display only those queries that were last executed within this time range.
  2. Query type: Filters the performed queries by type.
  3. Status: Displays all, succeeded, or failed queries.
  4. Query list: Lists queries filtered by specified criteria.
  5. Detail: Click on it to view the query statement.