This lab was developed with our partner, MongoDB. Your personal information may be shared with MongoDB, the lab sponsor, if you have opted-in to receive product updates, announcements, and offers in your Account Profile.

Note: This lab requires a partner account. Please follow the lab instructions to create your account before starting the lab.

GSP1093

Overview

MongoDB Atlas is a developer data platform, integrating a multi-cloud database with a diverse set of data services. Atlas simplifies database deployment and management while enabling modern data-driven application development.

In this introductory-level lab, you will get hands-on practice with MongoDB Atlas. You will create your first cloud database deployment, add data, build database indexes, set up database triggers, and connect to Google Cloud APIs. If you're new to Atlas, you came to the right place!

You will also deploy a fully-fledged MEAN stack application that queries the data from your Atlas database to Google Cloud Run. The application will allow you to leave comments for cake recipes. The comments' sentiments will be analyzed by the Google Cloud Natural Language API as you post them.

Objectives

In this lab, you will do the following:

• Provision your first MongoDB Atlas database deployment
• Create a database, collections with data, and indexes through the Atlas UI
• Integrate a Google Cloud API with MongoDB Atlas Triggers and Functions
• Deploy a MEAN stack application on Google Cloud Run

Prerequisites

Since this lab is an introduction to MongoDB Atlas, you will need an Atlas account. Create an account before you click Start Lab. You can do that in one of two ways:

• Through the Google Cloud Marketplace if you have a Google Cloud account.
• With the Atlas registration page.

Save this account information! The Atlas account is completely free and will be available for you after you complete this lab.

Setup and requirements

Before you click the Start Lab button

Read these instructions. Labs are timed and you cannot pause them. The timer, which starts when you click Start Lab, shows how long Google Cloud resources will be made available to you.

This hands-on lab lets you do the lab activities yourself in a real cloud environment, not in a simulation or demo environment. It does so by giving you new, temporary credentials that you use to sign in and access Google Cloud for the duration of the lab.

To complete this lab, you need:

• Access to a standard internet browser (Chrome browser recommended).

Note: Use an Incognito or private browser window to run this lab. This prevents any conflicts between your personal account and the Student account, which may cause extra charges incurred to your personal account.

• Time to complete the lab---remember, once you start, you cannot pause a lab.

Note: If you already have your own personal Google Cloud account or project, do not use it for this lab to avoid extra charges to your account.

How to start your lab and sign in to the Google Cloud console

1. Click the Start Lab button. If you need to pay for the lab, a pop-up opens for you to select your payment method. On the left is the Lab Details panel with the following:

   • The Open Google Cloud console button
   • Time remaining
   • The temporary credentials that you must use for this lab
   • Other information, if needed, to step through this lab

2. Click Open Google Cloud console (or right-click and select Open Link in Incognito Window if you are running the Chrome browser).

   The lab spins up resources, and then opens another tab that shows the Sign in page.

   Tip: Arrange the tabs in separate windows, side-by-side.

   Note: If you see the Choose an account dialog, click Use Another Account.

3. If necessary, copy the Username below and paste it into the Sign in dialog.

   {{{user_0.username | "Username"}}}

   You can also find the Username in the Lab Details panel.

4. Click Next.

5. Copy the Password below and paste it into the Welcome dialog.

   {{{user_0.password | "Password"}}}

   You can also find the Password in the Lab Details panel.

6. Click Next.

   Important: You must use the credentials the lab provides you. Do not use your Google Cloud account credentials. Note: Using your own Google Cloud account for this lab may incur extra charges.

7. Click through the subsequent pages:

   • Accept the terms and conditions.
   • Do not add recovery options or two-factor authentication (because this is a temporary account).
   • Do not sign up for free trials.

After a few moments, the Google Cloud console opens in this tab.

Note: To view a menu with a list of Google Cloud products and services, click the Navigation menu at the top-left.

Task 1. Create an Atlas project and deploy a database

In this section, you will spin up your first MongoDB Atlas database deployment.

Provision a free database deployment

Deploy your first forever-free database in MongoDB Atlas! You'll do that using the Atlas UI, so make sure you're logged into your account.

1. Click Database from the left side menu, under the DEPLOYMENT heading.
2. Click on the Create button right under Build a Database.

Note: If you are not able to see the Create a deployment section, you might already have a database deployment. You can use it or delete it and deploy a new one.

