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