Google Bigquery on reddit database to get post along with all the comments

I am new to Google Big-query, I want to extract post title,post body,comments, score and the creation date from the database for all posts that are created on or after 2010 for a subreddit, for now I have been able to query all subreddit comments using

SELECT * FROM `pushshift.rt_reddit.comments` WHERE lower(subreddit)="politics"

But my motive is to join the comments and posts table in order to generate the required results but I am not able to find how to do this, how can that be achieved? Please let me know if any further details are required. Thanks

asked 3 hours ago
Pratik SinghPratik Singh

1051 silver badge10 bronze badges

Latest posts