what does it mean the error “extra keys not allowed @ data[‘tables’][0][‘skip_initial’]” in tap-spreadsheets-anywhere? Here is the config:

- path: ${AWS_S3_ENDPOINT_URL}
        name: project
        pattern: file.xlsx
        worksheet_name: "Data"
        format: excel
        skip_initial: 1

Can you share the whole

meltano.yml

? It does look correct based on the snippet shown, so I wonder if the issue is elsewhere in the config?

No need to share the config. I found the culprit, which is a bit weird. I’m using 2 variants of the tap-spreadsheets-anywhere: the default - ets and rfainc - the one with the most updated code from the list (nov 23) Only with rfainc works to pick up files from s3, but this one does not have skip_initial implemented.

OK glad that explains it. In general the more you can share from your meltano.yml up front (in a reply to your main post) we can spot things like this quicker.

I’ll raise an issue on the ets repo with this. What do you recommend to make it work now? Should I fork it and create another variant with the fix or there is a simpler solution?

Pretty sure our variant supports both S3 and skip initial. https://github.com/Matatika/tap-spreadsheets-anywhere

thank you @aaron_phethean Yours works like a breeze