3. You have the option to choose between a dedicated, serverless, and shared deployment. We recommend using the free shared M0 deployment for this lab.
4. Select Google Cloud as your Cloud Provider. Select any region.
5. Rename your cluster to Workshop-Bakery.
6. Click Create Deployment to deploy your database.

Security Quickstart

From the Navigation click Security > Quickstart. By default, every Atlas deployment is completely locked down. That's why you must create a database user and configure network access.

Note: Even though Atlas might have already created a database user for you, create a new one from scratch and remember your credentials.

Next, you must configure network access between Atlas and your Google Cloud environment. The best way to do this is by setting up VPC peering or a private endpoint. These features are available only for the paid tier of Atlas deployments. To ensure that this lab remains free and you can still connect to your database deployment, you'll allow access from everywhere.

Add the following entry to the network access list: 0.0.0.0/0.

Note: You should never allow access from everywhere in a production environment. Instead, use VPC peering or a private endpoint.

To navigate back to your deployments, select Database from the left-hand menu.

Create a database and collection, and insert the first documents

In this section, you will browse the new deployment, learn how to create a new database, add a collection to that database, and insert documents.

You will use the Atlas UI for this section. However, all this can also be done with the Atlas CLI and MongoDB Shell.

1. Click the Browse Collections button to access the databases and collections in the deployment.

2. Currently, there are no databases or collections in your deployment. You will manually insert some data. Select Create Database.

3. Name the database Bakery and the collection cakes, then click Create.

Note :If you encounter an error while creating the database, log out and log back in with your MongoDB Atlas credentials.

Now the cakes collection has been created inside the new Bakery database. Time to add some data. The Atlas UI makes this really easy.

4. Click the Insert Document button in the top right corner.

5. When inserting data in the Atlas UI, you have two options of the view you want for adding data. We want to use the JSON view, so we can easily add some existing cake data. Click the {} button to switch views.

6. Delete what is currently in the box, add the following cake document, and then press Insert:

{ "_id": { "$oid": "64759d513beb40594cb859e9" }, "name": "Chocolate Cake", "shortDescription": "Chocolate cake is a cake flavored with melted chocolate, cocoa powder, or sometimes both.", "description": "Chocolate cake is made with chocolate; it can be made with other ingredients, as well. These ingredients include fudge, vanilla creme, and other sweeteners. The history of chocolate cake goes back to 1764, when Dr. James Baker discovered how to make chocolate by grinding cocoa beans between two massive circular millstones.", "image": "https://addapinch.com/wp-content/uploads/2020/04/chocolate-cake-DSC_1768.jpg", "ingredients": [ "flour", "sugar", "cocoa powder" ], "recipe": "Preheat your oven to the specified temperature and prepare a greased cake pan. Mix the dry and wet ingredients separately, then combine and pour the batter into the pan. Bake for the recommended time, let it cool, and optionally frost or decorate as desired.", "stock": 25 }

7. Repeat steps 4 and 5, this time adding the following cake document:

{ "_id": { "$oid":"64759e4c3beb40594cb859ed" }, "name": "Cheese Cake", "shortDescription": "Cheesecake is a sweet dessert consisting of one or more layers. The main, and thickest, layer consists of a mixture of a soft, fresh cheese (typically cottage cheese, cream cheese or ricotta), eggs, and sugar. ", "description": "Cheesecake is a sweet dessert consisting of one or more layers. The main, and thickest, layer consists of a mixture of a soft, fresh cheese (typically cottage cheese, cream cheese or ricotta), eggs, and sugar. If there is a bottom layer, it most often consists of a crust or base made from crushed cookies (or digestive biscuits), graham crackers, pastry, or sometimes sponge cake.[1] Cheesecake may be baked or unbaked (and is usually refrigerated).", "image":"https://sallysbakingaddiction.com/wp-content/uploads/2018/05/perfect-cheesecake-recipe.jpg", "ingredients": [ "graham cracker crumbs", "sugar", "eggs", "butter", "sour cream", "cream cheese", "vanilla extract" ], "recipe": "Mix graham cracker crumbs and melted butter for the crust. Press into a pan. Beat cream cheese, sugar, and vanilla. Fold in whipped cream. Pour over the crust. Refrigerate until set, remove from pan, and serve chilled with desired toppings.", "stock": 40 }

8. Add a second collection to your Bakery database to store the comments that people can leave on each cake. Hover your mouse over Bakery in the left panel and there will be a + sign to add a new collection.

9. Click the plus (+) sign and add a new collection called comments.

10. Add a new comment by copy-pasting the document below.

