Teradata SQL Extension for Visual Studio Code
With the Teradata SQL Extension for Visual Studio Code users can connect to Teradata 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:
Features
Below are some of the key features of the Teradata SQL Extension:
Connect to Teradata
Connect to any Teradata system
- Create, edit or delete connection profiles
- Manage connection profiles in groups
- Test connection availability and credentials
Explore your Teradata 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
- Optionally select which top-level objects to display
Generate SQL for your database objects
Generate SQL commands specific to your database objects
- Generate SELECT, INSERT, UPDATE, DELETE for selected columns or all columns
- 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 Teradata 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
- Enable Advanced Parser in settings for Teradata-specific syntax checking and auto-complete options
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 a CSV, JSON, or Excel 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
Enable Language Model Tools for enhanced LLM interaction
- Enable Language Model Tools in settings
- Supports LLM connection to editors, exploring schema, inserting SQL, and retrieving results
- Session Target for Chat must be set to Local
- For best results, we recommend using the most capable language models available in your environment
- Example prompts
- "I'm looking for tables with the word customer in their name that are in the Teradata system dev1"
- "Open an editor and insert SQL to summarize the val.customer table"
- "Run the SQL and present the results"
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
