Teradata

Teradata is a database system designed to handle large volumes of data for analytics and reporting. It helps organizations store, manage, and analyze data efficiently, especially when working with complex queries across massive datasets.

Default hierarchy

In the chart below, you will find the organizational structure of Teradata objects. Objects are in represented in green and folders are in yellow.

Object types

Dawiso ingests the following objects from Teradata:

Database

Maps to Teradata Database object type.

Source Attribute	Target Attribute in Dawiso
CommentString	Scanned Description
CreateTimeStamp	Created at
CreatorName	Created by
AccessCount	Access Count
AccountName	Account Name
DBKind	DB Kind
DefaultMapName	Default Map Name
IncrementalRestoreEnabled	Incremental Restore Enabled
JournalFlag	Journal Flag
LastAccessTimeStamp	Last Access Time Stamp
LastAlterName	Last Alter Name
LastAlterTimeStamp	Last Alter Time Stamp
MapOverride	Map Override
OwnerName	Owner Name
PermSpace	Perm Space
ProtectionType	Protection Type
SpoolSpace	Spool Space
TempSpace	Temp Space

Function

Maps to Teradata Function object type.

Source Attribute	Target Attribute in Dawiso
FunctionId	ID
DeterministicOpt	Is deterministic
AuthIdUsed	Auth Id Used
ExecMapColocName	Exec Map Coloc Name
ExecMapName	Exec Map Name
ExecProtectionMode	Exec Protection Mode
ExternalName	External Name
ExtFileReference	Ext File Reference
FunctionType	Function Type
GLOPSetDatabaseName	GLOP Set Database Name
GLOPSetMemberName	GLOP Set Member Name
CharacterType	Character Type
InterimFldSize	Interim Fld Size
MaxOutParameters	Max Out Parameters
NoSQLDataAccess	NoSQL Data Access
NullCall	Null Call
NumParameters	Num Parameters
ParameterDataTypes	Parameter Data Types
ParameterStyle	Parameter Style
ParameterUDTIds	Parameter UDT Ids
Platform	Platform
PrepareCount	Prepare Count
RefQueryband	Ref Query Band
ReturnType	Return Type
RoutineKind	Routine Kind
SpecificName	Specific Name
SrcFileLanguage	Src File Language

Function Parameter

Maps to Teradata Function Parameter object type.

Source Attribute	Target Attribute in Dawiso
ColumnTitle	Scanned Description
ColumnType	Data Type
CommentString	Comment
CreateTimeStamp	Created at
CreatorName	Created by
DefaultValue	Default value
ColumnLength	Length
AccessCount	Access Count
ArrayColElementType	Array Col Element Type
ArrayColElementUdtName	Array Col Element Udt Name
ArrayColNumberOfDimensions	Array Col Number Of Dimensions
ArrayColScope	Array Col Scope
AutoColumn	Auto Column
ColumnConstraint	Column Constraint
Compressible	Compressible
CompressValue	Compress Value
CompressValueList	Compress Value List
ConstraintCount	Constraint Count
ConstraintId	Constraint Id
DatasetSchemaName	Dataset Schema Name
DecimalFractionalDigits	Decimal Fractional Digits
DecimalTotalDigits	Decimal Total Digits
ColumnFormat	Column Format
CharType	Char Type
ColumnId	Column Id
IdColType	Id Col Type
InlineLength	Inline Length
LastAccessTimeStamp	Last Access Time Stamp
LastAlterName	Last Alter Name
LastAlterTimeStamp	Last Alter Time Stamp
Nullable	Nullable
PartitioningColumn	Partitioning Column
ColumnPartitionAC	Column Partition AC
ColumnPartitionFormat	Column PartitionFormat
ColumnPartitionNumber	Column PartitionNumber
PseudoUDTFieldId	Pseudo UDT Field Id
PseudoUDTFieldType	Pseudo UDT Field Type
RowVersionNo	Row Version No
SPParameterType	SP Parameter Type
StorageFormat	Storage Format
TimeDimension	Time Dimension
TSColumnType	TS Column Type
TTCheckType	TT Check Type
ColumnUDTName	Column UDT Name
UpperCaseFlag	Upper Case Flag
VTCheckType	VT Check Type

