Data loading using Amazon Redshift Query Editor v2
Query Editor v2 supports different database actions, including data definition language (DDL), to create schema and tables and load data from data files with just a click of a button. Let’s take a look at how you can carry out these tasks to enable easy analytics on your data warehouse. Log in to your AWS console, navigate to your Amazon Redshift Serverless endpoint, and select Query data. This will open Redshift query editor v2 in a new tab. Using the steps we followed in Chapter 1, log in to your database and perform the tasks outlined in the following subsections.
Creating tables
Query editor v2 provides a wizard to execute the DDL commands shown in Figure 2.1. Let’s create a new schema named chapter2 first:
- Click on Create and select Schema, as shown here.
Figure 2.1 – The creation wizard
Ensure that your Cluster or workgroup and Database parameters are correctly...
