Deploy Cloud Run instance connected to Cloud SQL

This example lives in the pulumi/examples repository. Check out just this directory to use it:

$ git clone --filter=blob:none --sparse https://github.com/pulumi/examples pulumi-examples
$ git -C pulumi-examples sparse-checkout set gcp-py-cloudrun-cloudsql
$ cd pulumi-examples/gcp-py-cloudrun-cloudsql

Example of starting a Cloud Run deployment with a Cloud SQL instance.

Prerequisites#

1. Install Pulumi
2. Configure GCP credentials
3. Install Python

Deploying the example#

1. Create a new stack:

   pulumi stack init dev

2. Configure the project:

   pulumi config set gcp:project YOURGOOGLECLOUDPROJECT
   pulumi config set gcp:region europe-west1
   pulumi config set db-name project-db
   pulumi config set --secret db-password SuuperSecret12345!

3. Install dependencies:

   python3 -m venv venv
   source venv/bin/activate
   pip install -r requirements.txt

4. Preview and deploy changes:

   pulumi up

5. Curl the Cloud Run service:

   curl -H "Authorization: Bearer $(gcloud auth print-identity-token)" $(pulumi stack output cloud_run_url)

6. Access the database:

   gcloud sql connect $(pulumi stack output cloud_sql_instance_name) -u $(pulumi config get db-name) --project $(pulumi config get gcp:project)

Cleaning up#

Once you’re finished experimenting, destroy your stack and remove it:

pulumi destroy
pulumi stack rm