Macro

Maps to Teradata Macro object type.

Source Attribute	Target Attribute in Dawiso
CommentString	Scanned Description
CreateTimeStamp	Created at
CreatorName	Created by
RequestText	Definition (SQL)
RepStatus	Status
AccessCount	Access Count
AuthName	Auth Name
BlockCompression	Block Compression
BlockCompressionAlgorithm	Block Compression Algorithm
BlockCompressionLevel	Block Compression Level
BlockSize	Block Size
ColocationName	Colocation Name
CommitOpt	Commit Opt
CurrentLoadId	Current Load Id
DelayedJI	Delayed JI
FastAlterTable	Fast Alter Table
FreeSpacePercent	Free Space Percent
CheckOpt	Check Opt
CheckSum	Check Sum
ChildCount	Child Count
IncrementalRestoreEnabled	Incremental Restore Enabled
JournalFlag	Journal Flag
LastAccessTimeStamp	Last Access Time Stamp
LastAlterName	Last Alter Name
LastAlterTimeStamp	Last Alter Time Stamp
LastArchiveId	Last Archive Id
LastFullArchiveId	Last Full ArchiveId
LoadIdLayout	Load Id Layout
LoadProperty	Load Property
MapName	Map Name
MergeBlockRatio	Merge Block Ratio
NamedTblCheckCount	Named Tbl Check Count
ParentCount	Parent Count
PartitioningLevels	Partitioning Levels
PIColumnCount	PI Column Count
PrimaryKeyIndexId	Primary Key Index Id
ProtectionType	Protection Type
QueueFlag	Queue Flag
RequestTxtOverflow	Request Txt Overflow
ResolvedCurrent_Date	Resolved Current Date
ResolvedCurrent_Timestamp	Resolved Current Timestamp
RowSizeFormat	Row Size Format
SystemDefinedJI	System Defined JI
TableHeaderFormat	Table Header Format
TableKind	Table Kind
TemporalProperty	Temporal Property
TransLog	Trans Log
TTQualifier	TT Qualifier
TVMFlavor	TVM Flavor
UnnamedTblCheckExist	Unnamed Tbl Check Exist
UtilVersion	Util Version
Version	Version
VTQualifier	VT Qualifier

Macro Parameter

Maps to Teradata Macro Parameter object type.

Source Attribute	Target Attribute in Dawiso
Source Attribute	Target Attribute in Dawiso
ColumnTitle	Scanned Description
ColumnType	Data Type
CommentString	Comment
CreateTimeStamp	Created at
CreatorName	Created by
DefaultValue	Default value
ColumnLength	Length
AccessCount	Access Count
ArrayColElementType	Array Col Element Type
ArrayColElementUdtName	Array Col Element Udt Name
ArrayColNumberOfDimensions	Array Col Number Of Dimensions
ArrayColScope	Array Col Scope
AutoColumn	Auto Column
ColumnConstraint	Column Constraint
Compressible	Compressible
CompressValue	Compress Value
CompressValueList	Compress Value List
ConstraintCount	Constraint Count
ConstraintId	Constraint Id
DatasetSchemaName	Dataset Schema Name
DecimalFractionalDigits	Decimal Fractional Digits
DecimalTotalDigits	Decimal Total Digits
ColumnFormat	Column Format
CharType	Char Type
ColumnId	Column Id
IdColType	Id Col Type
InlineLength	Inline Length
LastAccessTimeStamp	Last Access Time Stamp
LastAlterName	Last Alter Name
LastAlterTimeStamp	Last Alter Time Stamp
Nullable	Nullable
PartitioningColumn	Partitioning Column
ColumnPartitionAC	Column Partition AC
ColumnPartitionFormat	Column PartitionFormat
ColumnPartitionNumber	Column PartitionNumber
PseudoUDTFieldId	Pseudo UDT Field Id
PseudoUDTFieldType	Pseudo UDT Field Type
RowVersionNo	Row Version No
SPParameterType	SP Parameter Type
StorageFormat	Storage Format
TimeDimension	Time Dimension
TSColumnType	TS Column Type
TTCheckType	TT Check Type
ColumnUDTName	Column UDT Name
UpperCaseFlag	Upper Case Flag
VTCheckType	VT Check Type

