How to load the table from aws s3

[supersaiyanraj]

Hi Team,

I'm trying to load a table from my AWS s3 bucket, But I got  `empty error.

How do I fix this issue?

I have to try this with a KXCE license.

[davidcrossey · Accepted solution]

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

[davidcrossey · Accepted solution]

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

[supersaiyanraj]

Thank you so much David for the link.

[PCarroll · Accepted solution]

If you included the full command it would help more @supersaiyanraj. 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]

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!