Configuring your connectionsConnection configurations

Google Cloud PostgreSQL

Connection

Description

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
connection_namestringTakes the form of project:region:instancetruefalse
databasestringtruefalse
usernamestringfalsefalse
passwordstringMay be omitted when authenticating to Postgres using the service account key.falsefalse
credentialsstringtruefalse
change_detectionbooleanfalsefalse
publicationstringfalsefalse

Example

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}

Model Sync

Source

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
querystringfalsefalse
tablestringfalsefalse
viewstringfalsefalse

Example

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

Target

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
preserve_table_on_resyncbooleanPreserve destination table when resyncingfalsefalse

Example

1{
2 ...
3 "target": {
4 "configuration": {
5 "preserve_table_on_resync": false
6 }
7 }
8}

Bulk Sync

Source

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
replication_slotstringLeave blank to allow Polytomic to manage a replication slot for this sync.falsefalse

Example

1{
2 ...
3 "source_configuration": {
4 "replication_slot": "polytomic"
5 }
6}

Destination

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
advancedobjectfalsefalse
schemastringOutput schema to write tofalsefalse
mirror_schemasbooleanIndicates whether schemas should be mirroredfalsefalse

Example

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