Configuring your connectionsConnection configurations
PostgreSQL
Connection
Description
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
hostname | string | true | false | |
username | string | true | false | |
password | string | true | false | |
database | string | true | false | |
port | integer | true | false | |
ssl | boolean | false | false | |
ssh | boolean | false | false | |
ssh_user | string | false | false | |
ssh_host | string | false | false | |
ssh_port | integer | false | false | |
ssh_private_key | string | false | false | |
client_certs | boolean | false | false | |
client_certificate | string | false | false | |
client_key | string | false | false | |
ca_cert | string | false | false | |
change_detection | boolean | false | false | |
publication | string | false | false |
Example
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": "", 17 "ssh_port": 22, 18 "ssh_private_key": "", 19 "ssh_user": "", 20 "ssl": false, 21 "username": "postgres" 22 } 23 }
Model Sync
Source
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
query | string | false | false | |
table | string | Table | false | false |
view | string | View | false | false |
Example
1 { 2 ... 3 "configuration": { 4 "query": "SELECT * from users", 5 "table": "users", 6 "view": "active_users" 7 } 8 }
Target
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
preserve_table_on_resync | boolean | Preserve destination table when resyncing | false | false |
Example
1 { 2 ... 3 "target": { 4 "configuration": { 5 "preserve_table_on_resync": false 6 } 7 } 8 }
Bulk Sync
Source
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
replication_slot | string | Leave blank to allow Polytomic to manage a replication slot for this sync. | false | false |
Example
1 { 2 ... 3 "source_configuration": { 4 "replication_slot": "polytomic" 5 } 6 }
Destination
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
advanced | object | false | false | |
schema | string | Output schema to write to | false | false |
mirror_schemas | boolean | Indicates whether schemas should be mirrored | false | false |
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 }