How to load the table from aws s3

[davidcrossey]

Hi Raj,

Please refer to Object storage | KX Insights Core on how to load a database table from an AWS S3 bucket.

Hope this helps.

Kind regards,

David

[pcarroll]

If you included the full command it would help more . Generally speaking there might be permission issues for you to access the bucket and/or issues with the loading of the table. Some good points to confirm on this would be…

• Can you use aws cli to copy the table outside of q prompt?
• Can you load the table if it were stored on file storage rather than local?

[supersaiyanraj]

Thank you so much David for the link.

[supersaiyanraj]

Hi @PCarroll,
I think same, it might be a some permission issues for accessing s3 bucket.

1. Yes, I copied the table to s3 with outside of q prompt.
2. I can load the table from my local. But, I get the error when  I try to load the same table from my s3.

Thanks for your response!