final-results.md

Final Results

Here, with successsful Cloud Run and Composer deployments, you will be able to see the loaded tables in BigQuery. I display mine, here, in order of load:

BigQuery Tables

posts

• Schema:

• Data:

comments

• Schema:

• Data:

insights

• Schema:

• Data:

Data Analysis

The tables are joinable on

posts.post_id = comments.postid = insights.post_id

For example, we can conduct analysis on recent comments linked to their parent posts:

SELECT *
FROM `winged-yeti-440908-r9.instagram_analytics.posts` p
LEFT JOIN `winged-yeti-440908-r9.instagram_analytics.comments` c
    ON p.post_id = c.postid
ORDER BY p.post_timestamp DESC;

Result:

Or, we may want to conduct analysis on post insights:

SELECT *
FROM `winged-yeti-440908-r9.instagram_analytics.posts` p
LEFT JOIN `winged-yeti-440908-r9.instagram_analytics.insights` i
    ON p.post_id = i.post_id
ORDER BY p.post_timestamp DESC;

Result:

---

Previous Step