You can edit a Redshift connection to add tables and columns.

To edit a connection:

  1. Click Data in the top navigation bar.

  2. Click the Connections tab at the top of the page.

  3. Click the name of the connection you want to edit.

  4. Click Edit connection at the upper-right-hand side of the page.

    Edit connection

  5. On the Choose connection type page, change the connection name or description (if needed), and then click Continue.

  6. On the Redshift connection details page, make any changes needed, and then click Continue.

  7. Expand the database table drop-down menu, and select the tables and columns you want to add.

    Select tables and columns

  8. Click Update, and then click Confirm to save the updated connection detail.

To remove a table from a connection, delete it from the connection details page. For more information, see:

To change the mapping of tables and columns, see Remap an Amazon Redshift connection

See the Connection reference for details of connection parameters.