Database DBC

Equivalents for DBC objects and columns

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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.