如何在Google BigQuery控制台中删除现有项目并添加bigquery-public-data数据集

Got it, let's walk through this step by step—perfect for your Coursera data analysis practice!

Before you start, a critical note: deleting a project is permanent, so double-check you don’t need any data or resources from it first. Here’s how to do it:

• Open the Google BigQuery Console, find your project list in the left navigation pane, and click the name of the project you want to delete to enter its page.
• Click the Project Settings icon (the gear-shaped one) at the top of the page to access the settings interface.
• Scroll all the way to the bottom of the settings page, locate the "Delete project" option, and click the "Delete" button.
• You’ll be prompted to enter the project ID to confirm—type it in and hit "Confirm delete" to finish the process.

This public dataset is a goldmine for learning data analysis, packed with real-world datasets to work with. Here’s how to add it to your workspace:

• Go back to the main BigQuery Console page. In the Resources section of the left navigation pane, click the "Add data" button, then select "Add from a BigQuery public dataset".
• In the pop-up search box, type bigquery-public-data. When you see the dataset appear in the results, click "View dataset".
• Select your active practice project (if you don’t have one yet, create a blank new project first—it’s free for basic usage), then click "Confirm".
• Once done, you’ll see bigquery-public-data show up in your left Resources panel. You can expand it to explore all the sub-datasets (like census data, GitHub archives, weather data, etc.)—ideal for your Coursera exercises.

快速验证访问权限 #

If you want to make sure everything’s set up correctly, open the SQL editor and run this simple query:

SELECT * FROM bigquery-public-data.samples.gsod LIMIT 10;

If it returns 10 rows of weather data, you’re all set to start practicing!

内容的提问来源于stack exchange，提问作者Joe thetraveller