SnowConvert: Teradata Database DBC¶
Database DBC¶
Note
The DBC database contains critical system tables that define the user databases in the Analytics Database / Teradata Database. In the next segments, you can see the supported objects and columns of DBC database, the ones missing are not supported yet.
DBC database¶
Teradata |
Snowflake |
Notes |
|---|---|---|
DBC |
INFORMATION_SCHEMA |
See DBC database
DBC tables¶
Teradata |
Snowflake |
Notes |
|---|---|---|
COLUMNS |
COLUMNS |
|
COLUMNSV |
COLUMNS |
|
DATABASES |
DATABASES |
|
DBQLOGTBL |
TABLE(INFORMATION_SCHEMA.QUERY_HISTORY()) |
|
TABLES |
TABLES |
DBC columns¶
Teradata |
Snowflake |
Notes |
|---|---|---|
ALLRIGHTS |
APPLICABLE_ROLES |
|
COLUMNNAME |
COLUMN_NAME |
|
COLUMNUDTNAME |
UDT_NAME |
|
COMMENT_STRING |
COMMENT |
|
CREATETIMESTAMP |
CREATED |
|
COLUMNTYPE |
DATA_TYPE |
|
COLUMNLENGTH |
CHARACTER_MAXIMUM_LENGTH |
|
CONSTRAINTNAME |
CONSTRAINT_NAME |
|
CONSTRAINTTEXT |
CONSTRAINT_TYPE |
|
DATABASENAME |
TABLE_SCHEMA |
|
FINALWDNAME |
SESSION_ID |
|
FIRSTSTEPTIME |
DATEADD(MILLISECOND, TOTAL_ELAPSED_TIME - EXECUTION_TIME, START_TIME) |
|
LASTALTERTIMESTAMP |
LAST_ALTERED |
|
NULLABLE |
IS_NULLABLE |
|
STARTTIME |
START_TIME |
|
TABLEKIND |
TABLE_TYPE |
|
TABLE_LEVELCONSTRAINTS |
TABLE_CONSTRAINTS |
|
TABLENAME |
TABLE_NAME |
|
USER_NAME |
GRANTEE |
For more information about DBC tables and columns see the Teradata documentation.