Skip to main content

Amazon Redshift

Amazon Redshift Query Editor

Explore, share, and collaborate on data using SQL

Get started with Amazon Redshift

Now with Amazon Q generative SQL in Amazon Redshift Query Editor (preview)

Amazon Redshift Query Editor is a web-based analyst workbench for you to securely explore, share, and collaborate on data with your teams using SQL within a common notebook interface. Amazon Redshift Query Editor makes it easy to query your data using SQL and gain insights by visualizing your results using charts and graphs with a few clicks.

Now with Amazon Q generative SQL in Amazon Redshift Query Editor (preview) you can securely write query requests in plain English directly within Amazon Redshift Query Editor within the scope of your current data access permissions and receive accurate SQL code recommendations.

Diagram illustrating key features of AWS Redshift Query Editor V2, including Visual Wizard for browsing database objects, Generative SQL for productivity with text to SQL, Navigation for browsing tables, views, and procedures, and Easy Collaboration for shared SQL interface and version management.

Benefits

Query and analyze your data in Amazon Redshift Query Editor SQL Notebooks without requiring permissions to access the Amazon Redshift console. Use Query Editor features such as navigator and visual wizards to browse database objects, create tables and functions, and load.
Accelerate query authoring by submitting query requests in natural language and receive custom SQL code recommendations based on your organization’s schema metadata with Amazon Q generative SQL in Amazon Redshift Query Editor (preview). Amazon Q generative SQL in Query Editor analyzes user intent, query patterns, and schema metadata to quickly generate SQL code based on trained Large Language Models (LLM) - enabling users to derive insights faster. Run multiple queries, and execute multi-statement queries with multiple results with autocomplete commands. Analyze and sort data without having to re-run queries, then export results as JSON/CSV, and build charts for visual analysis.
Collaborate and share different versions of queries, results, and charts for iteration and updates with Amazon Redshift Query Editor’s automatic version management.
The Intel logo in blue.
Roche is the largest pharmaceutical company in the world and the leading provider of cancer treatments globally.
We have several data engineers and hundreds of analysts who use the data lake we have built with Amazon Redshift. Amazon Redshift query editor enables us to leverage true cloud native development speeding up this process and allowing us to share knowledge and collaborate better. By using this native and web-based tool to query and analyze data, it not only will save us time and energy in on-boarding and training costs but also makes our analysts gain insight faster with its ability to perform in-place visual analysis of data.

Dr. Yannick Misteli

Lead Cloud Platform & ML Engineer - Roche
Logo for Mission Cloud featuring the word 'mission' in blue with the letter 'o' in yellow and blue.
Redshift recently launched Query Editor v2 which improves the web based interface and allows for easy plotting of key values and queries. The new editor also allows you to easily share your queries with other team members through the web interface.

Ryan Ries

Practice Lead/GM Data, Analytics and Machine Learning - Mission
Sedric is an AI risk & compliance excellence platform designed for the new generation of fintech.
We query the data by using the new Amazon Redshift Query Editor V2 to gain insights faster. This simplification enables us to rapidly onboard and support analytics-heavy use cases without friction.

Tomer Levi

Vice President of R&D - Sedric