This lab walks you through GCP Cloud Function, Storage Bucket, and Cloud SQL
Make sure, you have completed the previous labs about GCP Cloud Function, Storage Bucket, and Cloud SQL because here we will not go into detail about theory but we will connect these three services. If you have not completed the previous lab, we recommend you complete the previous lab first.
In this lab, we will create a bucket and upload a sample CSV file into the bucket ( We will provide the file)
We will then create a Cloud SQL instance and database where the table will be created and records will be inserted using Cloud Function.
We will then create a Cloud Function which will connect with Cloud SQL and Storage Bucket.
Duration: 60 minutes
In this lab, we will create a Google Cloud Storage Bucket where we will upload a Sample CSV containing user details, using Cloud Function we will first read the GCS Object first and then using the same Function we will connect with Cloud SQL and create a table and insert the data into Database.
Login into GCP Console.
Creating a Cloud Storage Bucket.
Creating a Cloud SQL Instance.
Create a SQL Database.
Creating a Cloud Function, deploy, and test.
Using Cloud Shell, connect to DB Instance to check whether records are inserted successfully or not.