KX Community

Find answers, ask questions, and connect with our KX Community around the world.

Home Forums kdb Insights How to load the table from aws s3

  • How to load the table from aws s3

    Posted by supersaiyanraj on March 22, 2022 at 12:00 am

    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.

     

     

    supersaiyanraj replied 2 months, 3 weeks ago 3 Members · 4 Replies
  • 4 Replies
  • davidcrossey

    Member
    March 23, 2022 at 12:00 am

    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

    Member
    March 23, 2022 at 12:00 am

    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

    Member
    March 25, 2022 at 12:00 am

    Thank you so much David for the link.

  • supersaiyanraj

    Member
    March 25, 2022 at 12:00 am

    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!

Log in to reply.