Partitions

Overview

The Partitions navigation tree branch opens partition definitions for large table refresh and management scenarios.

Function

Use the branch or Data mart toolbar command to open the partition list.

The list shows fact table and partition name, with actions for deleting, duplicating, or creating partition definitions.

Access

Open the Partitions branch from the navigation tree or use the Data mart toolbar tab.

How to access

Navigation tree

Partitions -> List partitions.

Toolbar

Data mart -> Partitions.

Diagram

Not opened directly from the diagram.

Visual element

Partitions navigation branch and list

Screen overview

User Interface - Navigation tree - Partitions screen overview

Context menus access - Partitions - Where I can find it

The context menu examples below use the captured Data warehouse > Partitions navigation tree branch and show the Partitions branch, a table node, and a partition node.

A.1) Partitions

Data warehouse > Partitions context menu
ID Command Description
1 Refresh Reloads the Partitions branch.
2 List partitions Opens the partition list.
3 Add partition Creates a partition from the selected context.
4 List scripts Lists scripts available for the selected context.
5 Add script Adds a script to the selected context.
6 Run script Runs a script for the selected context.

A.2) Partitions > STAR.DIM_Orders

Data warehouse > Partitions > STAR.DIM_Orders context menu
ID Command Description
1 Refresh Reloads the selected table node.
2 List partitions Opens the partition list for the selected table.
3 Add partition Creates a partition for the selected table.
4 List scripts Lists scripts available for the selected table.
5 Add script Adds a script to the selected table context.
6 Run script Runs a script for the selected table context.

A.3) Partitions > STAR.DIM_Orders > OrdersRannge

Data warehouse > Partitions > STAR.DIM_Orders > OrdersRannge context menu
ID Command Description
1 Edit partition Opens the selected partition for editing.
2 Delete partition Deletes the selected partition.

Related topics