How to load the table from aws s3

Community Support
1

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.

 

2

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

3

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?

 

4

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!

5

Thank you so much David for the link.