Configuring your connectionsConnection configurations
Snowflake
Connection
Description
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
account | string | e.g. uc193736182, ja8382948.us-central-1.gcp | true | false |
username | string | true | false | |
password | string | false | false | |
dbname | string | true | false | |
warehouse | string | false | false | |
params | string | Additional connection parameters, formatted as a query string | false | false |
key_pair_auth | boolean | false | false | |
private_key | string | false | false | |
private_key_passphrase | string | false | false |
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
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
query | string | false | false | |
schema | string | Schema | false | false |
table | string | Table | false | false |
view | string | View | false | false |
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
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
preserve_table_on_resync | boolean | Preserve destination table when resyncing | false | false |
write_null_values | boolean | Copy null values | false | false |
Example
1 { 2 ... 3 "target": { 4 "configuration": { 5 "preserve_table_on_resync": false, 6 "write_null_values": false 7 } 8 } 9 }
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 "hard_deletes": false, 6 "table_prefix": "", 7 "truncate_existing": false 8 }, 9 "mirror_schemas": false, 10 "schema": "schema" 11 } 12 }