I am creating a project board and eventually a wiki for the Google #bigquery / Pushshift integration. However, #reddit comments are now streaming live into BQ! Could someone please confirm that they can access the dataset?
You will need to switch from legacy SQL on the Google BQ dashboard. Just try to do a simple select:
SELECT * FROM `pushshift.rt_reddit.comments` LIMIT 10
The dashboard should be located here: https://bigquery.cloud.google.com