---
title: "Get connections by owner"
method: GET
path: "/connections/{owner}"
tags: ["connections"]
---

# Get connections by owner

`GET /connections/{owner}`

Get a list of configured virtual connections by owner. For increased security, connection
endpoints require an Enterprise Admin Token. This token can be found under
[Advanced Settings](https://data.world/settings/advanced).

## Path parameters

- `owner` string, required

## Query parameters

- `sort` string[]
- `size` integer
- `from` integer

## Response `200`

default response

- PaginatedConnectionResults
  - `count` integer, required
  - `nextPageToken` string
  - `records` ConnectionDto[], required
    - `advancedProperties` object — Advanced properties
    - `credentials` DatabaseCredentials
      - `password` string — password
      - `user` string, required — user name
    - `database` string — Database/Schema Logical Name
    - `host` string — Database Host
    - `name` string — Connection name
    - `port` integer — Database Port
    - `properties` object — Properties such as auto commit, isolation level etc.
    - `sshTunnel` SshTunnel
      - `host` string, required — ssh tunnel host
      - `port` integer — Tunnel Port
      - `user` string, required — user name
      - `userKeyPair` boolean, required — whether authentication is required
    - `sslRequired` boolean — Is ssl required
    - `trustedServerCertificates` string — trusted server certificates
    - `type` 'ATHENA' | 'AZURESYNAPSE' | 'BIGQUERY' | 'DB2' | 'DENODO' | 'HIVE' | 'DATABRICKS' | 'INFOR_ION' | 'MYSQL' | 'ORACLE' | 'POSTGRESQL' | 'REDSHIFT' | 'SERVICENOW' | 'SNOWFLAKE' | 'SPARK' | 'SQLSERVER' | 'TABLEAU' — Database Type
    - `usePrivateKey` boolean — Should this connection use a private key?
    - `verifyServerCertificate` boolean — Should server certificate be verified

---

[API](https://skmtc.dev/data/apis/data-world-public-api.md) · [All operations](https://skmtc.dev/data/apis/data-world-public-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/data/data-world-public-api/revisions/0a0cb1f94dad/schema)