Conventions used

There are a number of text conventions used throughout this book.

Code in text: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: "To create the Amazon Redshift cluster, we used the redshift command and the create-cluster subcommand."

A block of code is set as follows:

SELECT 'hello world';

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

            "NodeType": "dc2.large", 
            "ElasticResizeNumberOfNodeOptions": "[4]", 
    …
            "ClusterStatus": "available"

Any command-line input or output is written as follows:

!pip install psycopg2-binary
### boto3 is optional, but recommended to leverage the AWS Secrets Manager storing the credentials  Establishing a Redshift Connection
!pip install boto3 

Bold: Indicates a new term, an important word, or words that you see onscreen. For example, words in menus or dialog boxes appear in the text like this. Here is an example: "Navigate to your notebook instance and open JupyterLab."

Tips or important notes

Appear like this.