Allow aws_access_key_id, aws_secret_access_key for wr.redshift.copy(), wr.redshift.unload()

[data-bot-st]

Is your idea related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

I'd like to be able to use aws_access_key_id and aws_secret_access_key for copy and unload operations to redshift.

I don't have an iam_role for these operations, but I do have redshift credentials and iam credentials for s3 operations.

I don't have aws glue to tie these services together, but would like to be able to use this library.

Describe the solution you'd like
A clear and concise description of what you want to happen.

import redshift_connector
import awswrangler as wr

connection_dict = dict(host='*.redshift.amazonaws.com',
    database='*',
    user='*',
    password='*',
    port=*)


con_redshift = redshift_connector.connect(**connection_dict)


df = wr.redshift.read_sql_query("select * from *.*", con=con_redshift)


path = 's3://bucket/test_load'


wr.redshift.copy(
    df=df,
    path=path,
    con=con_redshift,
    schema="public",
    table="table_name",
    mode="overwrite",
    aws_access_key_id='*',
    aws_secret_access_key='*'
)

P.S. Don't attach files. Please, prefer add code snippets directly in the message body.

[data-bot-st]

@igorborgest ❤️ ❤️ ❤️ ❤️ ❤️

[igorborgest]

Released on version 2.2.0

Thanks @danielwo !