Getting Started with Amazon Redshift
Amazon Redshift Database
This getting started gives some clues to start working with Amazon Redshift
Connect to your Data
The database structure can be entirely reversed in Metadata and then used in Mappings and Processes to design and adapt the business rules to meet the user’s requirements.
You can refer to Connect to your Data page which explains the procedure.
Work with Mappings
You can refer to Work with Mappings page which explains the procedure.