Query Editor

What is Query Editor?

Query Editor for Amazon Redshift

Query Editor is the best way to write SQL in Amazon Redshift. Easily explore your data and quickly write queries with advanced features supported by Amazon Redshift.

Functional data grid

Sort, filter, and export your data without modifying your query.

The Query Editor functional data grid  is a powerful part of the client. In addition to displaying the data you return with your queries, you can use it as you would in a spreadsheet - sort and filter your data without modifying your query.

Export options

Do you want to export all the data that you returned from a given query? Do this easily in JSON, CSV, or Tab Separated formats.

Instant load errors

Get instant insight into your system's load errors and performance with Query Editor.

Instant load errors run shortly after the query is executed and provide the result of the error below the query editor. Therefore, you get instant information to troubleshoot data loading problems.

In addition, you can see the logs for all the tables in the system in a single location without running any additional queries. In addition, you can understand how the Amazon Redshift system behaves.

DataRow Query Editor Features

A SQL client designed and built specifically for Amazon Redshift.

Multiple SQL statements

Include multiple SQL statements in the Query Editor. The Query Editor supports multiple SQL statements in a single query.

Syntax highlighting

Improves the readability and context of the code. Focus on what you're looking for and skip large sections of code.

QuerySense

QuerySense kicks in when a harmful query is executed and warns you before you run it.

Query version

Whenever you save a SQL query, the Query Editor saves it as a new version. Search for previous versions, save a copy, or restore a query.

Custom Snippets

Instead of limiting it to standard Query Editor snippets, you can create your own snippets for repeated use.

Create Role Wizard

A guided tool that makes it easy to create a user-defined function (UDF) and execute it with just a few clicks.

System Requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD/SSD: 50 GB of free space on main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit, and Microsoft Windows Vista 32-bit

Resolution: 1024×768