DEPOT_PIN_POLICIES

Lists all objects —tables, projections, and table partitions—that are pinned to database depots.

Eon Mode only

Lists all objects —tables, projections, and table partitions—that are pinned to database depots.

Column Name Data Type Description
SCHEMA_NAME VARCHAR Schema of the pinned object.
OBJECT_NAME VARCHAR Name of the pinned object.
POLICY_DETAILS VARCHAR

Specifies the object type, one of the following:

  • Table

  • Projection

  • Partition

MIN_VAL VARCHAR If the pinned object is one or more contiguous table partitions, specifies the range of partition keys.
MAX_VAL
LOCATION_LABEL The depot's storage location label.

See also