Configuring your connectionsConnection configurationsAzure SynapseConnection Description Configuration NAMETYPEDESCRIPTIONREQUIREDREADONLYhostnamestringtruefalseusernamestringtruefalsepasswordstringtruefalsedatabasestringtruefalseportintegertruefalse Example 1{2 "name": "synapse connection",3 "type": "synapse",4 "configuration": {5 "database": "yourdatabase",6 "hostname": "yourserver.sql.azuresynapse.net",7 "password": "secret",8 "port": 1433,9 "username": "user"10 }11} Model Sync Source Configuration NAMETYPEDESCRIPTIONREQUIREDREADONLYquerystringfalsefalsetablestringTablefalsefalseviewstringViewfalsefalse Example 1{2 ...3 "configuration": {4 "query": "SELECT * from users",5 "table": "users",6 "view": "active_users"7 }8} Target Configuration NAMETYPEDESCRIPTIONREQUIREDREADONLYpreserve_table_on_resyncbooleanPreserve destination table when resyncingfalsefalse Example 1{2 ...3 "target": {4 "configuration": {5 "preserve_table_on_resync": false6 }7 }8} Bulk Sync Destination Configuration NAMETYPEDESCRIPTIONREQUIREDREADONLYadvancedobjectfalsefalseschemastringOutput schema to write tofalsefalsemirror_schemasbooleanIndicates whether schemas should be mirroredfalsefalse Example 1{2 ...3 "destination_configuration": {4 "advanced": {5 "table_prefix": "",6 "truncate_existing": false7 },8 "mirror_schemas": false,9 "schema": "public"10 }11}