Azure SQL | Polytomic Docs

Supports:

✅ Models
✅ Model sync destination
✅ Bulk sync source
✅ Bulk sync destination

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
ssh	boolean	false	false
ssh_user	string	false	false
ssh_host	string	false	false
ssh_port	integer	false	false
ssh_private_key	string	false	false
blobStore	boolean	false	false
access_key	string	false	false
account_name	string	false	false
container_name	string	false	false

Example

1 {
2   "name": "Azure SQL connection",
3   "type": "azuresql",
4   "configuration": {
5     "access_key": "abcdefghijklmnopqrstuvwxyz0123456789/+ABCDEabcdefghijklmnopqrstuvwxyz0123456789/+ABCDE==",
6     "account_name": "account",
7     "blobStore": false,
8     "container_name": "container",
9     "database": "sampledb",
10     "hostname": "example.database.windows.net",
11     "password": "secret",
12     "port": 1433,
13     "ssh": false,
14     "ssh_host": "bastion.example.com",
15     "ssh_port": 22,
16     "ssh_private_key": "",
17     "ssh_user": "",
18     "ssl": false,
19     "username": "user"
20   }
21 }

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

Azure SQL connections may be used as the destination in a model sync.

All targets

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	Mirror schemas	false	false
schema	string	Output schema	false	false

Example

1 {
2   ...
3   "destination_configuration": {
4     "advanced": {
5         "empty_strings_null": false,
6         "hard_deletes": false,
7         "initial_execution": "",
8         "table_prefix": "",
9         "truncate_existing": false
10     },
11     "mirror_schemas": false,
12     "schema": "schema"
13   }
14 }

Type handling

Destination types

POLYTOMIC TYPE	AZURE SQL TYPE
`array<>`	`NVARCHAR(MAX)`
`bigint`	`BIGINT`
`boolean`	`BIT`
`date`	`DATE`
`datetime`	`DATETIMEOFFSET`
`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`