1. Help Center
  2. Amazon Redshift Administration

Creating a new table

You can use Create Table tool to quickly create a new table into the current database.

  1. On DataRow's home screen, click + Create button at the top left.
  2. Click New Table...
  3. Enter the Table Name and select the schema for the new table.
  4. Click + Add Field to enter columns to the table, or use the Load From CSV option.
  5. Select the Default Value.
  6. Select Primary Key if the column is the primary key for the table.
  7. Select Unique Key if the column is the primary key for the table.
  8. (Optional) Click Table Details, and enter Distribution Key, Distribution Style, Sort Key, Sort Type.
  9. (Optional) Click Other Options
  10. (Optional) Select Backup if you want the table should be included in automated and manual cluster snapshots.
  11. (Optional) Select Temporary Table if you want the table is automatically dropped at the end of the session in which it is created.
  12. Click Create Schema.
  13. Your new schema will be listed in the Tables Tree View.

 

A screenshot of DataRow that shows the Create New Table tool.