Connecting to a Cloud SQL Database with the Cloud SQL Auth Proxy

Lab Steps

lock
Signing In to the Google Cloud Console
lock
Creating a PostgreSQL Database using Cloud SQL
lock
Understanding the Cloud SQL Auth Proxy and Custom Service Accounts
lock
Connecting to a Cloud SQL Instance using the Cloud SQL Auth Proxy

Ready for the real environment experience?

DifficultyIntermediate
Time Limit1h 15m
Students38
Ratings
5/5
starstarstarstarstar

Description

The way developers establish database connections is an important aspect of managing a Cloud SQL database. Solid connection management practices help to minimize downtime and security risks. Developers must consider how a connection is established, which connections are authorized, and how users or other services are authenticated. This lab will cover how to establish secure connections with the Cloud SQL Auth proxy.

The Cloud SQL Auth proxy uses Identity and Access Management (IAM) permissions to authorize and secure connections to Cloud SQL database instances. Like most proxy tools, it serves as the intermediary authority on connection authorizations.

In this lab, you will create a Cloud SQL database instance and learn how to securely connect to the instance using the Cloud SQL Auth Proxy and a custom IAM Service Account.

Learning Objectives

Upon completion of this intermediate-level lab, you will be able to:

  • Create a Cloud SQL Database instance that serves a PostgreSQL database
  • Connect to a Cloud SQL Database instance using the Cloud SQL Auth proxy

Intended Audience

  • Candidates for the Google Associate Cloud Engineer exam
  • Candidates for the Google Data Engineer exam
  • Google Cloud practitioners

Prerequisites

Familiarity with the following will be beneficial but is not required:

  • General knowledge of the Google Cloud SQL service
Environment before
PREVIEW
arrow_forward
Environment after
PREVIEW
About the Author
Students18675
Labs59
Learning paths3

Jun is a Cloud Labs Developer with previous experience as a Software Engineer and Cloud Developer. He holds the AWS Certified Solutions Architect and DevOps Engineer Professional certifications. He also holds the AWS Certified Solutions Architect, Developer, and SysOps Administrator Associate certifications. 

Jun is focused on giving back to the growing cloud community by sharing his knowledge and experience with students and creating engaging content.