1. Create the .env file & Add Configuration Variables to the .env file

# Google Cloud SQL Connection Details
# Enter your actual database connection information here.

INSTANCE_CONNECTION_NAME="<YOUR_PROJECT_ID>:<YOUR_REGION>:<YOUR_INSTANCE_CONNECTION_NAME>"
DB_USER="<YOUR_DB_USER_ID>"
DB_PASS="<YOUR_DB_USER_PASSWORD>"
DB_NAME="<YOUR_DB_NAME>"
TABLE_NAME="<YOUR_TABLE_NAME>"

2. Set default credentials (Application Default Credentials, ADC) for accessing Google Cloud

• Login gcloud auth

  gcloud auth application-default login
  

• load_credentials_from_file

  • Set the environment variable inside the .env file. Add the following line and replace the placeholder with the absolute path to your Google Cloud service account JSON key.
  • Cloud SQL Permission

  # .env
  GOOGLE_APPLICATION_CREDENTIALS="/path/to/your/service-account-key.json"

3. Set environment

conda create -n google_cloud_sql_env python=3.9
conda activate google_cloud_sql_env 
pip install "cloud-sql-python-connector[pg8000]"  # For PostgreSQL
pip install "cloud-sql-python-connector[pymysql]" # For MySQL
pip install sqlalchemy
pip install python-dotenv
pip install psycopg2-binary

4. Run test code

python test_google_cloud_sql.py

---

Author

- LinkedIn

- Blog URL

- Email: qbxlvnf11@google.com, qbxlvnf11@naver.com