Getting Started with Amazon Redshift
This getting started gives some clues to start working with Amazon Redshift
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.
You can refer to Work with Mappings page which explains the procedure.