Google Cloud MySQL — Polytomic Docs

Connection

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

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

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
write_record_timestamps	boolean	Write row timestamp metadata	false	false
created_column	string	’Created at’ timestamp column	false	false
updated_column	string	’Updated at’ timestamp column	false	false

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 TYPE	GOOGLE CLOUD MYSQL TYPE
`array<>`	`JSON`
`bigint`	`BIGINT`
`boolean`	`BOOLEAN`
`date`	`DATE`
`datetime`	`DATETIME`
`decimal(precision, scale)`	`DECIMAL(precision,scale)`
`double`	`DOUBLE`
`int`	`INT`
`json`	`JSON`
`jsonarray`	`JSON`
`number`	`DECIMAL(65,30)`
`object{}`	`JSON`
`single`	`FLOAT`
`smallint`	`SMALLINT`
`string`	`LONGTEXT`
`time`	`TIME`

Source types

GOOGLE CLOUD MYSQL TYPE	POLYTOMIC TYPE
`BIGINT`	`bigint`
`BIT`	`number`
`BLOB`	`string`
`CHAR`	`string`
`DATE`	`date`
`DATETIME`	`datetime`
`DECIMAL(precision, scale)`	`decimal(precision, scale)`
`DOUBLE`	`double`
`ENUM`	`string`
`FLOAT`	`single`
`INT`	`int`
`MEDIUMINT`	`int`
`MEDIUMTEXT`	`string`
`NUMERIC(precision, scale)`	`decimal(precision, scale)`
`SMALLINT`	`smallint`
`TEXT`	`string`
`TIME`	`time`
`TIMESTAMP`	`datetime`
`TINYINT`	`smallint`
`TINYTEXT`	`string`
`UNSIGNED BIGINT`	`bigint`
`UNSIGNED INT`	`int`
`UNSIGNED SMALLINT`	`smallint`
`UNSIGNED TINYINT`	`smallint`
`VARCHAR`	`string`
`YEAR`	`int`

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	}

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

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	}