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
.