Amazon Redshift Query Editor

Explore, share, and collaborate on data using SQL

 

 

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.

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.

Customers

Roche

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

Mission
“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

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