Amazon S3 multiple file impoort

[harishmurthy_k_srb_in]

I have Multiple objects in my AWS Path, and i need to import all of them to consolidate the data. I tried using Regular Expressions ( Such as * , etc) but its throwing the error, does anyone know how to resolve this issue OR is there any alternative ways to do it ? 

[alexnajm]

Have you tried using the AWS tools on the marketplace built by Aimpoint? https://marketplace.alteryx.com/en-US/apps/424306/aws-tools-by-aimpoint-digital

[alexnajm]

More here: https://aimpointdigital.com/alteryx-aws-tools/

[kc20]

I'm giving AWS tools by Aimpoint a shot and getting error "Amazon S3 Download (8) No module named 'boto3'"

[apathetichell]

@kc20 Boto3 is the Python AWS package. I am 99% sure that under the hood Aimpoint installs this package (or checks for it). If you are seeing that error - you probably cannot install it. Can you run Alteryx at admin. Open a Python tool -and type:

Alteryx.installPackage("boto3")

- check for errors. try to fix errors. re-run S3 workflow.

[kc20]

That did the trick, thank you!

[kc20]

@alexnajm any plan to include role base authentication for AWS tools? 

[apathetichell]

@kc20 - I'd recommend doing this via Run command/CLI scripting.

[kc20]

any explain CLI script that anyone can share?

[mmichaelson]

@kc20 This article may have what you're looking for:

https://knowledge.alteryx.com/index/s/article/Extending-Integration-with-AWS-1583460914693