Can you remove 000 file extension after a CSV unload from Amazon Redshift to S3
<p>I've code which extracts data from redshift to S3</p>

<pre><code>UNLOAD ('

select sysdate

')

TO 's3://test-bucket/adretarget/test.csv' CREDENTIALS 'aws_access_key_id=ABCDE;aws_secret_access_key=12345' 
ALLOWOVERWRITE
delimiter ',' 
PARALLEL OFF ;
</code></pre>

<p>It works ok, however all my files end .csv000 is there a way to exclude the 000 so they just end.csv </p>

<p>Thanks</p>