Google Cloud SQL

Load event data into Google Cloud SQL for fully managed relational database storage on Google Cloud.

Configuration

FieldTypeRequiredDescription
connection_namestringYesThe instance connection name, e.g. project:region:instance.
databasestringYesThe target database name.
table_namestringYesThe target table name to insert rows into.
usernamestringYesThe database username for authentication.
passwordsecretYesThe database password for authentication.

Quick Setup

  1. Navigate to Integrations in the sidebar.
  2. Open the Integration Library tab.
  3. Find Google Cloud SQL or filter by Cloud Storage.
  4. Click Install, select a variant if available, and fill in the required fields.
  5. Click Install Integration to create the integration with a ready-to-use default configuration.

API Setup

curl -X POST http://localhost:8084/v1/admin/integration-catalog/google_cloud_sql/install \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Google Cloud SQL",
    "variant": "default",
    "config": {
      "connection_name": "my-project:us-central1:my-instance",
      "database": "analytics",
      "table_name": "events",
      "username": "datafly"
    },
    "delivery_mode": "server_side"
  }'

Delivery

Events are delivered server-side from your Datafly Signal infrastructure directly to Google Cloud SQL. No client-side scripts are loaded for this integration.

Visit Google Cloud SQL documentation for full API documentation and credential setup instructions.