PostgreSQL API Configuration

Request

POST https://api.fivetran.com/v1/destinations

{
  "group_id": "group_id",
  "service": "postgres_warehouse",
  "region": "GCP_US_WEST1",
  "time_zone_offset": "+3",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "daylight_saving_time_enabled": true,
  "hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
  "private_link_id": "private_link_id",
  "networking_method": "Directly",
  "proxy_agent_id": "proxy_agent_id",
  "config": {
    "tunnel_port": 564,
    "database": "production",
    "password": "fresh_air_267@83",
    "connection_type": "Directly | PrivateLink | SshTunnel | ProxyAgent",
    "port": 443,
    "host": "87a8z-3da23-3da8d-cloud.sql.com",
    "tunnel_host": "ssh.server.com",
    "always_encrypted": true,
    "user": "admin",
    "tunnel_user": "Fivetran"
  }
}

Config parameters

Name	Description
`tunnel_port`	SSH server port name. Must be populated if `connection_type` is set to `SshTunnel`.
`database`	Database name
`password`	Database user password
`connection_type`	Connection method. Default value: `Directly`.
`port`	Server port number
`host`	Server name
`tunnel_host`	SSH server name. Must be populated if `connection_type` is set to `SshTunnel`.
`always_encrypted`	Specifies whether TLS is required. Must be populated if `connection_type` is set to `SshTunnel`.
`user`	Database user name
`tunnel_user`	SSH user name. Must be populated if `connection_type` is set to `SshTunnel`.