Google Cloud PostgreSQL API Configuration
Request
POST https://api.fivetran.com/v1/destinations
{
"group_id": "group_id",
"service": "postgres_gcp_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 . |