Azure SQL — Polytomic Docs

Connection

Configuration

NAME	TYPE	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

Example

1 {
2   "name": "azuresql connection",
3   "type": "azuresql",
4   "configuration": {
5     "database": "sampledb",
6     "hostname": "example.database.windows.net",
7     "password": "secret",
8     "port": 1433,
9     "ssl": false,
10     "username": "user"
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 }

Bulk Sync

Destination

Configuration

NAME	TYPE	DESCRIPTION	REQUIRED	READONLY
advanced	object		false	false
mirror_schemas	boolean	Indicates whether schemas should be mirrored	false	false
schema	string	Output schema to write to	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 }

Type handling

Destination types

POLYTOMIC TYPE	AZURE SQL TYPE
`array<>`	`NVARCHAR(MAX)`
`bigint`	`BIGINT`
`boolean`	`BIT`
`date`	`DATE`
`datetime`	`DATETIME`
`decimal(precision, scale)`	`DECIMAL(precision,scale)`
`double`	`FLOAT`
`int`	`INT`
`json`	`NVARCHAR(MAX)`
`jsonarray`	`NVARCHAR(MAX)`
`number`	`NUMERIC(38,10)`
`object{}`	`NVARCHAR(MAX)`
`single`	`REAL`
`smallint`	`SMALLINT`
`string`	`NVARCHAR(4000)`
`time`	`TIME`

Source types

AZURE SQL TYPE	POLYTOMIC TYPE
`BIGINT`	`bigint`
`CHAR`	`string`
`DATE`	`date`
`DATETIME`	`datetime`
`DATETIME2`	`datetime`
`DATETIMEOFFSET`	`datetime`
`DECIMAL`	`number`
`DECIMAL(precision, scale)`	`decimal(precision, scale)`
`FLOAT`	`double`
`INT`	`int`
`MONEY`	`decimal(precision, scale)`
`NCHAR`	`string`
`NTEXT`	`string`
`NUMBER(precision, scale)`	`decimal(precision, scale)`
`NUMERIC`	`number`
`NUMERIC(precision, scale)`	`decimal(precision, scale)`
`NVARCHAR`	`string`
`REAL`	`single`
`SMALLDATETIME`	`datetime`
`SMALLINT`	`smallint`
`SMALLMONEY`	`decimal(precision, scale)`
`TEXT`	`string`
`TIME`	`time`
`TINYINT`	`smallint`
`UNIQUEIDENTIFIER`	`string`
`VARCHAR`	`string`
`XML`	`string`

1	{
2	"name": "azuresql connection",
3	"type": "azuresql",
4	"configuration": {
5	"database": "sampledb",
6	"hostname": "example.database.windows.net",
7	"password": "secret",
8	"port": 1433,
9	"ssl": false,
10	"username": "user"
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	}

1	{
2	...
3	"destination_configuration": {
4	"advanced": {
5	"table_prefix": "",
6	"truncate_existing": false
7	},
8	"mirror_schemas": false,
9	"schema": "public"
10	}
11	}