Connection

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
auth_methodstringAccepted Values: access_key, client_credentials, oauthtruefalse
access_keystring(required if auth_method is “access_key”)falsefalse
tenant_idstring(required if auth_method is “client_credentials”)falsefalse
client_idstring(required if auth_method is “client_credentials”)falsefalse
client_secretstring(required if auth_method is “client_credentials”)falsefalse
oauth_refresh_tokenstringfalsefalse
container_namestringtruefalse
account_namestringtruefalse
is_single_tablebooleanTreat the files as a single table.falsefalse
single_table_namestring(required if is_single_table is “true”)falsefalse
single_table_file_formatstring(required if is_single_table is “true”). Accepted Values: csv, jsonfalsefalse
skip_linesintegerSkip first N lines of each CSV file.falsefalse

Example

1{
2 "name": "azureblob connection",
3 "type": "azureblob",
4 "configuration": {
5 "access_key": "abcdefghijklmnopqrstuvwxyz0123456789/+ABCDEabcdefghijklmnopqrstuvwxyz0123456789/+ABCDE==",
6 "account_name": "account",
7 "auth_method": "",
8 "client_id": "",
9 "client_secret": "",
10 "container_name": "container",
11 "is_single_table": false,
12 "oauth_refresh_token": "dasfdasz62px8lqeoakuea2ccl4rxm13i6tbyorxhu1i20kc8ruvksmzxq",
13 "single_table_file_format": "csv",
14 "single_table_name": "collection",
15 "skip_lines": 0,
16 "tenant_id": ""
17 }
18}

Model Sync

Source

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
model_fromstringThe model is generated from a single file or a multi-file archive. Accepted Values: single_file, multi_file_archivetruefalse
file_formatstringFile format Accepted Values: csv, jsonfalsefalse
skip_linesintegerSkip first N lines of each CSV file.falsefalse
keystringThe key of the object in the bucket to read from.falsefalse
subfolderstringSubfolder to read files from from (optional)falsefalse

Example

1{
2 ...
3 "configuration": {
4 "file_format": "",
5 "key": "",
6 "model_from": "",
7 "skip_lines": 0,
8 "subfolder": ""
9 }
10}

Target

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
formatstringOutput file encodingfalsefalse

Example

1{
2 ...
3 "target": {
4 "configuration": {
5 "format": "csv"
6 }
7 }
8}

Bulk Sync

Destination

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
formatstringOutput file encodingfalsefalse
subfolderstringSubfolder to write to (optional)falsefalse

Example

1{
2 ...
3 "destination_configuration": {
4 "format": "csv",
5 "subfolder": "reports"
6 }
7}