Connection
Description
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
connection_name | string | Takes the form of project:region:instance | true | false |
database | string | true | false | |
username | string | false | false | |
password | string | May be omitted when authenticating to Postgres using the service account key. | false | false |
credentials | string | true | false | |
change_detection | boolean | false | false | |
publication | string | false | false |
Example
Model Sync
Source
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
query | string | false | false | |
table | string | false | false | |
view | string | false | false |
Example
Target
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
preserve_table_on_resync | boolean | Preserve destination table when resyncing | false | false |
Example
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
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 |