Data comes in all shapes, sizes, and use cases. A relational database service like Cloud SQL isn’t always the answer. Cloud Datastore 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:
- Enable APIs.
- From the main navigation, click APIs and Libraries > Library.
- Search for Datastore.
- Click Enable.
- Create the database.
- From the main navigation, click Datastore.
- Choose Datastore Mode.
- Set the region to us-east1.
- Click Create database.
- Define entities.
- For Kind, enter Flights.
- Click Create Entity.
- Click Add property for each of the following entries, of the specified type:
- Airline: String
- Flight Number: Integer
- Arrival: Data and Time
- OnTime: Boolean
- Click Save.
- Repeat steps 3 and 4 twice more with different values.
- For the final entry, add another property:
- Note: Text
- Click Save.
- 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 results.
