cancel
Showing results for 
Search instead for 
Did you mean: 

How to load the table from aws s3

supersaiyanraj
New Contributor II

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.

rajrs_ece_0-1647950645966.png

 

2 ACCEPTED SOLUTIONS

davidcrossey
Moderator Moderator
Moderator

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

David

View solution in original post

PCarroll
Community Manager Community Manager
Community Manager

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?
 

View solution in original post

4 REPLIES 4

davidcrossey
Moderator Moderator
Moderator

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

David


Thank you so much David for the link.

PCarroll
Community Manager Community Manager
Community Manager

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?
 

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!