Meltano

image.png

Hi everyone! In tap-spreadsheets-anywhere there is no aws access key and aws secret key environment variables. How can i get a json file from my s3 bucket? Link: <https://hub.meltano.com/extractors/tap-spreadsheets-anywhere/>

I think is that my problem, but im not sure about that. Below we can see that the connection to aws is not being executed.

Hi Felipe, was going through that as well - the tap uses <https://github.com/RaRe-Technologies/smart_open|smart open> - and there is <https://github.com/RaRe-Technologies/smart_open#s3-credentials|section> on credentials for S3 - you can basically use any way supported by boto3  - environment variables, config file,…

Hi Marek. I have already done that with my .env file, but it is not working.

My tap configuration:

`- name: tap-spreadsheets-anywhere`
    `variant: ets`
    `pip_url: git+<https://github.com/ets/tap-spreadsheets-anywhere.git>`
    `config:`
      `tables:`
      `- path: <s3://my-bucket>`
        `format: json`
        `key_properties: []`
        `name: test`
        `start_date: '2020-01-01T00:00:00Z'`
        `pattern: path/test.json`

Finally i fixed this problem installing aws-cli in my computer and configuring  aws access key and aws secret access key using `aws configure` command. I hope that can help others guys.