Lab
A Cloud Guru

Adding and Querying Data in Cloud Firestore

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.

Try for free Contact sales

Path Info

Level

Intermediate

Duration

1h 45m

Published

Jun 03, 2022

Challenge

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.
Challenge

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.
Challenge

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.

Author

A Cloud Guru

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

What's a lab?

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.