Procedure

Maps to Teradata Procedure object type.

Source Attribute	Target Attribute in Dawiso
CommentString	Scanned Description
CreateTimeStamp	Created at
CreatorName	Created by
RequestText	Definition (SQL)
RepStatus	Status
AccessCount	Access Count
AuthName	Auth Name
BlockCompression	Block Compression
BlockCompressionAlgorithm	Block Compression Algorithm
BlockCompressionLevel	Block Compression Level
BlockSize	Block Size
ColocationName	Colocation Name
CommitOpt	Commit Opt
CurrentLoadId	Current Load Id
DelayedJI	Delayed JI
FastAlterTable	Fast Alter Table
FreeSpacePercent	Free Space Percent
CheckOpt	Check Opt
CheckSum	Check Sum
ChildCount	Child Count
IncrementalRestoreEnabled	Incremental Restore Enabled
JournalFlag	Journal Flag
LastAccessTimeStamp	Last Access Time Stamp
LastAlterName	Last Alter Name
LastAlterTimeStamp	Last Alter Time Stamp
LastArchiveId	Last Archive Id
LastFullArchiveId	Last Full ArchiveId
LoadIdLayout	Load Id Layout
LoadProperty	Load Property
MapName	Map Name
MergeBlockRatio	Merge Block Ratio
NamedTblCheckCount	Named Tbl Check Count
ParentCount	Parent Count
PartitioningLevels	Partitioning Levels
PIColumnCount	PI Column Count
PrimaryKeyIndexId	Primary Key Index Id
ProtectionType	Protection Type
QueueFlag	Queue Flag
RequestTxtOverflow	Request Txt Overflow
ResolvedCurrent_Date	Resolved Current Date
ResolvedCurrent_Timestamp	Resolved Current Timestamp
RowSizeFormat	Row Size Format
SystemDefinedJI	System Defined JI
TableHeaderFormat	Table Header Format
TableKind	Table Kind
TemporalProperty	Temporal Property
TransLog	Trans Log
TTQualifier	TT Qualifier
TVMFlavor	TVM Flavor
UnnamedTblCheckExist	Unnamed Tbl Check Exist
UtilVersion	Util Version
Version	Version
VTQualifier	VT Qualifier

Procedure Parameter

Maps to Teradata Procedure Parameter object type.

Source Attribute	Target Attribute in Dawiso
ColumnTitle	Scanned Description
ColumnType	Data Type
CommentString	Comment
CreateTimeStamp	Created at
CreatorName	Created by
DefaultValue	Default value
ColumnLength	Length
AccessCount	Access Count
ArrayColElementType	Array Col Element Type
ArrayColElementUdtName	Array Col Element Udt Name
ArrayColNumberOfDimensions	Array Col Number Of Dimensions
ArrayColScope	Array Col Scope
AutoColumn	Auto Column
ColumnConstraint	Column Constraint
Compressible	Compressible
CompressValue	Compress Value
CompressValueList	Compress Value List
ConstraintCount	Constraint Count
ConstraintId	Constraint Id
DatasetSchemaName	Dataset Schema Name
DecimalFractionalDigits	Decimal Fractional Digits
DecimalTotalDigits	Decimal Total Digits
ColumnFormat	Column Format
CharType	Char Type
ColumnId	Column Id
IdColType	Id Col Type
InlineLength	Inline Length
LastAccessTimeStamp	Last Access Time Stamp
LastAlterName	Last Alter Name
LastAlterTimeStamp	Last Alter Time Stamp
Nullable	Nullable
PartitioningColumn	Partitioning Column
ColumnPartitionAC	Column Partition AC
ColumnPartitionFormat	Column PartitionFormat
ColumnPartitionNumber	Column PartitionNumber
PseudoUDTFieldId	Pseudo UDT Field Id
PseudoUDTFieldType	Pseudo UDT Field Type
RowVersionNo	Row Version No
SPParameterType	SP Parameter Type
StorageFormat	Storage Format
TimeDimension	Time Dimension
TSColumnType	TS Column Type
TTCheckType	TT Check Type
ColumnUDTName	Column UDT Name
UpperCaseFlag	Upper Case Flag
VTCheckType	VT Check Type

