Skip to main content

Comments

7 comments

  • Jason Harris

    Hi Tiffany,
    I’m looking into this myself and alerting our support.
    I’ll try to get an answer soon.

    0
  • Jason Harris

    Hey there @tiffany6872, I just did a fresh import based off the S3 Bucket holding the Shinesty data sets…and these fields have data.

    I’ve attached a screenshot below:
    34%20AM

    0
  • Jason Harris

    Please re-check your procedure against the instructions.

    For example, did you click advanced and set the delimiter with the | (pipe) ? It’s the sixth bullet point.

    0
  • marcia.cook

    Yes I used the pipe per the instructions. I’ll try with this new import and check back in just a few minutes. Thanks.

    0
  • marcia.cook

    It’s possible I am doing something very wrong:

    Here is what I am using for the S3 pull:

    But there is no results when running looking for likes_count.Some fields show up, but not the ones I need. I tried to post a screenshot of the empty fields but the forum is only allowing me to post one picture.

    Is my config correct?

    My query is
    SELECT * FROM shinesty_ WHERE likes_count IS NOT NULL;

    0
  • marcia.cook

    I also tried with Kirsten’s instagram with the same results. I’d like to use Kirsten’s for the challenge if I can get it working.

    0
  • Jason Harris

    Ok I see two issues.

    One - your destination is set incorrectly. It should be: ShinestyInstagram_{table_name}

    So your tables are coming in with the wrong names.

    Secondly, your query is incorrect…in your case, there’s no table named shinesty_

    When you do your import correctly, the table name with that column will be instagram_media

    For more info on table names and columns - see the docs.

    0

Please sign in to leave a comment.

Powered by Zendesk