menu
arrow_back

Loading Data into Google Cloud SQL

1m setup · 60m access · 45m completion
Connection Details

7 Credits

info_outline
This lab costs 7 Credits to run. You can purchase credits or a subscription under My Account.

01:00:00

Loading Data into Google Cloud SQL

GSP196

Google Cloud Self-Paced Labs

Overview

In this lab, you will learn how to import data from CSV text files into Cloud SQL and then carry out some basic data analysis using simple queries.

The dataset used in this lab comes from the US Bureau of Transport Statistics and contains historical information about internal flights in the United States. This dataset can be used to demonstrate a wide range of data science concepts and techniques and is used in all of the labs in the Data Science on Google Cloud Platform Quest.

Join Qwiklabs to read the rest of this lab...and more!

  • Get temporary access to the Google Cloud Console.
  • Over 200 labs from beginner to advanced levels.
  • Bite-sized so you can learn at your own pace.
Join to Start This Lab
Score

—/15

Create a Cloud SQL instance

Run Step

/ 5

Whitelist the Cloud Shell instance to access your SQL instance

Run Step

/ 5

Create a bts database and flights table using the create_table.sql file

Run Step

/ 5

home
Home
school
Catalog
menu
More
More