import psycopg2
conn_string = (
    """dbname='***' port='5439' user='***' password='***' host='mycluster.***.redshift.amazonaws.com'"""
    )
con = psycopg2.connect(conn_string)
sql = """COPY %s FROM '%s' credentials 
      'aws_access_key_id=%s; aws_secret_access_key=%s'
       delimiter '%s' FORMAT CSV %s %s; commit;"""
How to Load Data into Amazon Redshift via Python Boto3?