Connection

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
write_record_timestampsbooleanWrite row timestamp metadatafalsefalse
created_columnstring’Created at’ timestamp columnfalsefalse
updated_columnstring’Updated at’ timestamp columnfalsefalse

Example

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}

Type handling

Destination types

POLYTOMIC TYPEGOOGLE CLOUD MYSQL TYPE
array<>JSON
bigintBIGINT
booleanBOOLEAN
dateDATE
datetimeDATETIME
decimal(precision, scale)DECIMAL(precision,scale)
doubleDOUBLE
intINT
jsonJSON
jsonarrayJSON
numberDECIMAL(65,30)
object{}JSON
singleFLOAT
smallintSMALLINT
stringLONGTEXT
timeTIME

Source types

GOOGLE CLOUD MYSQL TYPEPOLYTOMIC TYPE
BIGINTbigint
BITnumber
BLOBstring
CHARstring
DATEdate
DATETIMEdatetime
DECIMAL(precision, scale)decimal(precision, scale)
DOUBLEdouble
ENUMstring
FLOATsingle
INTint
MEDIUMINTint
MEDIUMTEXTstring
NUMERIC(precision, scale)decimal(precision, scale)
SMALLINTsmallint
TEXTstring
TIMEtime
TIMESTAMPdatetime
TINYINTsmallint
TINYTEXTstring
UNSIGNED BIGINTbigint
UNSIGNED INTint
UNSIGNED SMALLINTsmallint
UNSIGNED TINYINTsmallint
VARCHARstring
YEARint