PostgreSQL

1
{
2
  "name": "postgresql connection",
3
  "type": "postgresql",
4
  "configuration": {
5
    "ca_cert": "",
6
    "change_detection": false,
7
    "client_certificate": "",
8
    "client_certs": false,
9
    "client_key": "",
10
    "database": "sampledb",
11
    "hostname": "database.example.com",
12
    "password": "password",
13
    "port": 5432,
14
    "publication": "polytomic",
15
    "ssh": false,
16
    "ssh_host": "bastion.example.com",
17
    "ssh_port": 22,
18
    "ssh_private_key": "",
19
    "ssh_user": "",
20
    "ssl": false,
21
    "username": "postgres"
22
  }
23
}

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
}