Configuring your connectionsConnection configurations

Snowflake

Connection

Description

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
accountstringe.g. uc193736182, ja8382948.us-central-1.gcptruefalse
usernamestringtruefalse
passwordstringfalsefalse
dbnamestringtruefalse
warehousestringfalsefalse
paramsstringAdditional connection parameters, formatted as a query stringfalsefalse
key_pair_authbooleanfalsefalse
private_keystringfalsefalse
private_key_passphrasestringfalsefalse

Example

1{
2 "name": "snowflake connection",
3 "type": "snowflake",
4 "configuration": {
5 "account": "uc193736182",
6 "dbname": "database_name",
7 "key_pair_auth": false,
8 "params": "",
9 "password": "password",
10 "private_key": "",
11 "private_key_passphrase": "",
12 "username": "user",
13 "warehouse": "warehouse"
14 }
15}

Model Sync

Source

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
querystringfalsefalse
schemastringSchemafalsefalse
tablestringTablefalsefalse
viewstringViewfalsefalse

Example

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

Target

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
preserve_table_on_resyncbooleanPreserve destination table when resyncingfalsefalse
write_null_valuesbooleanCopy null valuesfalsefalse

Example

1{
2 ...
3 "target": {
4 "configuration": {
5 "preserve_table_on_resync": false,
6 "write_null_values": false
7 }
8 }
9}

Bulk Sync

Source

N/A

Destination

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
advancedobjectfalsefalse
schemastringOutput schemafalsefalse
mirror_schemasbooleanMirror schemasfalsefalse

Example

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