How to load the table from aws s3

Community Support
,
1

https://learninghub.kx.com/forums/topic/how-to-load-the-table-from-aws-s3

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

Thank you so much David for the link.

5

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!