1. Packages
  2. Airbyte Provider
  3. API Docs
  4. DestinationPostgres
Viewing docs for airbyte 1.0.0
published on Wednesday, Mar 4, 2026 by airbytehq
Schema (JSON)
airbytehq/terraform-provider-airbyte

airbyte.DestinationPostgres

airbyte logo
Viewing docs for airbyte 1.0.0
published on Wednesday, Mar 4, 2026 by airbytehq
Schema (JSON)
airbytehq/terraform-provider-airbyte

    DestinationPostgres Resource

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as airbyte from "@pulumi/airbyte";

const myDestinationPostgres = new airbyte.DestinationPostgres("my_destination_postgres", {
    configuration: {
        additionalProperties: "{ \"see\": \"documentation\" }",
        cdcDeletionMode: "Soft delete",
        database: "...my_database...",
        disableTypeDedupe: true,
        dropCascade: false,
        host: "...my_host...",
        jdbcUrlParams: "...my_jdbc_url_params...",
        password: "...my_password...",
        port: 5432,
        rawDataSchema: "...my_raw_data_schema...",
        schema: "public",
        ssl: true,
        sslMode: {
            verifyCa: {
                additionalProperties: "{ \"see\": \"documentation\" }",
                caCertificate: "...my_ca_certificate...",
                clientKeyPassword: "...my_client_key_password...",
                mode: "verify-ca",
            },
        },
        tunnelMethod: {
            passwordAuthentication: {
                additionalProperties: "{ \"see\": \"documentation\" }",
                tunnelHost: "...my_tunnel_host...",
                tunnelMethod: "SSH_PASSWORD_AUTH",
                tunnelPort: 28502,
                tunnelUser: "...my_tunnel_user...",
                tunnelUserPassword: "...my_tunnel_user_password...",
            },
        },
        unconstrainedNumber: false,
        username: "...my_username...",
    },
    definitionId: "6cc561e7-8b38-4621-919b-0687fe3682b7",
    name: "...my_name...",
    workspaceId: "2b2d880a-23fd-4463-8627-0a837b28bb7e",
});

    import pulumi
import pulumi_airbyte as airbyte

my_destination_postgres = airbyte.DestinationPostgres("my_destination_postgres",
    configuration={
        "additional_properties": "{ \"see\": \"documentation\" }",
        "cdc_deletion_mode": "Soft delete",
        "database": "...my_database...",
        "disable_type_dedupe": True,
        "drop_cascade": False,
        "host": "...my_host...",
        "jdbc_url_params": "...my_jdbc_url_params...",
        "password": "...my_password...",
        "port": 5432,
        "raw_data_schema": "...my_raw_data_schema...",
        "schema": "public",
        "ssl": True,
        "ssl_mode": {
            "verify_ca": {
                "additional_properties": "{ \"see\": \"documentation\" }",
                "ca_certificate": "...my_ca_certificate...",
                "client_key_password": "...my_client_key_password...",
                "mode": "verify-ca",
            },
        },
        "tunnel_method": {
            "password_authentication": {
                "additional_properties": "{ \"see\": \"documentation\" }",
                "tunnel_host": "...my_tunnel_host...",
                "tunnel_method": "SSH_PASSWORD_AUTH",
                "tunnel_port": 28502,
                "tunnel_user": "...my_tunnel_user...",
                "tunnel_user_password": "...my_tunnel_user_password...",
            },
        },
        "unconstrained_number": False,
        "username": "...my_username...",
    },
    definition_id="6cc561e7-8b38-4621-919b-0687fe3682b7",
    name="...my_name...",
    workspace_id="2b2d880a-23fd-4463-8627-0a837b28bb7e")

    package main

