2022.6 - DataClarity New Features and Enhancements

Follow

DataClarity 2022.6 brings the following features and enhancements:

 

. 2

Data Preparation.. 2

• View the sorting order for datasets and data connections. 2
• View data type for all dataset columns. 3
• View source table and source column in Cataloging & Lineage. 4
• Join dataset tables with new cardinality relationships
• Create a dataset based on new data connections. 6. 5

 

Storyboards

. 6

• Switch charts while viewing a storyboard. 6
• Re-order filters in the Filter widget 7

 

DATA PREPARATION

View the sorting order for datasets and data connections

Now, you can quickly identify how items are sorted in List view for datasets and data connections. After clicking a column header, the arrow identifying either ascending or descending order appears next to the header.

 

 

 

View data type for all dataset columns

When working on a dataset, you can now view the data type of all columns at once. In Step 2 of the dataset wizard, click Detailed view – in addition to the source column and table, you can also view the Data type column for the selected dataset table. Moreover, you can sort data by any column in this view.

 

 

In Step 3, you can now use Detailed view to view the data type and data connection for all columns in the dataset at once.

 

 

 

View the source table and source column in Cataloging & Lineage

When reviewing a dataset in Cataloging & Lineage, the Columns tab now also includes Source table, Source column, and Data type columns to help you track where the data comes from.

 

 

 

Join dataset tables with new cardinality relationships

You can now create datasets with different relationships between the data in two tables. Different cardinality types help you connect the data depending on how the entities relate to each other:

• One to one
• One to many
• Many to one

In Step 3 of the dataset wizard, click Edit join and select a cardinality type that better reflects the relationship between the tables. The One to one option is selected by default.

 

 

Create a dataset based on new data connections

Now you can create, cache, and visualize a dataset based on new data sources, which include:

• Google Cloud AlloyDB
• CockroachDB
• CrateDB
• Materialize
• MySQL HeatWave
• QuestDB
• SingleStoreDB
• TimescaleDB
• Yellowbrick Data Warehouse
• YugabyteDB
  
  

The new data source connections have been added to the data connections list.

 

STORYBOARDS

Switch charts while viewing a storyboard

Now, you can switch chart type while using storyboard in view and edit modes. To do so, in the upper-right corner of the widget, click the chart icon and select one of the listed visualizations. In storyboard edit mode, you can also quickly change the chart type without going into the widget’s settings.

 

 

Re-order filters in the Filter widget

You can now quickly re-order filters added in the single Filter widget by dragging them to a different position within the pane. The new order is automatically reflected on the visualization, both in view and edit modes.