Teradata Database Management in VS Code

Overview

Teradata is a massively parallel enterprise data warehouse used for large-scale analytics in finance, telecom, retail, and government. Key characteristics include:

• Database-as-schema model: A Teradata “database” is the namespace that owns tables, views, macros, procedures, and functions. DBCode surfaces each database as a schema.
• Standard plus dialect SQL: ANSI-style SQL with Teradata-specific features such as QUALIFY, TOP, and SAMPLE for row limiting.
• Object variety: Tables, views, macros (a Teradata-specific object), stored procedures, and user-defined functions.
• Enterprise scale: Shared-nothing MPP architecture, primary indexes, and statistics-driven optimization.

DBCode connects over Teradata’s native protocol using Teradata’s official driver, so you can explore and query a Teradata Vantage environment - including a free ClearScape Analytics Experience instance - without leaving Visual Studio Code.

Connecting

To connect to Teradata in DBCode:

1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
2. Add a New Connection: Click the “Add Connection” icon.
3. Complete the connection form: Select Teradata as the database type and enter:
   • Host: hostname of your Teradata system (for ClearScape, the environment host)
   • Port: TCP port (default: 1025)
   • Logon Mechanism: TD2 (username / password) or LDAP
   • Username / Password: Teradata credentials
4. Accept the driver download: Teradata’s driver is proprietary, so DBCode does not bundle it. On first connect you are prompted to download Teradata’s official teradatasql driver from the public npm registry for your own use, under Teradata’s license.
5. Connect: Click save to connect, then browse databases, tables, views, and macros and run queries.

For detailed connection instructions, refer to the Connect article.

Teradata Features in DBCode

DBCode enhances your Teradata workflow with:

• SQL query editor: Write and execute Teradata SQL with syntax highlighting and multi-statement support.
• Schema browsing: Navigate databases, tables, views, macros, procedures, and functions, with column types, primary keys, foreign keys, and table sizes.
• Data editing: Insert, update, and delete rows inline in the data grid.
• DDL scripting: Generate object definitions with SHOW TABLE, SHOW VIEW, SHOW MACRO, and SHOW PROCEDURE directly from the schema browser.
• Execution plans: View Teradata’s EXPLAIN text plan for a query.
• Transactions: Pin a connection to run statements in a transaction and commit or roll back together.
• Server monitoring: View active sessions and system information from the monitoring panel.
• Statistics: Optionally run COLLECT STATISTICS to refresh row counts during introspection.

Preview limitations

Teradata support is in Preview:

• High-precision DECIMAL: Teradata’s driver returns DECIMAL/NUMBER values as 64-bit floating point, so values beyond roughly 15-16 significant digits may lose precision in the grid. BIGINT integer values are returned exactly.
• Lock monitoring: Teradata does not expose current locks through a system view, so the monitoring panel shows sessions and system info but not locks.
• Editor IntelliSense: Some Teradata-specific syntax (such as QUALIFY and SAMPLE) does not yet get full editor completion.

By using Teradata with DBCode, you can explore, query, and manage your data warehouse directly within Visual Studio Code.

For more information about Teradata, visit teradata.com.