Adding and Querying Data in Cloud Firestore

1.75 hours
  • 3 Learning Objectives

About this Hands-on Lab

Data comes in all shapes, sizes, and use cases. A relational database service like Cloud SQL isn’t always the answer. Cloud Firestore is a NoSQL database service, ideal for semi-structured data that needs to be highly scalable and available. Cloud Firestore is the next generation of Datastore with enhanced features, and in this hands-on lab, you’ll see how to build a Firestore NoSQL database in Cloud Datastore mode for the best of both worlds.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create the Database
  1. From the main navigation, click Firestore.
  2. Choose Datastore Mode.
  3. Set the region to us-east1.
  4. Click Create database.
Define the Entities
  1. For Kind, enter Flights.
  2. Click Create Entity.
  3. Click Add property and add each of the following entries:
    • Airline: String
    • Flight Number: Integer
    • Arrival: Data and Time
    • OnTime: Boolean
  4. Click Create.
  5. Repeat steps 3 and 4 twice more with different values.
  6. For the final entry, add another property:
    • Note: Text
  7. Click Create.
Query the Data
  1. Switch to Query by GQL.
  2. In the Query field, enter the following:
    SELECT * FROM `Flights`
  3. Click Run Query.
  4. In the Query field, enter the following:
    SELECT * FROM `Flights` WHERE OnTime = false
  5. Click Run Query.
  6. Review the results.

Additional Resources

You’ve been tasked with setting up a non-relational database for ACG International to track flights, arrival times, and on-time statuses. You decide to use Cloud Firestore in Datastore mode because of its flexible NoSQL structure. After establishing the initial data, you need to run several queries in GQL to ensure all the necessary properties are searchable.

You’ll need to accomplish the following steps to complete your task:

  1. Enable the API
  2. Create the database
  3. Create the entities
  4. Query the data

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?