Configuring your connectionsConnection configurations

Google Cloud MySQL

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

Example

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

Model Sync

Source

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
querystringfalsefalse
tablestringTablefalsefalse
viewstringViewfalsefalse

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

N/A

Destination

N/A