import (
	"github.com/pulumi/pulumi-terraform-provider/sdks/go/airbyte/airbyte"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := airbyte.NewDestinationPostgres(ctx, "my_destination_postgres", &airbyte.DestinationPostgresArgs{
			Configuration: &airbyte.DestinationPostgresConfigurationArgs{
				AdditionalProperties: pulumi.String("{ \"see\": \"documentation\" }"),
				CdcDeletionMode:      pulumi.String("Soft delete"),
				Database:             pulumi.String("...my_database..."),
				DisableTypeDedupe:    pulumi.Bool(true),
				DropCascade:          pulumi.Bool(false),
				Host:                 pulumi.String("...my_host..."),
				JdbcUrlParams:        pulumi.String("...my_jdbc_url_params..."),
				Password:             pulumi.String("...my_password..."),
				Port:                 pulumi.Float64(5432),
				RawDataSchema:        pulumi.String("...my_raw_data_schema..."),
				Schema:               pulumi.String("public"),
				Ssl:                  pulumi.Bool(true),
				SslMode: &airbyte.DestinationPostgresConfigurationSslModeArgs{
					VerifyCa: &airbyte.DestinationPostgresConfigurationSslModeVerifyCaArgs{
						AdditionalProperties: pulumi.String("{ \"see\": \"documentation\" }"),
						CaCertificate:        pulumi.String("...my_ca_certificate..."),
						ClientKeyPassword:    pulumi.String("...my_client_key_password..."),
						Mode:                 pulumi.String("verify-ca"),
					},
				},
				TunnelMethod: &airbyte.DestinationPostgresConfigurationTunnelMethodArgs{
					PasswordAuthentication: &airbyte.DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs{
						AdditionalProperties: pulumi.String("{ \"see\": \"documentation\" }"),
						TunnelHost:           pulumi.String("...my_tunnel_host..."),
						TunnelMethod:         pulumi.String("SSH_PASSWORD_AUTH"),
						TunnelPort:           pulumi.Float64(28502),
						TunnelUser:           pulumi.String("...my_tunnel_user..."),
						TunnelUserPassword:   pulumi.String("...my_tunnel_user_password..."),
					},
				},
				UnconstrainedNumber: pulumi.Bool(false),
				Username:            pulumi.String("...my_username..."),
			},
			DefinitionId: pulumi.String("6cc561e7-8b38-4621-919b-0687fe3682b7"),
			Name:         pulumi.String("...my_name..."),
			WorkspaceId:  pulumi.String("2b2d880a-23fd-4463-8627-0a837b28bb7e"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Airbyte = Pulumi.Airbyte;

return await Deployment.RunAsync(() => 
{
    var myDestinationPostgres = new Airbyte.DestinationPostgres("my_destination_postgres", new()
    {
        Configuration = new Airbyte.Inputs.DestinationPostgresConfigurationArgs
        {
            AdditionalProperties = "{ \"see\": \"documentation\" }",
            CdcDeletionMode = "Soft delete",
            Database = "...my_database...",
            DisableTypeDedupe = true,
            DropCascade = false,
            Host = "...my_host...",
            JdbcUrlParams = "...my_jdbc_url_params...",
            Password = "...my_password...",
            Port = 5432,
            RawDataSchema = "...my_raw_data_schema...",
            Schema = "public",
            Ssl = true,
            SslMode = new Airbyte.Inputs.DestinationPostgresConfigurationSslModeArgs
            {
                VerifyCa = new Airbyte.Inputs.DestinationPostgresConfigurationSslModeVerifyCaArgs
                {
                    AdditionalProperties = "{ \"see\": \"documentation\" }",
                    CaCertificate = "...my_ca_certificate...",
                    ClientKeyPassword = "...my_client_key_password...",
                    Mode = "verify-ca",
                },
            },
            TunnelMethod = new Airbyte.Inputs.DestinationPostgresConfigurationTunnelMethodArgs
            {
                PasswordAuthentication = new Airbyte.Inputs.DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs
                {
                    AdditionalProperties = "{ \"see\": \"documentation\" }",
                    TunnelHost = "...my_tunnel_host...",
                    TunnelMethod = "SSH_PASSWORD_AUTH",
                    TunnelPort = 28502,
                    TunnelUser = "...my_tunnel_user...",
                    TunnelUserPassword = "...my_tunnel_user_password...",
                },
            },
            UnconstrainedNumber = false,
            Username = "...my_username...",
        },
        DefinitionId = "6cc561e7-8b38-4621-919b-0687fe3682b7",
        Name = "...my_name...",
        WorkspaceId = "2b2d880a-23fd-4463-8627-0a837b28bb7e",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.airbyte.DestinationPostgres;
import com.pulumi.airbyte.DestinationPostgresArgs;
import com.pulumi.airbyte.inputs.DestinationPostgresConfigurationArgs;
import com.pulumi.airbyte.inputs.DestinationPostgresConfigurationSslModeArgs;
import com.pulumi.airbyte.inputs.DestinationPostgresConfigurationSslModeVerifyCaArgs;
import com.pulumi.airbyte.inputs.DestinationPostgresConfigurationTunnelMethodArgs;
import com.pulumi.airbyte.inputs.DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var myDestinationPostgres = new DestinationPostgres("myDestinationPostgres", DestinationPostgresArgs.builder()
            .configuration(DestinationPostgresConfigurationArgs.builder()
                .additionalProperties("{ \"see\": \"documentation\" }")
                .cdcDeletionMode("Soft delete")
                .database("...my_database...")
                .disableTypeDedupe(true)
                .dropCascade(false)
                .host("...my_host...")
                .jdbcUrlParams("...my_jdbc_url_params...")
                .password("...my_password...")
                .port(5432.0)
                .rawDataSchema("...my_raw_data_schema...")
                .schema("public")
                .ssl(true)
                .sslMode(DestinationPostgresConfigurationSslModeArgs.builder()
                    .verifyCa(DestinationPostgresConfigurationSslModeVerifyCaArgs.builder()
                        .additionalProperties("{ \"see\": \"documentation\" }")
                        .caCertificate("...my_ca_certificate...")
                        .clientKeyPassword("...my_client_key_password...")
                        .mode("verify-ca")
                        .build())
                    .build())
                .tunnelMethod(DestinationPostgresConfigurationTunnelMethodArgs.builder()
                    .passwordAuthentication(DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs.builder()
                        .additionalProperties("{ \"see\": \"documentation\" }")
                        .tunnelHost("...my_tunnel_host...")
                        .tunnelMethod("SSH_PASSWORD_AUTH")
                        .tunnelPort(28502.0)
                        .tunnelUser("...my_tunnel_user...")
                        .tunnelUserPassword("...my_tunnel_user_password...")
                        .build())
                    .build())
                .unconstrainedNumber(false)
                .username("...my_username...")
                .build())
            .definitionId("6cc561e7-8b38-4621-919b-0687fe3682b7")
            .name("...my_name...")
            .workspaceId("2b2d880a-23fd-4463-8627-0a837b28bb7e")
            .build());

    }
}

    resources:
  myDestinationPostgres:
    type: airbyte:DestinationPostgres
    name: my_destination_postgres
    properties:
      configuration:
        additionalProperties: '{ "see": "documentation" }'
        cdcDeletionMode: Soft delete
        database: '...my_database...'
        disableTypeDedupe: true
        dropCascade: false
        host: '...my_host...'
        jdbcUrlParams: '...my_jdbc_url_params...'
        password: '...my_password...'
        port: 5432
        rawDataSchema: '...my_raw_data_schema...'
        schema: public
        ssl: true
        sslMode:
          verifyCa:
            additionalProperties: '{ "see": "documentation" }'
            caCertificate: '...my_ca_certificate...'
            clientKeyPassword: '...my_client_key_password...'
            mode: verify-ca
        tunnelMethod:
          passwordAuthentication:
            additionalProperties: '{ "see": "documentation" }'
            tunnelHost: '...my_tunnel_host...'
            tunnelMethod: SSH_PASSWORD_AUTH
            tunnelPort: 28502
            tunnelUser: '...my_tunnel_user...'
            tunnelUserPassword: '...my_tunnel_user_password...'
        unconstrainedNumber: false
        username: '...my_username...'
      definitionId: 6cc561e7-8b38-4621-919b-0687fe3682b7
      name: '...my_name...'
      workspaceId: 2b2d880a-23fd-4463-8627-0a837b28bb7e

    Create DestinationPostgres Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new DestinationPostgres(name: string, args: DestinationPostgresArgs, opts?: CustomResourceOptions);
    @overload
def DestinationPostgres(resource_name: str,
                        args: DestinationPostgresArgs,
                        opts: Optional[ResourceOptions] = None)

@overload
def DestinationPostgres(resource_name: str,
                        opts: Optional[ResourceOptions] = None,
                        configuration: Optional[DestinationPostgresConfigurationArgs] = None,
                        workspace_id: Optional[str] = None,
                        definition_id: Optional[str] = None,
                        name: Optional[str] = None)
    func NewDestinationPostgres(ctx *Context, name string, args DestinationPostgresArgs, opts ...ResourceOption) (*DestinationPostgres, error)
    public DestinationPostgres(string name, DestinationPostgresArgs args, CustomResourceOptions? opts = null)
    public DestinationPostgres(String name, DestinationPostgresArgs args)
public DestinationPostgres(String name, DestinationPostgresArgs args, CustomResourceOptions options)

    type: airbyte:DestinationPostgres
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args DestinationPostgresArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args DestinationPostgresArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args DestinationPostgresArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args DestinationPostgresArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args DestinationPostgresArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var destinationPostgresResource = new Airbyte.DestinationPostgres("destinationPostgresResource", new()
{
    Configuration = new Airbyte.Inputs.DestinationPostgresConfigurationArgs
    {
        Host = "string",
        Username = "string",
        Database = "string",
        Port = 0,
        DropCascade = false,
        AdditionalProperties = "string",
        JdbcUrlParams = "string",
        Password = "string",
        DisableTypeDedupe = false,
        RawDataSchema = "string",
        Schema = "string",
        Ssl = false,
        SslMode = new Airbyte.Inputs.DestinationPostgresConfigurationSslModeArgs
        {
            Allow = new Airbyte.Inputs.DestinationPostgresConfigurationSslModeAllowArgs
            {
                AdditionalProperties = "string",
                Mode = "string",
            },
            Disable = new Airbyte.Inputs.DestinationPostgresConfigurationSslModeDisableArgs
            {
                AdditionalProperties = "string",
                Mode = "string",
            },
            Prefer = new Airbyte.Inputs.DestinationPostgresConfigurationSslModePreferArgs
            {
                AdditionalProperties = "string",
                Mode = "string",
            },
            Require = new Airbyte.Inputs.DestinationPostgresConfigurationSslModeRequireArgs
            {
                AdditionalProperties = "string",
                Mode = "string",
            },
            VerifyCa = new Airbyte.Inputs.DestinationPostgresConfigurationSslModeVerifyCaArgs
            {
                CaCertificate = "string",
                AdditionalProperties = "string",
                ClientKeyPassword = "string",
                Mode = "string",
            },
            VerifyFull = new Airbyte.Inputs.DestinationPostgresConfigurationSslModeVerifyFullArgs
            {
                CaCertificate = "string",
                ClientCertificate = "string",
                ClientKey = "string",
                AdditionalProperties = "string",
                ClientKeyPassword = "string",
                Mode = "string",
            },
        },
        TunnelMethod = new Airbyte.Inputs.DestinationPostgresConfigurationTunnelMethodArgs
        {
            NoTunnel = new Airbyte.Inputs.DestinationPostgresConfigurationTunnelMethodNoTunnelArgs
            {
                AdditionalProperties = "string",
                TunnelMethod = "string",
            },
            PasswordAuthentication = new Airbyte.Inputs.DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs
            {
                TunnelHost = "string",
                TunnelUser = "string",
                TunnelUserPassword = "string",
                AdditionalProperties = "string",
                TunnelMethod = "string",
                TunnelPort = 0,
            },
            SshKeyAuthentication = new Airbyte.Inputs.DestinationPostgresConfigurationTunnelMethodSshKeyAuthenticationArgs
            {
                SshKey = "string",
                TunnelHost = "string",
                TunnelUser = "string",
                AdditionalProperties = "string",
                TunnelMethod = "string",
                TunnelPort = 0,
            },
        },
        UnconstrainedNumber = false,
        CdcDeletionMode = "string",
    },
    WorkspaceId = "string",
    DefinitionId = "string",
    Name = "string",
});

    example, err := airbyte.NewDestinationPostgres(ctx, "destinationPostgresResource", &airbyte.DestinationPostgresArgs{
	Configuration: &airbyte.DestinationPostgresConfigurationArgs{
		Host:                 pulumi.String("string"),
		Username:             pulumi.String("string"),
		Database:             pulumi.String("string"),
		Port:                 pulumi.Float64(0),
		DropCascade:          pulumi.Bool(false),
		AdditionalProperties: pulumi.String("string"),
		JdbcUrlParams:        pulumi.String("string"),
		Password:             pulumi.String("string"),
		DisableTypeDedupe:    pulumi.Bool(false),
		RawDataSchema:        pulumi.String("string"),
		Schema:               pulumi.String("string"),
		Ssl:                  pulumi.Bool(false),
		SslMode: &airbyte.DestinationPostgresConfigurationSslModeArgs{
			Allow: &airbyte.DestinationPostgresConfigurationSslModeAllowArgs{
				AdditionalProperties: pulumi.String("string"),
				Mode:                 pulumi.String("string"),
			},
			Disable: &airbyte.DestinationPostgresConfigurationSslModeDisableArgs{
				AdditionalProperties: pulumi.String("string"),
				Mode:                 pulumi.String("string"),
			},
			Prefer: &airbyte.DestinationPostgresConfigurationSslModePreferArgs{
				AdditionalProperties: pulumi.String("string"),
				Mode:                 pulumi.String("string"),
			},
			Require: &airbyte.DestinationPostgresConfigurationSslModeRequireArgs{
				AdditionalProperties: pulumi.String("string"),
				Mode:                 pulumi.String("string"),
			},
			VerifyCa: &airbyte.DestinationPostgresConfigurationSslModeVerifyCaArgs{
				CaCertificate:        pulumi.String("string"),
				AdditionalProperties: pulumi.String("string"),
				ClientKeyPassword:    pulumi.String("string"),
				Mode:                 pulumi.String("string"),
			},
			VerifyFull: &airbyte.DestinationPostgresConfigurationSslModeVerifyFullArgs{
				CaCertificate:        pulumi.String("string"),
				ClientCertificate:    pulumi.String("string"),
				ClientKey:            pulumi.String("string"),
				AdditionalProperties: pulumi.String("string"),
				ClientKeyPassword:    pulumi.String("string"),
				Mode:                 pulumi.String("string"),
			},
		},
		TunnelMethod: &airbyte.DestinationPostgresConfigurationTunnelMethodArgs{
			NoTunnel: &airbyte.DestinationPostgresConfigurationTunnelMethodNoTunnelArgs{
				AdditionalProperties: pulumi.String("string"),
				TunnelMethod:         pulumi.String("string"),
			},
			PasswordAuthentication: &airbyte.DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs{
				TunnelHost:           pulumi.String("string"),
				TunnelUser:           pulumi.String("string"),
				TunnelUserPassword:   pulumi.String("string"),
				AdditionalProperties: pulumi.String("string"),
				TunnelMethod:         pulumi.String("string"),
				TunnelPort:           pulumi.Float64(0),
			},
			SshKeyAuthentication: &airbyte.DestinationPostgresConfigurationTunnelMethodSshKeyAuthenticationArgs{
				SshKey:               pulumi.String("string"),
				TunnelHost:           pulumi.String("string"),
				TunnelUser:           pulumi.String("string"),
				AdditionalProperties: pulumi.String("string"),
				TunnelMethod:         pulumi.String("string"),
				TunnelPort:           pulumi.Float64(0),
			},
		},
		UnconstrainedNumber: pulumi.Bool(false),
		CdcDeletionMode:     pulumi.String("string"),
	},
	WorkspaceId:  pulumi.String("string"),
	DefinitionId: pulumi.String("string"),
	Name:         pulumi.String("string"),
})

    var destinationPostgresResource = new DestinationPostgres("destinationPostgresResource", DestinationPostgresArgs.builder()
    .configuration(DestinationPostgresConfigurationArgs.builder()
        .host("string")
        .username("string")
        .database("string")
        .port(0.0)
        .dropCascade(false)
        .additionalProperties("string")
        .jdbcUrlParams("string")
        .password("string")
        .disableTypeDedupe(false)
        .rawDataSchema("string")
        .schema("string")
        .ssl(false)
        .sslMode(DestinationPostgresConfigurationSslModeArgs.builder()
            .allow(DestinationPostgresConfigurationSslModeAllowArgs.builder()
                .additionalProperties("string")
                .mode("string")
                .build())
            .disable(DestinationPostgresConfigurationSslModeDisableArgs.builder()
                .additionalProperties("string")
                .mode("string")
                .build())
            .prefer(DestinationPostgresConfigurationSslModePreferArgs.builder()
                .additionalProperties("string")
                .mode("string")
                .build())
            .require(DestinationPostgresConfigurationSslModeRequireArgs.builder()
                .additionalProperties("string")
                .mode("string")
                .build())
            .verifyCa(DestinationPostgresConfigurationSslModeVerifyCaArgs.builder()
                .caCertificate("string")
                .additionalProperties("string")
                .clientKeyPassword("string")
                .mode("string")
                .build())
            .verifyFull(DestinationPostgresConfigurationSslModeVerifyFullArgs.builder()
                .caCertificate("string")
                .clientCertificate("string")
                .clientKey("string")
                .additionalProperties("string")
                .clientKeyPassword("string")
                .mode("string")
                .build())
            .build())
        .tunnelMethod(DestinationPostgresConfigurationTunnelMethodArgs.builder()
            .noTunnel(DestinationPostgresConfigurationTunnelMethodNoTunnelArgs.builder()
                .additionalProperties("string")
                .tunnelMethod("string")
                .build())
            .passwordAuthentication(DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs.builder()
                .tunnelHost("string")
                .tunnelUser("string")
                .tunnelUserPassword("string")
                .additionalProperties("string")
                .tunnelMethod("string")
                .tunnelPort(0.0)
                .build())
            .sshKeyAuthentication(DestinationPostgresConfigurationTunnelMethodSshKeyAuthenticationArgs.builder()
                .sshKey("string")
                .tunnelHost("string")
                .tunnelUser("string")
                .additionalProperties("string")
                .tunnelMethod("string")
                .tunnelPort(0.0)
                .build())
            .build())
        .unconstrainedNumber(false)
        .cdcDeletionMode("string")
        .build())
    .workspaceId("string")
    .definitionId("string")
    .name("string")
    .build());

    destination_postgres_resource = airbyte.DestinationPostgres("destinationPostgresResource",
    configuration={
        "host": "string",
        "username": "string",
        "database": "string",
        "port": 0,
        "drop_cascade": False,
        "additional_properties": "string",
        "jdbc_url_params": "string",
        "password": "string",
        "disable_type_dedupe": False,
        "raw_data_schema": "string",
        "schema": "string",
        "ssl": False,
        "ssl_mode": {
            "allow": {
                "additional_properties": "string",
                "mode": "string",
            },
            "disable": {
                "additional_properties": "string",
                "mode": "string",
            },
            "prefer": {
                "additional_properties": "string",
                "mode": "string",
            },
            "require": {
                "additional_properties": "string",
                "mode": "string",
            },
            "verify_ca": {
                "ca_certificate": "string",
                "additional_properties": "string",
                "client_key_password": "string",
                "mode": "string",
            },
            "verify_full": {
                "ca_certificate": "string",
                "client_certificate": "string",
                "client_key": "string",
                "additional_properties": "string",
                "client_key_password": "string",
                "mode": "string",
            },
        },
        "tunnel_method": {
            "no_tunnel": {
                "additional_properties": "string",
                "tunnel_method": "string",
            },
            "password_authentication": {
                "tunnel_host": "string",
                "tunnel_user": "string",
                "tunnel_user_password": "string",
                "additional_properties": "string",
                "tunnel_method": "string",
                "tunnel_port": 0,
            },
            "ssh_key_authentication": {
                "ssh_key": "string",
                "tunnel_host": "string",
                "tunnel_user": "string",
                "additional_properties": "string",
                "tunnel_method": "string",
                "tunnel_port": 0,
            },
        },
        "unconstrained_number": False,
        "cdc_deletion_mode": "string",
    },
    workspace_id="string",
    definition_id="string",
    name="string")

    const destinationPostgresResource = new airbyte.DestinationPostgres("destinationPostgresResource", {
    configuration: {
        host: "string",
        username: "string",
        database: "string",
        port: 0,
        dropCascade: false,
        additionalProperties: "string",
        jdbcUrlParams: "string",
        password: "string",
        disableTypeDedupe: false,
        rawDataSchema: "string",
        schema: "string",
        ssl: false,
        sslMode: {
            allow: {
                additionalProperties: "string",
                mode: "string",
            },
            disable: {
                additionalProperties: "string",
                mode: "string",
            },
            prefer: {
                additionalProperties: "string",
                mode: "string",
            },
            require: {
                additionalProperties: "string",
                mode: "string",
            },
            verifyCa: {
                caCertificate: "string",
                additionalProperties: "string",
                clientKeyPassword: "string",
                mode: "string",
            },
            verifyFull: {
                caCertificate: "string",
                clientCertificate: "string",
                clientKey: "string",
                additionalProperties: "string",
                clientKeyPassword: "string",
                mode: "string",
            },
        },
        tunnelMethod: {
            noTunnel: {
                additionalProperties: "string",
                tunnelMethod: "string",
            },
            passwordAuthentication: {
                tunnelHost: "string",
                tunnelUser: "string",
                tunnelUserPassword: "string",
                additionalProperties: "string",
                tunnelMethod: "string",
                tunnelPort: 0,
            },
            sshKeyAuthentication: {
                sshKey: "string",
                tunnelHost: "string",
                tunnelUser: "string",
                additionalProperties: "string",
                tunnelMethod: "string",
                tunnelPort: 0,
            },
        },
        unconstrainedNumber: false,
        cdcDeletionMode: "string",
    },
    workspaceId: "string",
    definitionId: "string",
    name: "string",
});

    type: airbyte:DestinationPostgres
properties:
    configuration:
        additionalProperties: string
        cdcDeletionMode: string
        database: string
        disableTypeDedupe: false
        dropCascade: false
        host: string
        jdbcUrlParams: string
        password: string
        port: 0
        rawDataSchema: string
        schema: string
        ssl: false
        sslMode:
            allow:
                additionalProperties: string
                mode: string
            disable:
                additionalProperties: string
                mode: string
            prefer:
                additionalProperties: string
                mode: string
            require:
                additionalProperties: string
                mode: string
            verifyCa:
                additionalProperties: string
                caCertificate: string
                clientKeyPassword: string
                mode: string
            verifyFull:
                additionalProperties: string
                caCertificate: string
                clientCertificate: string
                clientKey: string
                clientKeyPassword: string
                mode: string
        tunnelMethod:
            noTunnel:
                additionalProperties: string
                tunnelMethod: string
            passwordAuthentication:
                additionalProperties: string
                tunnelHost: string
                tunnelMethod: string
                tunnelPort: 0
                tunnelUser: string
                tunnelUserPassword: string
            sshKeyAuthentication:
                additionalProperties: string
                sshKey: string
                tunnelHost: string
                tunnelMethod: string
                tunnelPort: 0
                tunnelUser: string
        unconstrainedNumber: false
        username: string
    definitionId: string
    name: string
    workspaceId: string

    DestinationPostgres Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The DestinationPostgres resource accepts the following input properties:

    Configuration DestinationPostgresConfiguration
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    WorkspaceId string
    DefinitionId string
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    Name string
    Name of the destination e.g. dev-mysql-instance.
    Configuration DestinationPostgresConfigurationArgs
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    WorkspaceId string
    DefinitionId string
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    Name string
    Name of the destination e.g. dev-mysql-instance.
    configuration DestinationPostgresConfiguration
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    workspaceId String
    definitionId String
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    name String
    Name of the destination e.g. dev-mysql-instance.
    configuration DestinationPostgresConfiguration
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    workspaceId string
    definitionId string
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    name string
    Name of the destination e.g. dev-mysql-instance.
    configuration DestinationPostgresConfigurationArgs
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    workspace_id str
    definition_id str
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    name str
    Name of the destination e.g. dev-mysql-instance.
    configuration Property Map
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    workspaceId String
    definitionId String
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    name String
    Name of the destination e.g. dev-mysql-instance.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the DestinationPostgres resource produces the following output properties:

    CreatedAt double
    DestinationId string
    DestinationType string
    Id string
    The provider-assigned unique ID for this managed resource.
    ResourceAllocation DestinationPostgresResourceAllocation
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
    CreatedAt float64
    DestinationId string
    DestinationType string
    Id string
    The provider-assigned unique ID for this managed resource.
    ResourceAllocation DestinationPostgresResourceAllocation
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
    createdAt Double
    destinationId String
    destinationType String
    id String
    The provider-assigned unique ID for this managed resource.
    resourceAllocation DestinationPostgresResourceAllocation
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
    createdAt number
    destinationId string
    destinationType string
    id string
    The provider-assigned unique ID for this managed resource.
    resourceAllocation DestinationPostgresResourceAllocation
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
    created_at float
    destination_id str
    destination_type str
    id str
    The provider-assigned unique ID for this managed resource.
    resource_allocation DestinationPostgresResourceAllocation
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
    createdAt Number
    destinationId String
    destinationType String
    id String
    The provider-assigned unique ID for this managed resource.
    resourceAllocation Property Map
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.

    Look up Existing DestinationPostgres Resource

    Get an existing DestinationPostgres resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: DestinationPostgresState, opts?: CustomResourceOptions): DestinationPostgres
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        configuration: Optional[DestinationPostgresConfigurationArgs] = None,
        created_at: Optional[float] = None,
        definition_id: Optional[str] = None,
        destination_id: Optional[str] = None,
        destination_type: Optional[str] = None,
        name: Optional[str] = None,
        resource_allocation: Optional[DestinationPostgresResourceAllocationArgs] = None,
        workspace_id: Optional[str] = None) -> DestinationPostgres
    func GetDestinationPostgres(ctx *Context, name string, id IDInput, state *DestinationPostgresState, opts ...ResourceOption) (*DestinationPostgres, error)
    public static DestinationPostgres Get(string name, Input<string> id, DestinationPostgresState? state, CustomResourceOptions? opts = null)
    public static DestinationPostgres get(String name, Output<String> id, DestinationPostgresState state, CustomResourceOptions options)
    resources:  _:    type: airbyte:DestinationPostgres    get:      id: ${id}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    Configuration DestinationPostgresConfiguration
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    CreatedAt double
    DefinitionId string
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    DestinationId string
    DestinationType string
    Name string
    Name of the destination e.g. dev-mysql-instance.
    ResourceAllocation DestinationPostgresResourceAllocation
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
    WorkspaceId string
    Configuration DestinationPostgresConfigurationArgs
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    CreatedAt float64
    DefinitionId string
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    DestinationId string
    DestinationType string
    Name string
    Name of the destination e.g. dev-mysql-instance.
    ResourceAllocation DestinationPostgresResourceAllocationArgs
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
    WorkspaceId string
    configuration DestinationPostgresConfiguration
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    createdAt Double
    definitionId String
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    destinationId String
    destinationType String
    name String
    Name of the destination e.g. dev-mysql-instance.
    resourceAllocation DestinationPostgresResourceAllocation
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
    workspaceId String
    configuration DestinationPostgresConfiguration
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    createdAt number
    definitionId string
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    destinationId string
    destinationType string
    name string
    Name of the destination e.g. dev-mysql-instance.
    resourceAllocation DestinationPostgresResourceAllocation
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
    workspaceId string
    configuration DestinationPostgresConfigurationArgs
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    created_at float
    definition_id str
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    destination_id str
    destination_type str
    name str
    Name of the destination e.g. dev-mysql-instance.
    resource_allocation DestinationPostgresResourceAllocationArgs
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
    workspace_id str
    configuration Property Map
    The values required to configure the destination. The schema for this must match the schema return by destinationdefinitionspecifications/get for the destinationDefinition.
    createdAt Number
    definitionId String
    The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Default: "25c5221d-dce2-4163-ade9-739ef790f503"; Requires replacement if changed.
    destinationId String
    destinationType String
    name String
    Name of the destination e.g. dev-mysql-instance.
    resourceAllocation Property Map
    actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
    workspaceId String

    Supporting Types

    DestinationPostgresConfiguration, DestinationPostgresConfigurationArgs

    Database string
    Name of the database.
    Host string
    Hostname of the database.
    Port double
    Port of the database.
    Username string
    Username to access the database.
    AdditionalProperties string
    Parsed as JSON.
    CdcDeletionMode string
    Whether to execute CDC deletions as hard deletes (i.e. propagate source deletions to the destination), or soft deletes (i.e. leave a tombstone record in the destination). Defaults to hard deletes. Default: "Hard delete"; must be one of ["Hard delete", "Soft delete"]
    DisableTypeDedupe bool
    Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions
    DropCascade bool
    Drop tables with CASCADE. WARNING! This will delete all data in all dependent objects (views, etc.). Use with caution. This option is intended for usecases which can easily rebuild the dependent objects.
    JdbcUrlParams string
    Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
    Password string
    Password associated with the username.
    RawDataSchema string
    Airbyte will use this schema for various internal tables. In legacy raw tables mode, the raw tables will be stored in this schema. Defaults to <span pulumi-lang-nodejs=""airbyteInternal"" pulumi-lang-dotnet=""AirbyteInternal"" pulumi-lang-go=""airbyteInternal"" pulumi-lang-python=""airbyte_internal"" pulumi-lang-yaml=""airbyteInternal"" pulumi-lang-java=""airbyteInternal"">"airbyte_internal".
    Schema string
    The default schema tables are written. If not specified otherwise, the "public" schema will be used. Default: "public"
    Ssl bool
    Encrypt data using SSL. When activating SSL, please select one of the connection modes.
    SslMode DestinationPostgresConfigurationSslMode
    SSL connection modes. \n\ndisable\n\n - Disables encryption of communication between Airbyte and destination database. \n\nallow\n\n - Enables encryption only when required by the destination database. \n\nprefer\n\n - Allows unencrypted connections only if the destination database does not support encryption. \n\nrequire\n\n - Always require encryption. If the destination database server does not support encryption, connection will fail. \n\nverify-ca\n\n - Always require encryption and verifies that the destination database server has a valid SSL certificate. \n\nverify-full\n\n - This is the most secure mode. Always require encryption and verifies the identity of the destination database server. See more information - \n\n in the docs\n\n.
    TunnelMethod DestinationPostgresConfigurationTunnelMethod
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    UnconstrainedNumber bool
    Create numeric columns as unconstrained DECIMAL instead of NUMBER(38, 9). This will allow increased precision in numeric values. (this is disabled by default for backwards compatibility, but is recommended to enable)
    Database string
    Name of the database.
    Host string
    Hostname of the database.
    Port float64
    Port of the database.
    Username string
    Username to access the database.
    AdditionalProperties string
    Parsed as JSON.
    CdcDeletionMode string
    Whether to execute CDC deletions as hard deletes (i.e. propagate source deletions to the destination), or soft deletes (i.e. leave a tombstone record in the destination). Defaults to hard deletes. Default: "Hard delete"; must be one of ["Hard delete", "Soft delete"]
    DisableTypeDedupe bool
    Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions
    DropCascade bool
    Drop tables with CASCADE. WARNING! This will delete all data in all dependent objects (views, etc.). Use with caution. This option is intended for usecases which can easily rebuild the dependent objects.
    JdbcUrlParams string
    Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
    Password string
    Password associated with the username.
    RawDataSchema string
    Airbyte will use this schema for various internal tables. In legacy raw tables mode, the raw tables will be stored in this schema. Defaults to <span pulumi-lang-nodejs=""airbyteInternal"" pulumi-lang-dotnet=""AirbyteInternal"" pulumi-lang-go=""airbyteInternal"" pulumi-lang-python=""airbyte_internal"" pulumi-lang-yaml=""airbyteInternal"" pulumi-lang-java=""airbyteInternal"">"airbyte_internal".
    Schema string
    The default schema tables are written. If not specified otherwise, the "public" schema will be used. Default: "public"
    Ssl bool
    Encrypt data using SSL. When activating SSL, please select one of the connection modes.
    SslMode DestinationPostgresConfigurationSslMode
    SSL connection modes. \n\ndisable\n\n - Disables encryption of communication between Airbyte and destination database. \n\nallow\n\n - Enables encryption only when required by the destination database. \n\nprefer\n\n - Allows unencrypted connections only if the destination database does not support encryption. \n\nrequire\n\n - Always require encryption. If the destination database server does not support encryption, connection will fail. \n\nverify-ca\n\n - Always require encryption and verifies that the destination database server has a valid SSL certificate. \n\nverify-full\n\n - This is the most secure mode. Always require encryption and verifies the identity of the destination database server. See more information - \n\n in the docs\n\n.
    TunnelMethod DestinationPostgresConfigurationTunnelMethod
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    UnconstrainedNumber bool
    Create numeric columns as unconstrained DECIMAL instead of NUMBER(38, 9). This will allow increased precision in numeric values. (this is disabled by default for backwards compatibility, but is recommended to enable)
    database String
    Name of the database.
    host String
    Hostname of the database.
    port Double
    Port of the database.
    username String
    Username to access the database.
    additionalProperties String
    Parsed as JSON.
    cdcDeletionMode String
    Whether to execute CDC deletions as hard deletes (i.e. propagate source deletions to the destination), or soft deletes (i.e. leave a tombstone record in the destination). Defaults to hard deletes. Default: "Hard delete"; must be one of ["Hard delete", "Soft delete"]
    disableTypeDedupe Boolean
    Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions
    dropCascade Boolean
    Drop tables with CASCADE. WARNING! This will delete all data in all dependent objects (views, etc.). Use with caution. This option is intended for usecases which can easily rebuild the dependent objects.
    jdbcUrlParams String
    Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
    password String
    Password associated with the username.
    rawDataSchema String
    Airbyte will use this schema for various internal tables. In legacy raw tables mode, the raw tables will be stored in this schema. Defaults to <span pulumi-lang-nodejs=""airbyteInternal"" pulumi-lang-dotnet=""AirbyteInternal"" pulumi-lang-go=""airbyteInternal"" pulumi-lang-python=""airbyte_internal"" pulumi-lang-yaml=""airbyteInternal"" pulumi-lang-java=""airbyteInternal"">"airbyte_internal".
    schema String
    The default schema tables are written. If not specified otherwise, the "public" schema will be used. Default: "public"
    ssl Boolean
    Encrypt data using SSL. When activating SSL, please select one of the connection modes.
    sslMode DestinationPostgresConfigurationSslMode
    SSL connection modes. \n\ndisable\n\n - Disables encryption of communication between Airbyte and destination database. \n\nallow\n\n - Enables encryption only when required by the destination database. \n\nprefer\n\n - Allows unencrypted connections only if the destination database does not support encryption. \n\nrequire\n\n - Always require encryption. If the destination database server does not support encryption, connection will fail. \n\nverify-ca\n\n - Always require encryption and verifies that the destination database server has a valid SSL certificate. \n\nverify-full\n\n - This is the most secure mode. Always require encryption and verifies the identity of the destination database server. See more information - \n\n in the docs\n\n.
    tunnelMethod DestinationPostgresConfigurationTunnelMethod
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    unconstrainedNumber Boolean
    Create numeric columns as unconstrained DECIMAL instead of NUMBER(38, 9). This will allow increased precision in numeric values. (this is disabled by default for backwards compatibility, but is recommended to enable)
    database string
    Name of the database.
    host string
    Hostname of the database.
    port number
    Port of the database.
    username string
    Username to access the database.
    additionalProperties string
    Parsed as JSON.
    cdcDeletionMode string
    Whether to execute CDC deletions as hard deletes (i.e. propagate source deletions to the destination), or soft deletes (i.e. leave a tombstone record in the destination). Defaults to hard deletes. Default: "Hard delete"; must be one of ["Hard delete", "Soft delete"]
    disableTypeDedupe boolean
    Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions
    dropCascade boolean
    Drop tables with CASCADE. WARNING! This will delete all data in all dependent objects (views, etc.). Use with caution. This option is intended for usecases which can easily rebuild the dependent objects.
    jdbcUrlParams string
    Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
    password string
    Password associated with the username.
    rawDataSchema string
    Airbyte will use this schema for various internal tables. In legacy raw tables mode, the raw tables will be stored in this schema. Defaults to <span pulumi-lang-nodejs=""airbyteInternal"" pulumi-lang-dotnet=""AirbyteInternal"" pulumi-lang-go=""airbyteInternal"" pulumi-lang-python=""airbyte_internal"" pulumi-lang-yaml=""airbyteInternal"" pulumi-lang-java=""airbyteInternal"">"airbyte_internal".
    schema string
    The default schema tables are written. If not specified otherwise, the "public" schema will be used. Default: "public"
    ssl boolean
    Encrypt data using SSL. When activating SSL, please select one of the connection modes.
    sslMode DestinationPostgresConfigurationSslMode
    SSL connection modes. \n\ndisable\n\n - Disables encryption of communication between Airbyte and destination database. \n\nallow\n\n - Enables encryption only when required by the destination database. \n\nprefer\n\n - Allows unencrypted connections only if the destination database does not support encryption. \n\nrequire\n\n - Always require encryption. If the destination database server does not support encryption, connection will fail. \n\nverify-ca\n\n - Always require encryption and verifies that the destination database server has a valid SSL certificate. \n\nverify-full\n\n - This is the most secure mode. Always require encryption and verifies the identity of the destination database server. See more information - \n\n in the docs\n\n.
    tunnelMethod DestinationPostgresConfigurationTunnelMethod
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    unconstrainedNumber boolean
    Create numeric columns as unconstrained DECIMAL instead of NUMBER(38, 9). This will allow increased precision in numeric values. (this is disabled by default for backwards compatibility, but is recommended to enable)
    database str
    Name of the database.
    host str
    Hostname of the database.
    port float
    Port of the database.
    username str
    Username to access the database.
    additional_properties str
    Parsed as JSON.
    cdc_deletion_mode str
    Whether to execute CDC deletions as hard deletes (i.e. propagate source deletions to the destination), or soft deletes (i.e. leave a tombstone record in the destination). Defaults to hard deletes. Default: "Hard delete"; must be one of ["Hard delete", "Soft delete"]
    disable_type_dedupe bool
    Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions
    drop_cascade bool
    Drop tables with CASCADE. WARNING! This will delete all data in all dependent objects (views, etc.). Use with caution. This option is intended for usecases which can easily rebuild the dependent objects.
    jdbc_url_params str
    Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
    password str
    Password associated with the username.
    raw_data_schema str
    Airbyte will use this schema for various internal tables. In legacy raw tables mode, the raw tables will be stored in this schema. Defaults to <span pulumi-lang-nodejs=""airbyteInternal"" pulumi-lang-dotnet=""AirbyteInternal"" pulumi-lang-go=""airbyteInternal"" pulumi-lang-python=""airbyte_internal"" pulumi-lang-yaml=""airbyteInternal"" pulumi-lang-java=""airbyteInternal"">"airbyte_internal".
    schema str
    The default schema tables are written. If not specified otherwise, the "public" schema will be used. Default: "public"
    ssl bool
    Encrypt data using SSL. When activating SSL, please select one of the connection modes.
    ssl_mode DestinationPostgresConfigurationSslMode
    SSL connection modes. \n\ndisable\n\n - Disables encryption of communication between Airbyte and destination database. \n\nallow\n\n - Enables encryption only when required by the destination database. \n\nprefer\n\n - Allows unencrypted connections only if the destination database does not support encryption. \n\nrequire\n\n - Always require encryption. If the destination database server does not support encryption, connection will fail. \n\nverify-ca\n\n - Always require encryption and verifies that the destination database server has a valid SSL certificate. \n\nverify-full\n\n - This is the most secure mode. Always require encryption and verifies the identity of the destination database server. See more information - \n\n in the docs\n\n.
    tunnel_method DestinationPostgresConfigurationTunnelMethod
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    unconstrained_number bool
    Create numeric columns as unconstrained DECIMAL instead of NUMBER(38, 9). This will allow increased precision in numeric values. (this is disabled by default for backwards compatibility, but is recommended to enable)
    database String
    Name of the database.
    host String
    Hostname of the database.
    port Number
    Port of the database.
    username String
    Username to access the database.
    additionalProperties String
    Parsed as JSON.
    cdcDeletionMode String
    Whether to execute CDC deletions as hard deletes (i.e. propagate source deletions to the destination), or soft deletes (i.e. leave a tombstone record in the destination). Defaults to hard deletes. Default: "Hard delete"; must be one of ["Hard delete", "Soft delete"]
    disableTypeDedupe Boolean
    Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions
    dropCascade Boolean
    Drop tables with CASCADE. WARNING! This will delete all data in all dependent objects (views, etc.). Use with caution. This option is intended for usecases which can easily rebuild the dependent objects.
    jdbcUrlParams String
    Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
    password String
    Password associated with the username.
    rawDataSchema String
    Airbyte will use this schema for various internal tables. In legacy raw tables mode, the raw tables will be stored in this schema. Defaults to <span pulumi-lang-nodejs=""airbyteInternal"" pulumi-lang-dotnet=""AirbyteInternal"" pulumi-lang-go=""airbyteInternal"" pulumi-lang-python=""airbyte_internal"" pulumi-lang-yaml=""airbyteInternal"" pulumi-lang-java=""airbyteInternal"">"airbyte_internal".
    schema String
    The default schema tables are written. If not specified otherwise, the "public" schema will be used. Default: "public"
    ssl Boolean
    Encrypt data using SSL. When activating SSL, please select one of the connection modes.
    sslMode Property Map
    SSL connection modes. \n\ndisable\n\n - Disables encryption of communication between Airbyte and destination database. \n\nallow\n\n - Enables encryption only when required by the destination database. \n\nprefer\n\n - Allows unencrypted connections only if the destination database does not support encryption. \n\nrequire\n\n - Always require encryption. If the destination database server does not support encryption, connection will fail. \n\nverify-ca\n\n - Always require encryption and verifies that the destination database server has a valid SSL certificate. \n\nverify-full\n\n - This is the most secure mode. Always require encryption and verifies the identity of the destination database server. See more information - \n\n in the docs\n\n.
    tunnelMethod Property Map
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    unconstrainedNumber Boolean
    Create numeric columns as unconstrained DECIMAL instead of NUMBER(38, 9). This will allow increased precision in numeric values. (this is disabled by default for backwards compatibility, but is recommended to enable)

    DestinationPostgresConfigurationSslMode, DestinationPostgresConfigurationSslModeArgs

    allow Property Map
    Allow SSL mode.
    disable Property Map
    Disable SSL.
    prefer Property Map
    Prefer SSL mode.
    require Property Map
    Require SSL mode.
    verifyCa Property Map
    Verify-ca SSL mode.
    verifyFull Property Map
    Verify-full SSL mode.

    DestinationPostgresConfigurationSslModeAllow, DestinationPostgresConfigurationSslModeAllowArgs

    AdditionalProperties string
    Parsed as JSON.
    Mode string
    Default: "allow"; must be "allow"
    AdditionalProperties string
    Parsed as JSON.
    Mode string
    Default: "allow"; must be "allow"
    additionalProperties String
    Parsed as JSON.
    mode String
    Default: "allow"; must be "allow"
    additionalProperties string
    Parsed as JSON.
    mode string
    Default: "allow"; must be "allow"
    additional_properties str
    Parsed as JSON.
    mode str
    Default: "allow"; must be "allow"
    additionalProperties String
    Parsed as JSON.
    mode String
    Default: "allow"; must be "allow"

    DestinationPostgresConfigurationSslModeDisable, DestinationPostgresConfigurationSslModeDisableArgs

    AdditionalProperties string
    Parsed as JSON.
    Mode string
    Default: "disable"; must be "disable"
    AdditionalProperties string
    Parsed as JSON.
    Mode string
    Default: "disable"; must be "disable"
    additionalProperties String
    Parsed as JSON.
    mode String
    Default: "disable"; must be "disable"
    additionalProperties string
    Parsed as JSON.
    mode string
    Default: "disable"; must be "disable"
    additional_properties str
    Parsed as JSON.
    mode str
    Default: "disable"; must be "disable"
    additionalProperties String
    Parsed as JSON.
    mode String
    Default: "disable"; must be "disable"

    DestinationPostgresConfigurationSslModePrefer, DestinationPostgresConfigurationSslModePreferArgs

    AdditionalProperties string
    Parsed as JSON.
    Mode string
    Default: "prefer"; must be "prefer"
    AdditionalProperties string
    Parsed as JSON.
    Mode string
    Default: "prefer"; must be "prefer"
    additionalProperties String
    Parsed as JSON.
    mode String
    Default: "prefer"; must be "prefer"
    additionalProperties string
    Parsed as JSON.
    mode string
    Default: "prefer"; must be "prefer"
    additional_properties str
    Parsed as JSON.
    mode str
    Default: "prefer"; must be "prefer"
    additionalProperties String
    Parsed as JSON.
    mode String
    Default: "prefer"; must be "prefer"

    DestinationPostgresConfigurationSslModeRequire, DestinationPostgresConfigurationSslModeRequireArgs

    AdditionalProperties string
    Parsed as JSON.
    Mode string
    Default: "require"; must be "require"
    AdditionalProperties string
    Parsed as JSON.
    Mode string
    Default: "require"; must be "require"
    additionalProperties String
    Parsed as JSON.
    mode String
    Default: "require"; must be "require"
    additionalProperties string
    Parsed as JSON.
    mode string
    Default: "require"; must be "require"
    additional_properties str
    Parsed as JSON.
    mode str
    Default: "require"; must be "require"
    additionalProperties String
    Parsed as JSON.
    mode String
    Default: "require"; must be "require"

    DestinationPostgresConfigurationSslModeVerifyCa, DestinationPostgresConfigurationSslModeVerifyCaArgs

    CaCertificate string
    CA certificate
    AdditionalProperties string
    Parsed as JSON.
    ClientKeyPassword string
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    Mode string
    Default: "verify-ca"; must be "verify-ca"
    CaCertificate string
    CA certificate
    AdditionalProperties string
    Parsed as JSON.
    ClientKeyPassword string
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    Mode string
    Default: "verify-ca"; must be "verify-ca"
    caCertificate String
    CA certificate
    additionalProperties String
    Parsed as JSON.
    clientKeyPassword String
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    mode String
    Default: "verify-ca"; must be "verify-ca"
    caCertificate string
    CA certificate
    additionalProperties string
    Parsed as JSON.
    clientKeyPassword string
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    mode string
    Default: "verify-ca"; must be "verify-ca"
    ca_certificate str
    CA certificate
    additional_properties str
    Parsed as JSON.
    client_key_password str
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    mode str
    Default: "verify-ca"; must be "verify-ca"
    caCertificate String
    CA certificate
    additionalProperties String
    Parsed as JSON.
    clientKeyPassword String
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    mode String
    Default: "verify-ca"; must be "verify-ca"

    DestinationPostgresConfigurationSslModeVerifyFull, DestinationPostgresConfigurationSslModeVerifyFullArgs

    CaCertificate string
    CA certificate
    ClientCertificate string
    Client certificate
    ClientKey string
    Client key
    AdditionalProperties string
    Parsed as JSON.
    ClientKeyPassword string
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    Mode string
    Default: "verify-full"; must be "verify-full"
    CaCertificate string
    CA certificate
    ClientCertificate string
    Client certificate
    ClientKey string
    Client key
    AdditionalProperties string
    Parsed as JSON.
    ClientKeyPassword string
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    Mode string
    Default: "verify-full"; must be "verify-full"
    caCertificate String
    CA certificate
    clientCertificate String
    Client certificate
    clientKey String
    Client key
    additionalProperties String
    Parsed as JSON.
    clientKeyPassword String
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    mode String
    Default: "verify-full"; must be "verify-full"
    caCertificate string
    CA certificate
    clientCertificate string
    Client certificate
    clientKey string
    Client key
    additionalProperties string
    Parsed as JSON.
    clientKeyPassword string
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    mode string
    Default: "verify-full"; must be "verify-full"
    ca_certificate str
    CA certificate
    client_certificate str
    Client certificate
    client_key str
    Client key
    additional_properties str
    Parsed as JSON.
    client_key_password str
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    mode str
    Default: "verify-full"; must be "verify-full"
    caCertificate String
    CA certificate
    clientCertificate String
    Client certificate
    clientKey String
    Client key
    additionalProperties String
    Parsed as JSON.
    clientKeyPassword String
    Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
    mode String
    Default: "verify-full"; must be "verify-full"

    DestinationPostgresConfigurationTunnelMethod, DestinationPostgresConfigurationTunnelMethodArgs

    NoTunnel DestinationPostgresConfigurationTunnelMethodNoTunnel
    No ssh tunnel needed to connect to database
    PasswordAuthentication DestinationPostgresConfigurationTunnelMethodPasswordAuthentication
    Connect through a jump server tunnel host using username and password authentication
    SshKeyAuthentication DestinationPostgresConfigurationTunnelMethodSshKeyAuthentication
    Connect through a jump server tunnel host using username and ssh key
    NoTunnel DestinationPostgresConfigurationTunnelMethodNoTunnel
    No ssh tunnel needed to connect to database
    PasswordAuthentication DestinationPostgresConfigurationTunnelMethodPasswordAuthentication
    Connect through a jump server tunnel host using username and password authentication
    SshKeyAuthentication DestinationPostgresConfigurationTunnelMethodSshKeyAuthentication
    Connect through a jump server tunnel host using username and ssh key
    noTunnel DestinationPostgresConfigurationTunnelMethodNoTunnel
    No ssh tunnel needed to connect to database
    passwordAuthentication DestinationPostgresConfigurationTunnelMethodPasswordAuthentication
    Connect through a jump server tunnel host using username and password authentication
    sshKeyAuthentication DestinationPostgresConfigurationTunnelMethodSshKeyAuthentication
    Connect through a jump server tunnel host using username and ssh key
    noTunnel DestinationPostgresConfigurationTunnelMethodNoTunnel
    No ssh tunnel needed to connect to database
    passwordAuthentication DestinationPostgresConfigurationTunnelMethodPasswordAuthentication
    Connect through a jump server tunnel host using username and password authentication
    sshKeyAuthentication DestinationPostgresConfigurationTunnelMethodSshKeyAuthentication
    Connect through a jump server tunnel host using username and ssh key
    no_tunnel DestinationPostgresConfigurationTunnelMethodNoTunnel
    No ssh tunnel needed to connect to database
    password_authentication DestinationPostgresConfigurationTunnelMethodPasswordAuthentication
    Connect through a jump server tunnel host using username and password authentication
    ssh_key_authentication DestinationPostgresConfigurationTunnelMethodSshKeyAuthentication
    Connect through a jump server tunnel host using username and ssh key
    noTunnel Property Map
    No ssh tunnel needed to connect to database
    passwordAuthentication Property Map
    Connect through a jump server tunnel host using username and password authentication
    sshKeyAuthentication Property Map
    Connect through a jump server tunnel host using username and ssh key

    DestinationPostgresConfigurationTunnelMethodNoTunnel, DestinationPostgresConfigurationTunnelMethodNoTunnelArgs

    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "NOTUNNEL"; must be "NOTUNNEL"
    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "NOTUNNEL"; must be "NOTUNNEL"
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "NOTUNNEL"; must be "NOTUNNEL"
    additionalProperties string
    Parsed as JSON.
    tunnelMethod string
    Default: "NOTUNNEL"; must be "NOTUNNEL"
    additional_properties str
    Parsed as JSON.
    tunnel_method str
    Default: "NOTUNNEL"; must be "NOTUNNEL"
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "NOTUNNEL"; must be "NOTUNNEL"

    DestinationPostgresConfigurationTunnelMethodPasswordAuthentication, DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs

    TunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    TunnelUser string
    OS-level username for logging into the jump server host
    TunnelUserPassword string
    OS-level password for logging into the jump server host
    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    TunnelPort double
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    TunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    TunnelUser string
    OS-level username for logging into the jump server host
    TunnelUserPassword string
    OS-level password for logging into the jump server host
    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    TunnelPort float64
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    tunnelHost String
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser String
    OS-level username for logging into the jump server host
    tunnelUserPassword String
    OS-level password for logging into the jump server host
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    tunnelPort Double
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    tunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser string
    OS-level username for logging into the jump server host
    tunnelUserPassword string
    OS-level password for logging into the jump server host
    additionalProperties string
    Parsed as JSON.
    tunnelMethod string
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    tunnelPort number
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    tunnel_host str
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnel_user str
    OS-level username for logging into the jump server host
    tunnel_user_password str
    OS-level password for logging into the jump server host
    additional_properties str
    Parsed as JSON.
    tunnel_method str
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    tunnel_port float
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    tunnelHost String
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser String
    OS-level username for logging into the jump server host
    tunnelUserPassword String
    OS-level password for logging into the jump server host
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    tunnelPort Number
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

    DestinationPostgresConfigurationTunnelMethodSshKeyAuthentication, DestinationPostgresConfigurationTunnelMethodSshKeyAuthenticationArgs

    SshKey string
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    TunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    TunnelUser string
    OS-level username for logging into the jump server host
    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    TunnelPort double
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    SshKey string
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    TunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    TunnelUser string
    OS-level username for logging into the jump server host
    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    TunnelPort float64
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    sshKey String
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    tunnelHost String
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser String
    OS-level username for logging into the jump server host
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    tunnelPort Double
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    sshKey string
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    tunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser string
    OS-level username for logging into the jump server host
    additionalProperties string
    Parsed as JSON.
    tunnelMethod string
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    tunnelPort number
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    ssh_key str
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    tunnel_host str
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnel_user str
    OS-level username for logging into the jump server host
    additional_properties str
    Parsed as JSON.
    tunnel_method str
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    tunnel_port float
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    sshKey String
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    tunnelHost String
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser String
    OS-level username for logging into the jump server host
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    tunnelPort Number
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

    DestinationPostgresResourceAllocation, DestinationPostgresResourceAllocationArgs

    Default DestinationPostgresResourceAllocationDefault
    optional resource requirements to run workers (blank for unbounded allocations)
    JobSpecifics List<DestinationPostgresResourceAllocationJobSpecific>
    Default DestinationPostgresResourceAllocationDefault
    optional resource requirements to run workers (blank for unbounded allocations)
    JobSpecifics []DestinationPostgresResourceAllocationJobSpecific
    default_ DestinationPostgresResourceAllocationDefault
    optional resource requirements to run workers (blank for unbounded allocations)
    jobSpecifics List<DestinationPostgresResourceAllocationJobSpecific>
    default DestinationPostgresResourceAllocationDefault
    optional resource requirements to run workers (blank for unbounded allocations)
    jobSpecifics DestinationPostgresResourceAllocationJobSpecific[]
    default Property Map
    optional resource requirements to run workers (blank for unbounded allocations)
    jobSpecifics List<Property Map>

    DestinationPostgresResourceAllocationDefault, DestinationPostgresResourceAllocationDefaultArgs

    DestinationPostgresResourceAllocationJobSpecific, DestinationPostgresResourceAllocationJobSpecificArgs

    JobType string
    enum that describes the different types of jobs that the platform runs.
    ResourceRequirements DestinationPostgresResourceAllocationJobSpecificResourceRequirements
    optional resource requirements to run workers (blank for unbounded allocations)
    JobType string
    enum that describes the different types of jobs that the platform runs.
    ResourceRequirements DestinationPostgresResourceAllocationJobSpecificResourceRequirements
    optional resource requirements to run workers (blank for unbounded allocations)
    jobType String
    enum that describes the different types of jobs that the platform runs.
    resourceRequirements DestinationPostgresResourceAllocationJobSpecificResourceRequirements
    optional resource requirements to run workers (blank for unbounded allocations)
    jobType string
    enum that describes the different types of jobs that the platform runs.
    resourceRequirements DestinationPostgresResourceAllocationJobSpecificResourceRequirements
    optional resource requirements to run workers (blank for unbounded allocations)
    job_type str
    enum that describes the different types of jobs that the platform runs.
    resource_requirements DestinationPostgresResourceAllocationJobSpecificResourceRequirements
    optional resource requirements to run workers (blank for unbounded allocations)
    jobType String
    enum that describes the different types of jobs that the platform runs.
    resourceRequirements Property Map
    optional resource requirements to run workers (blank for unbounded allocations)

    DestinationPostgresResourceAllocationJobSpecificResourceRequirements, DestinationPostgresResourceAllocationJobSpecificResourceRequirementsArgs

    Import

    In Terraform v1.5.0 and later, the import block can be used with the id attribute, for example:

    terraform

    import {

    to = airbyte_destination_postgres.my_airbyte_destination_postgres

    id = “…”

    }

    The pulumi import command can be used, for example:

    $ pulumi import airbyte:index/destinationPostgres:DestinationPostgres my_airbyte_destination_postgres "..."

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    airbyte airbytehq/terraform-provider-airbyte
    License
    Notes
    This Pulumi package is based on the airbyte Terraform Provider.
    airbyte logo
    Viewing docs for airbyte 1.0.0
    published on Wednesday, Mar 4, 2026 by airbytehq
    Schema (JSON)
    airbytehq/terraform-provider-airbyte
      Try Pulumi Cloud free. Your team will thank you.