Table

Maps to Teradata Table object type.

Source Attribute	Target Attribute in Dawiso
CommentString	Scanned Description
CreateTimeStamp	Created at
CreatorName	Created by
RequestText	Definition (SQL)
RepStatus	Status
AccessCount	Access Count
AuthName	Auth Name
BlockCompression	Block Compression
BlockCompressionAlgorithm	Block Compression Algorithm
BlockCompressionLevel	Block Compression Level
BlockSize	Block Size
ColocationName	Colocation Name
CommitOpt	Commit Opt
CurrentLoadId	Current Load Id
DelayedJI	Delayed JI
FastAlterTable	Fast Alter Table
FreeSpacePercent	Free Space Percent
CheckOpt	Check Opt
CheckSum	Check Sum
ChildCount	Child Count
IncrementalRestoreEnabled	Incremental Restore Enabled
JournalFlag	Journal Flag
LastAccessTimeStamp	Last Access Time Stamp
LastAlterName	Last Alter Name
LastAlterTimeStamp	Last Alter Time Stamp
LastArchiveId	Last Archive Id
LastFullArchiveId	Last Full ArchiveId
LoadIdLayout	Load Id Layout
LoadProperty	Load Property
MapName	Map Name
MergeBlockRatio	Merge Block Ratio
NamedTblCheckCount	Named Tbl Check Count
ParentCount	Parent Count
PartitioningLevels	Partitioning Levels
PIColumnCount	PI Column Count
PrimaryKeyIndexId	Primary Key Index Id
ProtectionType	Protection Type
QueueFlag	Queue Flag
RequestTxtOverflow	Request Txt Overflow
ResolvedCurrent_Date	Resolved Current Date
ResolvedCurrent_Timestamp	Resolved Current Timestamp
RowSizeFormat	Row Size Format
SystemDefinedJI	System Defined JI
TableHeaderFormat	Table Header Format
TableKind	Table Kind
TemporalProperty	Temporal Property
TransLog	Trans Log
TTQualifier	TT Qualifier
TVMFlavor	TVM Flavor
UnnamedTblCheckExist	Unnamed Tbl Check Exist
UtilVersion	Util Version
Version	Version
VTQualifier	VT Qualifier

Table Column

Maps to Teradata Table Column object type.

Source Attribute	Target Attribute in Dawiso
ColumnTitle	Scanned Description
ColumnType	Data Type
CommentString	Comment
PrimaryKey	Primary key
CreateTimeStamp	Created at
CreatorName	Created by
DefaultValue	Default value
ColumnLength	Length
AccessCount	Access Count
ArrayColElementType	Array Col Element Type
ArrayColElementUdtName	Array Col Element Udt Name
ArrayColNumberOfDimensions	Array Col Number Of Dimensions
ArrayColScope	Array Col Scope
AutoColumn	Auto Column
ColumnConstraint	Column Constraint
Compressible	Compressible
CompressValue	Compress Value
CompressValueList	Compress Value List
ConstraintCount	Constraint Count
ConstraintId	Constraint Id
DatasetSchemaName	Dataset Schema Name
DecimalFractionalDigits	Decimal Fractional Digits
DecimalTotalDigits	Decimal Total Digits
ColumnFormat	Column Format
CharType	Char Type
ColumnId	Column Id
IdColType	Id Col Type
InlineLength	Inline Length
LastAccessTimeStamp	Last Access Time Stamp
LastAlterName	Last Alter Name
LastAlterTimeStamp	Last Alter Time Stamp
Nullable	Nullable
PartitioningColumn	Partitioning Column
ColumnPartitionAC	Column Partition AC
ColumnPartitionFormat	Column PartitionFormat
ColumnPartitionNumber	Column PartitionNumber
PrimaryIndexKey	Primary Index Key
PseudoUDTFieldId	Pseudo UDT Field Id
PseudoUDTFieldType	Pseudo UDT Field Type
RowVersionNo	Row Version No
SPParameterType	SP Parameter Type
StorageFormat	Storage Format
TimeDimension	Time Dimension
TSColumnType	TS Column Type
TTCheckType	TT Check Type
ColumnUDTName	Column UDT Name
UniqueKey	Unique Key
UpperCaseFlag	Upper Case Flag
VTCheckType	VT Check Type

