Vertica and Visual Studio Code: Technical Exploration
About this Document
The goal of this exploration is to integrate Visual Studio Code (VS Code) with Vertica. VS Code provides a platform to create connection to databases, query them, and view results. The code in VS Code can be customized and enhanced through the Extension APIs. To connect VS Code and Vertica, you need to install the extensions, SQL Tools and PostGreSQL.
Visual Studio Code Overview
Visual Studio Code is an open-source platform used for code editing and debugging, syntax highlighting, and code compilation. You can connect to a container running a different OS and use any VS Code plugin for that environment. It includes IntelliSense, which provides smart completions based on variable types, function definitions, and imported modules.