Unpivots

Overview

The unpivot operation allows a user to turn table columns into table rows. The common order of operations will be to first collect the data, then unpivot the data, and finally query the data.

Unpivot Example

Source Table

Account

Department 

Jan 2020

Feb 2020

March 2020 

1000

Retail

$500

$400

$600

2000

Service

$1000

$2000

$3000

Unpivoted table

Account

Department

Date

Amount 

1000

Retail

Jan 2020

$500

 Configuration
 Screenshot (1)-20211008-164737

Field

Required/ Optional 

Comments

Name

Required

Must enter name of unpivot. This can be any name of preference.

Description

Optional

Optional. Descriptive free-text name for the collector

History Retention (Days)

Optional

Optional. Default is set as zero.

Source Data Source

Optional

Optional. Select from the dropdown menu provided.

Source Schema

Required

Must enter Source Schema. Select from the dropdown menu provided.

Ignore Columns

Optional

Optional. Select from the dropdown menu provided.

Key Column Name

Required

Must enter Key Column Name.

Value Column Name

Required

Must enter Column Value Name.

Target Data Source

Required

Must enter Target Data Source. Select from the dropdown menu provided.

Target Schema

Required

 Must enter Target Schema.

Latest Run

The latest run section documents the state of the unpivot, created time, and the status of the query. States include complete and error. When to a current stream (i.e. the data collected yesterday vs the data collected today). This can be found by hovering over the lasted run created text. Job logs are easily accessible via the latest run section at the top of the page. Click the linked timestamp and the user is taken to the job details.

Want to see more? Visit our helpful demo page or attend an office hour. Demos