curl --request GET \
  --url https://app.prophecy.io/api/orchestration/fabric/{fabricId}/connection/name/{connectionName} \
  --header 'X-AUTH-TOKEN: <x-auth-token>'

{
  "success": true,
  "data": {
    "id": "<connection-id>",
    "name": "synapse_1",
    "kind": "synapse",
    "isDefaultWarehouseConnection": false,
    "properties": {
      "database": "SynapseDev",
      "password": {
        "kind": "prophecy",
        "properties": {
          "id": "2719",
          "name": "secret-synapse"
        },
        "subKind": "text",
        "type": "secret"
      },
      "port": "1433",
      "server": "<server-name>.sql.azuresynapse.net",
      "username": "<username>"
    }
  }
}