{ "_id": { "$oid": "6475be48a10dcef00d5c7d9c" }, "cakeId": { "$oid": "64759d513beb40594cb859e9" }, "name": "Peter Quill", "text": "This recipe was super easy to follow and the result was delicious!", "date": { "$date": { "$numberLong": "1685750400000" } } }

You now have your Atlas database set up with some cake data, and even a comment associated with one of the cakes!

Add indexes to your database

MongoDB automatically creates an index on the unique identifier field, _id, of every collection. This optimization allows optimized queries when fetching a document, such as a cake or a comment, by its ID.

Later on, you will deploy a web application that enables you to browse various cake recipes and read comments left by different users for each recipe. To fetch every comment associated with a specific recipe, the application will query the comments collection and filter the results based on the cakeId field.

The query looks something like this:

db.comments.find({ cakeId: cake._id })

This query will retrieve only the comments linked to the specified cake. To optimize the query, let's add an index to the cakeId field in the comments collection.

While you have the comments collection open, click on Indexes.

You should see the already existing index on the _id field, along with information about the type, size and usage of the index. Click Create Index and add the following in the Fields section.

{ "cakeId": 1 }

Click Review and then Confirm to create the new index on the cakeId field.

Task 2: Analyze text sentiment with the Google Cloud Natural Language API

Next, you will set up an Atlas Trigger and a Function that will analyze the sentiment of new comments as they are inserted into the database. You will utilize the Google Cloud Natural Language API for the analysis.

Generate a Google Cloud API key

1. First, open the Google Cloud console and log in with the temporary credentials that were generated for this lab.
2. Let's ensure that the Natural Language API is enabled. In the Google Cloud console, under Marketplace search for Cloud Natural Language API and select it from the list.
3. Verify that the API is already enabled and click on Manage.
4. This will take you to the Natural Language API page for your project. You will need to generate an API key to use it. Select Credentials from the left-hand menu.
5. Click Create Credentials at the top of the browser window and select API Key from the dropdown box to generate a key.
6. Copy the API key that has been generated for you.

Set up an Atlas Trigger

The next step is to configure the Atlas Trigger that tracks any new comments as they come in the database.

1. Go back to the Atlas UI and make sure you have your project open.

2. Select Triggers from the left-hand menu.

3. Click Get Started and wait for Atlas to set up the triggers page.

4. Click Add Trigger to start configuring a new trigger. Enter the name NewComment.

5. You should see the Workshop-Bakery deployment already linked under Link Data Source(s), above the dropdown. If not, click on the dropdown, select it, and click Link..

6. Expand the Trigger Source Details and fill in the following details:

• Watch against: Collection
• Cluster name: Workshop Bakery
• Database name: Bakery
• Collection name: comments
• Operation type: Insert Document
• Full document: Enabled

Expand the Function section and replace the default implementation with the following code:

