Why data services matter in GCP - See It in Action

Why Data Services Matter in GCP

📖 Scenario: You are working for a small company that wants to store and analyze customer data securely and efficiently. They have chosen Google Cloud Platform (GCP) to build their data storage and processing system.Understanding why data services matter will help you design a system that keeps data safe, easy to access, and ready for analysis.

🎯 Goal: Build a simple GCP data storage setup using Cloud Storage and BigQuery to show how data services help manage and analyze data effectively.

📋 What You'll Learn

Create a Cloud Storage bucket named customer-data-bucket

Create a BigQuery dataset named customer_analysis

Create a BigQuery table named customers with columns id (integer) and name (string)

Load sample data into the BigQuery table

Write a query to select all customers from the table

💡 Why This Matters

🌍 Real World

Companies use data services like Cloud Storage and BigQuery to store large amounts of data safely and analyze it quickly to make business decisions.

💼 Career

Knowing how to set up and use GCP data services is essential for cloud engineers, data analysts, and developers working with cloud data solutions.

1

Create a Cloud Storage bucket

Write the gcloud command to create a Cloud Storage bucket named customer-data-bucket in the us-central1 region.

GCP

# Your gcloud command here to create the bucket

Need a hint?

Use gcloud storage buckets create followed by the bucket name and --location flag.

2

Create a BigQuery dataset

Write the gcloud command to create a BigQuery dataset named customer_analysis in the us-central1 location.

GCP

gcloud storage buckets create customer-data-bucket --location=us-central1
# Your gcloud command here to create the BigQuery dataset

Need a hint?

Use gcloud bigquery datasets create with the dataset name and location.

3

Create a BigQuery table

Write the bq command to create a BigQuery table named customers in the customer_analysis dataset with schema id:INTEGER,name:STRING.

GCP

gcloud storage buckets create customer-data-bucket --location=us-central1
gcloud bigquery datasets create customer_analysis --location=us-central1
# Your bq command here to create the table

Need a hint?

Use bq mk --table with dataset.table and schema.

4

Load sample data and query

Write the bq command to insert sample data with id=1 and name='Alice' into the customers table, then write a query to select all rows from customer_analysis.customers.

GCP

gcloud storage buckets create customer-data-bucket --location=us-central1
gcloud bigquery datasets create customer_analysis --location=us-central1
bq mk --table customer_analysis.customers id:INTEGER,name:STRING
# Your bq commands here to insert data and query

Need a hint?

Use bq query with SQL commands to insert and select data.