Configuring your connectionsConnection configurationsAzure SQLConnection Description Configuration NAMETYPEDESCRIPTIONREQUIREDREADONLYhostnamestringtruefalseusernamestringtruefalsepasswordstringtruefalsedatabasestringtruefalseportintegertruefalsesslbooleanfalsefalse Example 1{2 "name": "azuresql connection",3 "type": "azuresql",4 "configuration": {5 "database": "sampledb",6 "hostname": "example.database.windows.net",7 "password": "secret",8 "port": 1433,9 "ssl": false,10 "username": "user"11 }12} 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}