Journal Tables and the Default Map - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantageā„¢

If CREATE USER statement specifies a journal table and a default map, the journal table is created using this default map. The journal table map must be a contiguous map that has the same AMPs as TD_GlobalMap.

If CREATE USER statement specifies a journal table and without specifying a default map, the system determines the map for the journal table in the following order of precedence:
  • Default map for the profile of the user creator, if defined.
  • Default map for the user creator, if defined.
  • System-default map.