DICTIONARY DEPLOY - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.20
Published
May 2019
Language
English (United States)
Last Update
2019-05-23
dita:mapPath
dzf1517499323110.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Deploys one or more existing Data Dictionaries to the managed Unity Data Dictionary.

Syntax

DICTIONARY DEPLOY <dictionaryname>[,dictionaryname, ...][VALIDATED][NO RELOAD];

Parameters

dictionaryname
Name of a Unity Data Dictionary that exists in the Unity repository.
VALIDATED
Checks object dependencies.
NO RELOAD
Deploys the dictionary without a dictionary reload. A dictionary reload must occur for SQL statements to reference newly deployed objects. Deployed dictionaries not loaded into memory have the “RELOAD REQUIRED” text shown next to the “Last Deployed Time” output from the DICTIONARY LIST command.

Usage Considerations

The DICTIONARY DEPLOY command fails if one or more specified dictionaries do not exist as scanned data dictionaries that are ready to be deployed.

When the VALIDATED keyword is specified, the command fails if any table object dependency is either not included in the deploy or is already deployed in the managed Unity Data Dictionary.

Example

unityadmin>  DICTIONARY DEPLOY dictionary1; 
Command completed successfully