exports = async function (changeEvent) { const commentDocument = changeEvent.fullDocument; const sentiment = await analyzeCommentSentiment(commentDocument.text); const commentsCollection = context.services.get("Workshop-Bakery").db("Bakery").collection("comments"); await commentsCollection.updateOne( { _id: commentDocument._id }, { $set: { sentiment } } ); }; async function analyzeCommentSentiment(comment) { const URL = "https://language.googleapis.com/v1/documents:analyzeSentiment"; const apiKey = "REPLACE WITH YOUR GOOGLE CLOUD API KEY"; const response = await context.http.post({ url: `${URL}?key=${apiKey}`, body: { "document": { "type": "PLAIN_TEXT", "language": "en-US", "content": comment } }, encodeBodyAsJSON: true }); // The response body is a BSON.Binary object. Parse it and return. return JSON.parse(response.body.text()); }; Note: Don't forget to replace the value of the API KEY variable with your own Google Cloud API key!

Finally, click Save.

Testing the Natural Language API integration

Finally, let's see what happens when you insert a new comment into your database.

1. Navigate back to Database Deployments by clicking on Database in the left-hand menu.

2. Click Browse Collections on the Workshop-Bakery deployment.

3. Open the comments collection from the list of collections on the left.

4. Click Insert document, open the JSON editor, and add the following document:

{ "_id": { "$oid": "65e9c73ab19359e80f9231a9" }, "cakeId": { "$oid": "64759d513beb40594cb859e9" }, "name": "John Smith", "text": "Amazing recipe! I would definitely try it again!", "date": { "$date": { "$numberLong": "1685750400000" } } }

5. The inserted document went through the Trigger that you set up and is now enriched with sentiment. Expand the sentiment field to see the analysis.

Use Natural Language API's analyze sentiment on new comments

Task 3: Deploy a MEAN stack application to Google Cloud Run

Your final task is to deploy a web application that enables you to browse through the cake recipes, read them, and leave comments. The application has already been built for you, and your job is to configure it to connect to your Atlas database and deploy it to Google Cloud Run.

The app was built using the MEAN stack — MongoDB, Express, Angular, and Node. You will deploy two services to Cloud Run:

• A backend service built with Express and Node, connecting to your MongoDB Atlas database, and;
• A frontend service built with Angular, connecting to the backend service.

Copy the connection string of your deployment

Before deploying the services, let's copy the connection string for your Atlas deployment that will allow you to connect the backend service to your database.

1. Head back to your Atlas project and open the Database Deployments page. Click Connect next to the Workshop-Bakery deployment.

2. Then, click on Drivers and copy the connection string.

Enable the Cloud Run and Cloud Build APIs

From Cloud Shell, enable the Cloud Run and Cloud Build APIs

gcloud services enable run.googleapis.com gcloud services enable cloudbuild.googleapis.com

If prompted, authorize Cloud Shell to make API calls.

gcloud services list

Fetch the source code

To deploy your web application, you need its source code. Use git to fetch the public Github repository.

Run the following command in Cloud Shell:

git clone https://github.com/mongodb-developer/bakery-workshop.git bakery

Deploy the backend service

You'll deploy both services through the Cloud Code extension in Cloud Shell editor.

1. In Cloud Shell, click Open Editor. If prompted, click Open in a new window. You should see your cloned project on the left. If you don't see it, expand the Explorer (the document icon on the side bar), click Open Folder and select the bakery folder from the dropdown.
2. Select the Cloud Code extension from the left sidebar.

3. Expand the Cloud Run section and click Select a Project the one corresponding to your lab project ID.
4. Click the Deploy to Cloud Run icon.

5. Enter the following configuration to deploy the backend application:

6. Service Settings: Create a service

7. Service name: bakery-backend

8. Deployment platform: Cloud Run (fully managed)

9. Region:

10. Authentication: Allow unauthenticated invocations

11. Build environment: Local

12. Builder: Docker

13. Docker: server/Dockerfile — notice that there are two Docker files available. Make sure you select the one in the server directory!

14. Next, you need to specify the Atlas connection string for your deployment that you copied earlier. Under the Revision Settings section, click Show Advanced Settings. Open the Environment Variables tab and add the connection string of your Atlas deployment.

ATLAS_URI:mongodb+srv://username:password@workshop-bakery.id.mongodb.net/?retryWrites=true&w=majority&appName=Workshop-Bakery

Click the Deploy button. Deploying the service can take a few minutes. Expand the process output by clicking on the Show Detailed Logs button.

When the deployment is complete, you will see the URL for your backend API. Copy it as you will need it to deploy the frontend service.

Deploy the frontend service

Next, you will deploy the Angular application. The client should be able to connect to the backend API using the URL of the service that you have just deployed.

1. Open the bakery/client/src/environments/environment.prod.ts file and add the URL that copied as a value of apiURL.

export const environment = { production: true, apiUrl: 'Your backend service URL' };

2. Now you're ready to deploy the frontend service to Cloud Run. Open the Cloud Code extension again and click the Deploy to Cloud Run icon.

3. Enter the following configuration:

4. Service Settings: Create a service

5. Service name: bakery-frontend

6. Deployment platform: Cloud Run (fully managed)

7. Region:

8. Authentication: Allow unauthenticated invocations

9. Build environment: Local

10. Builder: Docker

11. Docker: client/Dockerfile — notice that there are two Docker files available. Make sure you select the one in the client directory!

12. Click the Deploy button and wait as your app is being deployed to the cloud.

13. When the deployment is complete, you will see the URL for your application. Click on it to see the bakery application displaying the list of the cakes from your Atlas database.

14. Open one of the two cake recipes and leave a comment. You will see that its sentiment, analyzed by the Natural Language API, is visible right next to the comment!

Deploy Bakery web app using Cloud Run

Congratulations!

You have provisioned your first MongoDB Atlas deployment, created a database and collections with data. You also learned how to access your data through a backend API and deploy services to Cloud Run.

Next Steps / Learn More

Be sure to check out MongoDB on the Google Cloud Marketplace!

Get free $500 credits for MongoDB on Google Cloud Marketplace - Applicable only for new customer.