search

ossf / scorecard

OpenSSF Scorecard - Security health metrics for Open Source
https://scorecard.dev
Apache License 2.0
4.26k stars 462 forks source link

README: Unable to query Public data using BigQuery Explorer #3989

Open Chealer opened 3 months ago

Chealer commented 3 months ago

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:

  1. 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.

ssquared1147 commented 1 month ago

BQ's interface is a little wonky--see screenshots below for how to access the public dataset. 1: click '+ ADD' 1

2: click 'Star a project by name' 2

3: enter 'openssf' 3

4: voila 4

Chealer commented 1 month ago

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.

ssquared1147 commented 1 month ago

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

Chealer commented 1 month ago

Thanks @ssquared1147 but I'm sorry to say I still don't see how to query. What kind of account are you talking about?