Querying a database using the query editor v2
The query editor v2 is a separate web-based SQL client application that you use to author and run queries on your Amazon Redshift data warehouse. The query editor v2 is primarily used to edit and run queries, visualize results, and share your work with your team. With query editor v2, you can create databases, schemas, tables, and user-defined functions (UDFs). In a tree-view panel, for each of your databases, you can view its schemas. For each schema, you can view its tables, views, UDFs, and stored procedures. The query editor v2 is a replacement for the previous query editor.
Note
The query editor v2 is available in commercial Amazon Web Services Regions. For a list of Amazon Web Services Regions where the query editor v2 is available, see the endpoints listed for Redshift query editor v2 in the Amazon Web Services General Reference. The query editor v2 is also available in China Amazon Web Services Regions.
For a demo of query editor v2, watch the following videos.
The query editor v2 has a rich set of features to manage and run your SQL statements. The topics in the following sections get you started with many of these features. Explore the query editor v2 on your own to familiarize yourself with its capabilities.