Download csv from Amazon S3: No such key & process cannot access file error

[Inactive User]

I'm trying to download csv files from https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page.

If I try to download to a field, I receive the following error message: 

<?xml version="1.0" encoding="UTF-8"?>
<Error><Code>NoSuchKey</Code><Message>The specified key does not exist.</Message><Key>trip+data/yellow_tripdata_2019-02.csv</Key><RequestId>1E58CB163A50763A</RequestId><HostId>Up1JKmCAYMFPRDZwvGI+s/xv/1HEMlgoLqbl65PU+qLLs302PcoFw/HoIgXilQM+LM545etlRFo=</HostId></Error>

I'm not sure why the key doesn't exist as I can download the yellow taxi files manually.

If I try to store the data in a file, Alteryx says: process cannot access the file because it is being used by another process.

Can anyone think of a workaround please?

[afv2688]

Hello @Inactive User ,

This may be the possible solutions to your problem:

1. You could be trying to reference the wrong file.  Double check the path that you tried to retrieve.

2. Whenever the file was uploaded it must have failed.  Check the logs for your S3Sync process to see if you can find any relevant output

Edit: Other people seemd to see that the problem was the filename. It contained a hashtag # symbol, and I guess certain characters or symbols will also cause this error.

Regards

[Inactive User · Accepted solution]

According to https://stackoverflow.com/questions/7116450/what-are-valid-s3-key-names-that-can-be-accessed-via-the... it could be the + symbol. I've replaced it with a white space.