README: Unable to query Public data using BigQuery Explorer
Describe the bug The Public Data section of the README starts with:
We run a weekly Scorecard scan of the 1 million most critical open source projects judged by their direct dependencies and publish the results in a BigQuery public dataset.
This data is available in the public BigQuery dataset openssf:scorecardcron.scorecard-v2. The latest results are available in the BigQuery view openssf:scorecardcron.scorecard-v2_latest.
You can query the data using BigQuery Explorer by navigating to Add Data > Star a project by name > 'openssf'.
Reproduction steps Steps to reproduce the behavior:
- Open the BigQuery Explorer page linked above
Expected behavior Having access to an Add Data function
Additional context I do not know Google Cloud, but what I see - after having logged in and accepted conditions - is the message:
To view this page, select a project.
BQ's interface is a little wonky--see screenshots below for how to access the public dataset.
1: click '+ ADD'
2: click 'Star a project by name'
3: enter 'openssf'
4: voila
Thank you @ssquared1147 Unfortunately, I dot not see anything like your first screenshot and have no idea how to reach the Explorer section you appear to be in.
Ah, you're going to have to make an account then. This is what you would eventually log in to: https://console.cloud.google.com/bigquery. And here is a walkthrough of all the set up stuff: https://cloud.google.com/bigquery/docs/sandbox
Thanks @ssquared1147 but I'm sorry to say I still don't see how to query. What kind of account are you talking about?