in amazon redshift's getting started guide, data pulled amazon s3 , loaded amazon redshift cluster utilizing sqlworkbench/j. i'd mimic same process of connecting cluster , loading sample data cluster utilizing boto3.
however in boto3's documentation of redshift, i'm unable find method allow me upload data amazon redshift cluster.
i've been able connect redshift utilizing boto3 following code:
client = boto3.client('redshift')
but i'm not sure method allow me either create tables or upload data amazon redshift way it's done in tutorial sqlworkbenchj.
go step 4 in tutorial linked. see shows how url of cluster? have connect url postgresql driver. aws sdks such boto3 provide access aws api. need connect redshift on postgresql api, connect postgresql database on rds.
Comments
Post a Comment