View

Maps to Teradata View object type.

Source Attribute	Target Attribute in Dawiso
CommentString	Scanned Description
CreateTimeStamp	Created at
CreatorName	Created by
RequestText	Definition (SQL)
RepStatus	Status
AccessCount	Access Count
AuthName	Auth Name
BlockCompression	Block Compression
BlockCompressionAlgorithm	Block Compression Algorithm
BlockCompressionLevel	Block Compression Level
BlockSize	Block Size
ColocationName	Colocation Name
CommitOpt	Commit Opt
CurrentLoadId	Current Load Id
DelayedJI	Delayed JI
FastAlterTable	Fast Alter Table
FreeSpacePercent	Free Space Percent
CheckOpt	Check Opt
CheckSum	Check Sum
ChildCount	Child Count
IncrementalRestoreEnabled	Incremental Restore Enabled
JournalFlag	Journal Flag
LastAccessTimeStamp	Last Access Time Stamp
LastAlterName	Last Alter Name
LastAlterTimeStamp	Last Alter Time Stamp
LastArchiveId	Last Archive Id
LastFullArchiveId	Last Full ArchiveId
LoadIdLayout	Load Id Layout
LoadProperty	Load Property
MapName	Map Name
MergeBlockRatio	Merge Block Ratio
NamedTblCheckCount	Named Tbl Check Count
ParentCount	Parent Count
PartitioningLevels	Partitioning Levels
PIColumnCount	PI Column Count
PrimaryKeyIndexId	Primary Key Index Id
ProtectionType	Protection Type
QueueFlag	Queue Flag
RequestTxtOverflow	Request Txt Overflow
ResolvedCurrent_Date	Resolved Current Date
ResolvedCurrent_Timestamp	Resolved Current Timestamp
RowSizeFormat	Row Size Format
SystemDefinedJI	System Defined JI
TableHeaderFormat	Table Header Format
TableKind	Table Kind
TemporalProperty	Temporal Property
TransLog	Trans Log
TTQualifier	TT Qualifier
TVMFlavor	TVM Flavor
UnnamedTblCheckExist	Unnamed Tbl Check Exist
UtilVersion	Util Version
Version	Version
VTQualifier	VT Qualifier

View Column

Maps to Teradata View Column object type.

Source Attribute	Target Attribute in Dawiso
ColumnTitle	Scanned Description
ColumnType	Data Type
CommentString	Comment
CreateTimeStamp	Created at
CreatorName	Created by
DefaultValue	Default value
ColumnLength	Length
AccessCount	Access Count
ArrayColElementType	Array Col Element Type
ArrayColElementUdtName	Array Col Element Udt Name
ArrayColNumberOfDimensions	Array Col Number Of Dimensions
ArrayColScope	Array Col Scope
AutoColumn	Auto Column
ColumnConstraint	Column Constraint
Compressible	Compressible
CompressValue	Compress Value
CompressValueList	Compress Value List
ConstraintCount	Constraint Count
ConstraintId	Constraint Id
DatasetSchemaName	Dataset Schema Name
DecimalFractionalDigits	Decimal Fractional Digits
DecimalTotalDigits	Decimal Total Digits
ColumnFormat	Column Format
CharType	Char Type
ColumnId	Column Id
IdColType	Id Col Type
InlineLength	Inline Length
LastAccessTimeStamp	Last Access Time Stamp
LastAlterName	Last Alter Name
LastAlterTimeStamp	Last Alter Time Stamp
Nullable	Nullable
PartitioningColumn	Partitioning Column
ColumnPartitionAC	Column Partition AC
ColumnPartitionFormat	Column PartitionFormat
ColumnPartitionNumber	Column PartitionNumber
PseudoUDTFieldId	Pseudo UDT Field Id
PseudoUDTFieldType	Pseudo UDT Field Type
RowVersionNo	Row Version No
SPParameterType	SP Parameter Type
StorageFormat	Storage Format
TimeDimension	Time Dimension
TSColumnType	TS Column Type
TTCheckType	TT Check Type
ColumnUDTName	Column UDT Name
UpperCaseFlag	Upper Case Flag
VTCheckType	VT Check Type