Join Joseph Lowery for an in-depth discussion in this video Managing data projects, part of Up and Running with Google Cloud Platform (2013).
BigQuery, along with the other components of the Google Cloud platform, provides a basic interface for managing separate projects. You can even create a team and control any members access. Let's start from our project based Google Cloud console page. Now, I'll click BigQuery. There are my recent queries on the right, and if you expand the down arrow, next to the project name, you'll see the start of some management options. We can create a new data set, switch to a different project, or refresh the page. Before we look at different projects, let me click off of that, and let's look at the down arrow next to selected data sets, so you can see those options. Here's where you would create a new table.
You can also share the data set and set permissions for those with access. I'll click that, so you can see who currently has access, project readers, writers, and owners. And we can easily add anyone via their e-mail address. They'll need to accept the request to confirm it. Let me hit Cancel. Any people you've added will show up on your team, which I'll cover in a bit. You can also delete the data set when you no longer need it. Now, let's move on to table management. So, I'll expand the data set to show our various tables. And again, when I hover a table, click the down arrow, you can see the available options.
You can copy the table to the same, or a different data set in the same project. You can also export the table. Let me choose Export Table. You can export it in either CSV or JSON format. Tables are exported to a specific Google Cloud storage location or URI. We haven't set that up yet, so it's not available to us at this time. And, of course, you could delete the table. Okay. So, let's jump back to that switch to project menu I found by expanding the project options.
It shows the current project, and I could display another project if I had one. Since I don't, and if I choose display project, the Add Project dialog box is displayed. Now, under the same menu, let's choose Switch to project > Manage projects. This will take us to the dashboard page under Google APIs, which we saw in an earlier lesson. We can get the BigQuery specific information by clicking BigQuery in the left column.
And now, you can see our spike of usage over on the right side of the chart. Earlier, I mentioned the team potential. This is were we set that up. Click team to see the current line up. It shows the Google administrators, who have access to your project, should anything go wrong, the overall project and yourself. You can easily add members here. Again, I'll click Add Member, all you need to know is the e-mail address and permission level. Anyone added is listed on the "Teams" page, with their access level shown, editable by any owners of the project. As you can see, many of the management functions overlap. Team members set up in BigQuery are available to the same project in App Engine and vice versa, as well as most other components. Managing data is just one aspect of overall project management on the Google Cloud platform.
- Why Google Cloud Platform?
- Deploying an app with Google App Engine
- Activating and working with Google Cloud Storage
- Loading, querying, and exporting data with BigQuery
- Working with Cloud Storage buckets
- Managing cloud-based private networks
- Importing and exporting data
- Scheduling backups
- Working with Google Datastore