scorecard icon indicating copy to clipboard operation
scorecard copied to clipboard

README: Unable to query Public data using BigQuery Explorer

Open Chealer opened this issue 1 year ago • 4 comments

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.

Chealer avatar Apr 02 '24 12:04 Chealer

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

ssquared1147 avatar May 31 '24 18:05 ssquared1147

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.

Chealer avatar Jun 01 '24 00:06 Chealer

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

ssquared1147 avatar Jun 03 '24 18:06 ssquared1147

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

Chealer avatar Jun 03 '24 20:06 Chealer