Data Explorer

The Data Explorer can be used to manage the following data object types:

../../../images/wb.explorer_data.png

Data Explorer Tab

To access the Data Explorer, in Workbench, click the Data tab of the left-hand navigation pane.

General Features

At the top of the Data Explorer tab are actions not tied to a specific object type:

  • Search box - filters displayed objects across all three domains, by keyword
  • Refresh icon - refreshes the list of displayed objects
  • + icon - adds a new data object

Tables & Views

This section of the Data Explorer shows the list of accessible schemas at the top level, and beneath each, the set of accessible tables and views.

Clicking the + next to this section's header will open the context menu, allowing any of the following objects to be created, via wizard:


Schema Services

Clicking on a schema will open a context menu with the following options:

  • Edit - rename this schema
  • Add New Table - create a table under this schema
  • Delete - delete this schema and all tables & views within

Table/View Services

Clicking on a table or view will open up a menu with these options:

  • Info - display general information about this object and its composition
  • Data Preview - display a grid-style view of this object's data
  • WMS Preview - display a map-style view of this object, if it contains geospatial data
    • Click Configure to modify the settings of the map
    • Click Update to view the map
    • Click Download PNG to save a local copy of the rendered map
    • Click the refresh icon to update the data on the map
  • Configure - modify the structure of this object; note that this enables access to both row-level security & column-level security for that object
  • Add Record - add a single record to this table
  • SQL DDL - display the SQL CREATE statement used to construct this object
  • Statistics - generate a per-column statistical analysis of this object
  • Rename - rename this object
  • Move - move this object to a different schema
  • Delete - delete this object permanently
  • Multi-Select - turn on multi-select mode, which allows multiple objects to be selected (by checking the boxes in front of them) and then deleted by clicking Delete Selected; click Cancel to turn off multi-select mode

Configuring a Table/View

A table can be configured upon creation and subsequently modified, from the Data Explorer in Workbench, including setting row-level security & column-level security on the table.

Both creating and modifying a table go through the same two steps. In the first step the following can be modified:

  • Schema - name of the schema to put this table in (only available for new tables)
  • Name - new name for the table (must meet table naming criteria)
  • Via the Advanced button:
    • Chunk Size - the designated number of records per block of allocated memory for this table
    • Dimension Table - whether or not this table is replicated, as dimension tables in a star or snowflake schema will usually be
    • Temporary Table - whether or not this table will be removed upon warehouse restart
    • Time To Live - the TTL (expiration time, in minutes) for the table; leave blank for permanent table
    • Foreign Keys - one or more foreign key definitions, of the form:
      (<column list>) REFERENCES <foreign table name>(<foreign column list>) [AS <foreign key name>] [,...]
      
    • Foreign Shard Key - one or more foreign shard key definitions
    • Partitioning - optional partition definition:
      • Type - type of partitioning scheme to use
      • Keys - column(s) and/or column expression(s) that will be used to determine the designated partition for each record
      • Definitions - type-specific definitions for the set of partitions or the partition creation scheme

Clicking Next will bring up the second step, where the table structure and row/column security are defined.

  • + Add Column - add a new column to the end of the table, where the following are specified:
    • Name - name of this column (must meet column naming criteria)
    • Type - data type of this column
    • Nullable - whether this column can accept null values
    • Primary Key - optionally designate this column as a primary key or a member of a composite primary key
    • Shard Key - optionally designate this column as a shard key or a member of a composite shard key
    • Dictionary Encode - whether to apply dictionary encoding to this column
    • Text Search - whether this column should be full-text searchable
    • Init with Now - whether this column's value should be initialized to the current date/time if blank when inserted
    • Init with UUID - whether this column's value should be initialized to a universally unique identifier (UUID) if blank when inserted
    • tv_icon_colsec - set column-level security on this column for users/roles
    • tv_icon_delete - remove this column from the table
  • Row Permissions - set row-level security on this table for users/roles
Row-Level Security

When Row Permissions is clicked on the table create/edit Column Definitions page, the Row Permissions pop-up will appear.

Click the name of a user or role on the left pane to show the corresponding row-level permissions that user/role has on this table in the right pane, and configure them:

  • Enabled - toggle whether row-level permissions on this table are active for the selected user/role
  • Filter - enter the filter expression that should be used to define the records in this table the selected user can access

Click OK once all row-level security modifications have been made.

See Row-Level Security for details.

Column-Level Security

When the Column Permissions tv_icon_colsec is clicked for a column on the table create/edit Column Definitions page, the Column Permissions pop-up will appear.

Click the name of a user or role on the left pane to show the corresponding column-level permissions that user/role has on this table in the right pane, and configure them:

  • Enabled - toggle whether column-level permissions on this table's column are active for the selected user/role; this will grant the selected user access to this column's data
  • Filter - enter the filter expression that should be used to define the records in this column the selected user can access; effectively adding row-level security to this column
  • Transform Type - optionally, character-based column values can have one of two transform functions applied in order to conceal the true values from the user/role to whom the access is granted:
    • Obfuscate - conceal text values by converting them to "random" whole numbers, where all occurrences of a given text value will convert to the same number
    • Mask - conceal text values by replacing one or more sequential characters in the text value with a single "masking" character:
      • Start Position - the 1-based position of the first character to mask
      • # of Masked Characters - the number of characters after (and including) the first one to replace with the masking character
      • Mask Character - the character used to replace column value characters

Click OK once all column-level security modifications have been made.

See Column-Level Security for details.

Data Sources

This section of the Data Explorer shows the list of accessible data sources.

Clicking the + next to this section's header will open the Create Data Source wizard. Provide a name, source provider/service, and the relevant connection information, and then click Create to create the data source.

Clicking on a data source will open a context menu with the following options:

  • Configure - modify this data source's reference to its external source
  • Import - opens the Import tool specific to this data source
  • Delete - delete this data source, provided it is unused by any other objects
  • Multi-Select - turn on multi-select mode, which allows multiple objects to be selected (by checking the boxes in front of them) and then deleted by clicking Delete Selected; click Cancel to turn off multi-select mode

Graphs

This section of the Data Explorer shows the list of accessible graphs.

Clicking the + next to this section's header will open the Create Graph wizard.

  • On the Configure page, provide a name, directedness, and graph structure options. Click the drop-down next to Nodes, Edges, Weights, and/or Restrictions to select the identifier combination to use for this component of the graph and click + Add to use it. Then enter the source database columns (or constants) to use for each identifier listed. Click the trash can icon to remove the selected identifier combination. Click Next to continue to the Options page, or Cancel to not create the graph.
  • On the Options page, specify any additional parameters that will define the graph. Click Create Graph to finish and create the graph, Cancel to not create the graph, or Back to return to the Configure page.

Clicking on a graph will open up a menu with these options:

  • Info - display general information about this graph and its composition
  • Preview - display a map-style view of this graph, if it contains geospatial data
  • Delete - delete this graph
  • Multi-Select - turn on multi-select mode, which allows multiple objects to be selected (by checking the boxes in front of them) and then deleted by clicking Delete Selected; click Cancel to turn off multi-select mode