GSP072_BigQuery-Qwik-Start-Console

GSP072 —— BigQuery: Qwik Start - Console

Table of Contents （🔎 Click to expand／collapse）

• Overview
• Open BigQuery
• Query Dataset
• Create Dataset
• Load Data into Table
• References

Overview

Storing and querying massive datasets can be time consuming and expensive without the right hardware and infrastructure. BigQuery is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google's infrastructure. Simply move your data into BigQuery and let us handle the hard work. You can control access to both the project and your data based on your business needs, such as giving others the ability to view or query your data.

You can access BigQuery in the Console, the classic Web UI or a command-line tool, or by making calls to the BigQuery REST API using a variety of client libraries such as Java, .NET, or Python. There are also a variety of third-party tools that you can use to interact with BigQuery, such as visualizing the data or loading the data.

Open BigQuery

1. Click Navigation Menu > BigQuery.
2. Click DONE in the Welcome to BigQuery in the Cloud Console dialog.

Query Dataset

1. Click Navigation Menu > BigQuery.
2. Write query into the BigQuery Query editor.
3. Click Run.

Create Dataset

1. Click Navigation Menu > BigQuery.
2. In the left pane, click our project name in the ∫ section.
3. Click Create Dataset.
4. Fill up all fields and then click Create dataset.

Load Data into Table

1. Click Navigation Menu > BigQuery.
2. Navigate to the dataset, then click CREATE TABLE.
3. In the Create Table dialog, set all the fields.
4. Click Create Table.

References

• Get Meaningful Insights with Google BigQuery | Google Cloud Labs | YouTube
• BigQuery: Qwik Start - Qwiklabs Preview | YouTube