Teradata SQL Extension for Visual Studio Code

With the Teradata SQL Extension for Visual Studio Code users can connect to Teradata VantageCloud or VantageCore systems to explore data, generate and run SQL, analyze results and manage SQL history.

Supported Operating Systems

The extension is supported on the following operating systems:

• Windows: x64 and ARM64 (ARM64 requires Windows 11)
• macOS: macOS 13+
• Linux: not supported

Supported Teradata Releases

The extension is supported for use with the following Teradata releases:

• 17.20, 20.00

Features

Below are some of the key features of the Teradata SQL Extension:

• Manage connections to Teradata Vantage

• Explore objects in your Teradata Vantage system

• Easily generate SQL

• Populate tables by uploading data from CSV files

• Edit and run SQL

• View, manage, and download SQL results

• Maintain SQL history

Connect to Teradata Vantage

Connect to any VantageCloud or VantageCore system

• Create, edit or delete connection profiles
• Manage connection profiles in groups
• Test connection availability and credentials

Explore your Teradata Vantage system

Easily explore your database objects

• View objects in flat (default) or hierarchical display
• Sort objects for easier discovery
• Refresh to reflect dynamic object changes
• Optionally limit display to permission restricted objects

Generate SQL for your database objects

Generate SQL commands specific to your database objects

• Generate SELECT, INSERT, UPDATE, DELETE
• Generate DDL, DROP
• Copy or drag and drop object names into SQL editor

Load data from a CSV file into existing table

Load data from a CSV file into an existing table to populate with data

Open an Editor and run SQL

Open an Editor connected to your Vantage system and run SQL

• Switch connections or disconnect
• Run a single SQL statement
• Run all SQL statements in the Editor as individual statements or as a single statement
• Cancel long-running SQL statements

View and manage result sets

View and manage result sets

• View SQL status, including processing and retrieval times
• Filter and sort columns
• Show/hide/move/resize columns
• Clear all sorting and filtering
• Copy rows, cells, or entire table to clipboard
• Download to CSV or JSON file

Maintain SQL history

SQL requests are maintained in searchable history

• View SQL status including processing and retrieval times
• Edit and re-run SQL statements
• Copy SQL statement to clipboard
• Search SQL history
• Delete SQL statements from history

Telemetry

This extension collects telemetry data, which is used to help understand how to improve the product. For example, this usage data helps to debug issues, such as slow start-up times, and to prioritize new features. While we appreciate the insights this data provides, we also know that not everyone wants to send usage data and you can disable telemetry as described in the VS Code disable telemetry reporting documentation.

Third-Party Licenses

This extension may contain third-party libraries. The licenses for these libraries are located here Third-party licenses