Task 1: Create a database

After you verify that your cluster is up and running, you can create your own first database. This database is where you actually create tables, load data, and run queries. A single cluster can host multiple databases. For example, you can have a SALESDB database and an ORDERSDB database on the same cluster.

For example, to create a database named SALESDB, run the following command in your SQL client tool.

CREATE DATABASE SALESDB;

For this exercise, accept the defaults. For information about more command options, see CREATE DATABASE in the Amazon Redshift Database Developer Guide.

After you have created the SALESDB database, you can connect to the new database from your SQL client. Use the same connection parameters as you used for your current connection, but change the database name to SALESDB.