Posted On: Oct 17, 2023

AWS announces the support for Amazon Redshift with Visual Studio Code (VSCode), a free and open-source code editor. The integration with Visual Studio Code enables Amazon Redshift customers to use Visual Studio Code to author and run their SQL queries in a notebook interface and view the schema objects in their Redshift data warehouses. 

To get started, you can download the latest AWS-Toolkit extension from VSCode marketplace or update your AWS-toolkit extension if you already have it installed in your VSCode environment. Then you can configure the extension with credentials for your AWS account and connect to AWS explorer in VSCode. Once connected, you can interact with Redshift menu item and connect to a specific Redshift data warehouse to then list all the databases, schemas and tables. To begin querying databases in this data warehouse, you can create a new notebook and write and execute your SQL queries using the notebook cells.

To learn more, see Amazon Redshift support in VSCode.