DAdata
connections

Get an individual connection

Get details for an individual virtual connection. For increased security, connection endpoints require an Enterprise Admin Token. This token can be found under Advanced Settings.

get/connections/{owner}/{id}

Request

  • Base URL
    https://api.data.world/v0
  • URL
    https://api.data.world/v0/connections/{owner}/{id}
  • Auth
    HTTP bearer

Path parameters

ownerstring required
idstring uuid required

Response

default response

advancedPropertiesobject

Advanced properties

databasestring

Database/Schema Logical Name

hoststring

Database Host

namestring

Connection name

portinteger

Database Port

propertiesobject

Properties such as auto commit, isolation level etc.

sslRequiredboolean

Is ssl required

trustedServerCertificatesstring

trusted server certificates

type'ATHENA' | 'AZURESYNAPSE' | 'BIGQUERY' | 'DB2' | 'DENODO' | 'HIVE' | 'DATABRICKS' | 'INFOR_ION' | 'MYSQL' | 'ORACLE' | 'POSTGRESQL' | 'REDSHIFT' | 'SERVICENOW' | 'SNOWFLAKE' | 'SPARK' | 'SQLSERVER' | 'TABLEAU'

Database Type

usePrivateKeyboolean

Should this connection use a private key?

verifyServerCertificateboolean

Should server certificate be verified

Example response

{
  "credentials": {
    "password": "!AdHJfGgd@3#",
    "user": "johnsmith"
  },
  "database": "schemadw",
  "host": "dwserver.thinktank.com",
  "name": "Humanitarian_Aid",
  "port": 5432,
  "sshTunnel": {
    "host": "passthru.tunnel.ca",
    "port": 3454,
    "user": "johnsmith",
    "userKeyPair": true
  },
  "sslRequired": true,
  "type": "ATHENA",
  "verifyServerCertificate": true
}

Changes

No recorded changes to this operation across all 2 revisions of this API.