Google Cloud PostgreSQL

1
{
2
  "name": "googlecloudsql connection",
3
  "type": "googlecloudsql",
4
  "configuration": {
5
    "change_detection": false,
6
    "connection_name": "project:region:instance",
7
    "credentials": "",
8
    "database": "sampledb",
9
    "password": "secret",
10
    "publication": "polytomic",
11
    "username": "cloudsql"
12
  }
13
}

1
{
2
  ...
3
  "configuration": {
4
    "query": "SELECT * from users",
5
    "table": "users",
6
    "view": "active_users"
7
  }
8
}

1
{
2
  ...
3
  "target": {
4
      "configuration": {
5
        "created_column": "",
6
        "preserve_table_on_resync": false,
7
        "updated_column": "",
8
        "write_record_timestamps": false
9
    }
10
  }
11
}

1
{
2
  ...
3
  "source_configuration": {
4
    "mirror_tables_without_unique_id": false,
5
    "replication_slot": "polytomic"
6
  }
7
}

1
{
2
  ...
3
  "destination_configuration": {
4
    "advanced": {
5
        "table_prefix": "",
6
        "truncate_existing": false
7
    },
8
    "mirror_schemas": false,
9
    "schema": "public"
10
  }
11
}