Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
Chealer opened this issue Apr 2, 2024 · 4 comments
Open

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

Chealer opened this issue Apr 2, 2024 · 4 comments
Labels
kind/bug Something isn't working

Comments

@Chealer
Copy link

Chealer commented Apr 2, 2024

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 Chealer added the kind/bug Something isn't working label Apr 2, 2024
@Chealer Chealer changed the title README: Unable to query data using BigQuery Explorer README: Unable to query Public data using BigQuery Explorer Apr 2, 2024
@ssquared1147
Copy link

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
Copy link
Author

Chealer commented Jun 1, 2024

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
Copy link

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
Copy link
Author

Chealer commented Jun 3, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/bug Something isn't working
Projects
Status: No status
Development

No branches or pull requests

2 participants