Step 1: Create a database
After you verify that your data warehouse is up and running, you can create a database.
This database is where you actually create tables, load data, and run queries.
A data warehouse can host multiple databases. For example, you can have a database for sales data named
SALESDB and a database for orders data named ORDERSDB in the same data warehouse.
To create a database named SALESDB, run the
following command in your SQL client tool.
CREATE DATABASE salesdb;
Note
After running the command, make sure to refresh your SQL client tool list of objects in your data warehouse to see the new salesdb.
For this exercise, accept the defaults. For information about more command options, see CREATE DATABASE in the Amazon Redshift Database Developer Guide. To delete a database and its contents, see DROP 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.
