Page History

While on the Amazon Redshift page it's important to select the closest location to your users. This will generally result in the fastest response times.

3. Click on the Location currently in use next to your name at the top right of the page.

4. Select the location closest to you.

Image RemovedImage Added

5. While still on the Amazon Redshift page, click on the Launch Cluster button.

From here you will be walked through a setup process where you define and configure the cluster.

Image Modified

On this step you will need to define the following:

• Cluster Identifier
• Database Name
• Database Port
• Master User Name
• Master Password

Each option is documented on the page.

6. Configure the cluster details and click the Continue button.

Image Modified

Here you will need to define the number and types of nodes. Each option is documented on the page.

7. Define the Type and Number of Nodes. Click Continue.

Image Modified

Finally, there are some additional configuration items you can define, depending on the your network and security requirements. Each option is documented on the page.

8. Click the Continue button.

Image Modified

On the final step you are able to review all the configuration options you've applied in the previous steps.

9. Click the Launch Cluster option to finish.

Image Modified

You will now be presented with a message informing you that your cluster is being created.

10. Click the Close button to return to a list of available clusters.

Image Modified

Click on the name of your cluster in order to view its properties.

Image Modified

Here you will be able to view all the details related to your cluster, including items important for Yellowfin use:

• Custer Name
• End Point
• Port
• Database Name
• Master User Name
• Public IP

Make a note of the above values.

Image Modified
Image Modified

3. Expand the Data Sources list in the centre panel of the Admin Console.

4. Click on the Add button to create a new connection.

Image Modified

6. In order to connection to your Redshift cluster, define the following:

• Connection Method: JDBC
• Authentication: Standard Authentication
• Database: Amazon Redshift
• Include schema in SQL: (ticked)
• Host: this is the Public IP or Endpoint information (either can be used, depending on the security settings you applied) found on your Cluster Details page earlier.
• Port: this is the Port found on your Cluster Details page earlier.
• Database: this is the Database Name found on your Cluster Details page earlier.
• User Name: this is the Master User Name found on your Cluster Details page earlier.
• Password: this is the password you entered while configuring your cluster earlier.
• Schema: None

7. Test the connection and click Save.

Image Modified