hey y’all 👋 i’m using

tap-google-sheets

with

target-redshift

(both default from hub.meltano.com) and am running into an issue.

[error    ] Loading failed     code=1 message=FileNotFoundError: [Errno 2] No such file or directory: '/tmp/foo bar/baz by foobar.csv.1'

(sheet name changed for confidentiality but format is the same) every other sheet, with or without a forward slash, has a

/tmp/

csv file successfully created in the s3 bucket, but this one isn’t created which throws the above error when loading into redshift. i’ve set

--log-level=debug

but i’m not finding where the root of this issue lies. anyone else ran into this? any assistance is appreciated!

Hi @rafa, I’m running into this issue today. Did you figure out what was wrong with yours?

hey @jeanette_urbanski, i still haven’t found a solution

Will let you know if I figure anything out!

thanks! i’ll do the same

@rafa I figured out my issues. One of my sheets was called

Widgets/Plugins

and it seemed to interpret the

/

as a location path rather than treating the entire name as a string. I changed it to

Widgets & Plugins

and the ingest ran fine.

interesting! good find

Wonder if it’s something to do with this line https://github.com/singer-io/tap-google-sheets/blob/master/tap_google_sheets/streams.py#L141

potentially. could also be how the tap is sending stream name to the target: https://github.com/singer-io/tap-google-sheets/blob/master/tap_google_sheets/streams.py#L570