I am using SQL workbench /J to interact with a redshift cluster and I would like to load a CSV file (about 500k rows) into a redshift table (I do have insert privilege) without using COPY command (as i do not have privileges to copy into s3).
Do you know if it is feasible (using maybe insert), if yes, could you please help me?
Please note that the only privilege i have is : select, insert, update and delete tables within the cluster.
Thanks.