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

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.