Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://developers.google.com/bigquery/docs/quickstarts/quickstart-web-ui below:

Query a public dataset with the Google Cloud console

Stay organized with collections Save and categorize content based on your preferences.

Learn how to locate and query public datasets in BigQuery by using the Google Cloud console.

To follow step-by-step guidance for this task directly in the Google Cloud console, click Guide me:

Guide me

1. Sign in to your Google Cloud account. If you're new to Google Cloud, create an account to evaluate how our products perform in real-world scenarios. New customers also get $300 in free credits to run, test, and deploy workloads.

2. In the Google Cloud console, on the project selector page, select or create a Google Cloud project.

   Note: If you don't plan to keep the resources that you create in this procedure, create a project instead of selecting an existing project. After you finish these steps, you can delete the project, removing all resources associated with the project.

   Go to project selector

3. Make sure that you have the following role or roles on the project: BigQuery Job User, Service Usage Admin

   Check for the roles

   1. In the Google Cloud console, go to the IAM page.

      Go to IAM
   2. Select the project.

   3. In the Principal column, find all rows that identify you or a group that you're included in. To learn which groups you're included in, contact your administrator.

   4. For all rows that specify or include you, check the Role column to see whether the list of roles includes the required roles.
   Grant the roles

   1. In the Google Cloud console, go to the IAM page.

      Go to IAM
   2. Select the project.
   3. Click person_add Grant access.

   4. In the New principals field, enter your user identifier. This is typically the email address for a Google Account.

   5. In the Select a role list, select a role.
   6. To grant additional roles, click add Add another role and add each additional role.
   7. Click Save.

4. In the Google Cloud console, on the project selector page, select or create a Google Cloud project.

   Note: If you don't plan to keep the resources that you create in this procedure, create a project instead of selecting an existing project. After you finish these steps, you can delete the project, removing all resources associated with the project.

   Go to project selector

5. Make sure that you have the following role or roles on the project: BigQuery Job User, Service Usage Admin

   Check for the roles

   1. In the Google Cloud console, go to the IAM page.

      Go to IAM
   2. Select the project.

   3. In the Principal column, find all rows that identify you or a group that you're included in. To learn which groups you're included in, contact your administrator.

   4. For all rows that specify or include you, check the Role column to see whether the list of roles includes the required roles.
   Grant the roles

   1. In the Google Cloud console, go to the IAM page.

      Go to IAM
   2. Select the project.
   3. Click person_add Grant access.

   4. In the New principals field, enter your user identifier. This is typically the email address for a Google Account.

   5. In the Select a role list, select a role.
   6. To grant additional roles, click add Add another role and add each additional role.
   7. Click Save.

6. Verify that billing is enabled for your Google Cloud project.

If you don't enable billing for the Google Cloud project that you use in this tutorial, then you will upload and work with data in the BigQuery sandbox. The BigQuery sandbox lets you learn BigQuery with a limited set of BigQuery features at no charge.

7. Ensure that the BigQuery API is enabled.

   Enable the API

   If you created a new project, the BigQuery API is automatically enabled.

BigQuery public datasets are available by default in the Google Cloud console.

In the following example, you access datasets in the public project bigquery-public-data.

1. In the Google Cloud console, go to the BigQuery page.

   Go to BigQuery

2. In the Explorer pane, click +Add data .

3. In the Add data dialog, in the Filter By pane, click Public datasets.

4. You can use the Search Marketplace field or filters to narrow down your search.

5. Select a dataset, and then click View dataset.

   In the Explorer pane, your dataset is selected and you can view its details.

6. Optional: Click more_vert View actions next to your dataset to view more options.

   Each dataset contains tables, which you can view by clicking arrow_right Toggle node next to any dataset.

In the following steps, you query the USA Names public dataset to determine the most common names in the United States between 1910 and 2013:

1. In the Google Cloud console, go to the BigQuery page.

   Go to BigQuery

2. Click add_box SQL query .

3. In the query editor , copy the following query:

   SELECT
     name,
     SUM(number) AS total
   FROM
     `bigquery-public-data.usa_names.usa_1910_2013`
   GROUP BY
     name
   ORDER BY
     total DESC
   LIMIT
     10;
   

   If the query is valid, then a check mark appears along with the amount of data that the query processes. If the query is invalid, then an exclamation point appears along with an error message.

4. Click Run .

   The most common names are listed in the Query results section. The table's header row contains each column name that you selected in the query.

5. Optional: To display the duration and the amount of data that the query processed, click the Job information tab in the Query results section.

To avoid incurring charges to your Google Cloud account for the resources used on this page, follow these steps.

If you used the BigQuery sandbox to query the public dataset, then billing is not enabled for your project.

The easiest way to eliminate billing is to delete the project that you created for the tutorial.

To delete the project:

Caution: Deleting a project has the following effects:
• Everything in the project is deleted. If you used an existing project for the tasks in this document, when you delete it, you also delete any other work you've done in the project.
• Custom project IDs are lost. When you created this project, you might have created a custom project ID that you want to use in the future. To preserve the URLs that use the project ID, such as an appspot.com URL, delete selected resources inside the project instead of deleting the whole project.

If you plan to explore multiple architectures, tutorials, or quickstarts, reusing projects can help you avoid exceeding project quota limits.

1. In the Google Cloud console, go to the Manage resources page.

   Go to Manage resources

2. In the project list, select the project that you want to delete, and then click Delete.
3. In the dialog, type the project ID, and then click Shut down to delete the project.

• Learn about the BigQuery sandbox.
• Learn how to create a dataset and query tables in the Google Cloud console.
• Get updates about BigQuery.
• Learn about BigQuery pricing.
• Learn about BigQuery quotas and limits.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-08-07 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["This guide explains how to locate and query public datasets in BigQuery using the Google Cloud console."],["Before starting, you must enable billing for your Google Cloud project or use the BigQuery sandbox, which provides a limited, free environment."],["You can access public datasets within the Google Cloud console by searching for \"public datasets\" in the **Explorer** pane."],["A step-by-step process is provided to run a SQL query against the \"USA Names\" public dataset to find the most common names between 1910 and 2013."],["The tutorial covers how to delete the entire project to avoid incurring charges, as well as alternative options to preserve project IDs if necessary."]]],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4