Import data from Storage Bucket to Cloud SQL using Cloud Function

Lab Details:

This lab will walk you through GCP Cloud Function Storage Bucket and Cloud SQL

You should have completed the previous labs on GCP Cloud Function Storage Bucket and Cloud SQL. We won't go into detail about theory, but we will connect these services. If you haven't completed the previous lab, we recommend that you do so.

This lab will allow us to create a bucket and then upload a CSV file (we will provide the file).

The next step is to create a Cloud SQL instance, a database, and a table. Records will then be inserted using Cloud Function.

Then, we will create a Cloud Function that will connect to Cloud SQL and Storage Bucket.

Duration: 60 minutes

Lab Overview:

This lab will allow us to create a Google Cloud Storage Bucket. We will upload a Sample CSV containing user information. Using Cloud Function, we will first read the GCS Object. Then, using the same Function, we will connect with Cloud SQL to create a table, and insert the data into Database.