Access AWS Redshift using Python

Question

I am trying to run the aws redshift code inorder to connect the database using python. I am trying to run the given sample code given in the aws redshift documentation. Still I am getting some issue while running the code.

Code :

import numpy 
import redshift_connector
import socket
socket.getaddrinfo('localhost', 8080)

conn = redshift_connector.connect(
     host='examplecluster.abc123xyz789.us-west-1.redshift.amazonaws.com',
     database='dev',
     user='awsuser',
     password='my_password'
  )

cursor: redshift_connector.Cursor = conn.cursor()
cursor.execute("create Temp table book(bookname varchar,author‎ varchar)")
cursor.executemany("insert into book (bookname, author‎) values (%s, %s)",
                    [
                        ('One Hundred Years of Solitude', 'Gabriel García Márquez'),
                        ('A Brief History of Time', 'Stephen Hawking')
                    ]
                  )
cursor.execute("select * from book")

result: numpy.ndarray = cursor.fetch_numpy_array()
print(result)
cursor.execute("drop table book")
conn.commit()
conn.close()

Error :