1. Packages
  2. Airbyte Provider
  3. API Docs
  4. DestinationPostgres
airbyte 0.10.0 published on Monday, Apr 14, 2025 by airbytehq

airbyte.DestinationPostgres

Explore with Pulumi AI

DestinationPostgres Resource

Example Usage

Coming soon!
Coming soon!
Coming soon!
Coming soon!
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 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()
                .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(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
                .tunnel_method(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
                .unconstrained_number(false)
                .username("...my_username...")
                .build())
            .definitionId("6cc561e7-8b38-4621-919b-0687fe3682b7")
            .workspaceId("2b2d880a-23fd-4463-8627-0a837b28bb7e")
            .build());

    }
}
Copy
resources:
  myDestinationPostgres:
    type: airbyte:DestinationPostgres
    properties:
      configuration:
        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:
          verifyCa:
            caCertificate: '...my_ca_certificate...'
            clientKeyPassword: '...my_client_key_password...'
        tunnel_method:
          passwordAuthentication:
            tunnelHost: '...my_tunnel_host...'
            tunnelPort: 22
            tunnelUser: '...my_tunnel_user...'
            tunnelUserPassword: '...my_tunnel_user_password...'
        unconstrained_number: false
        username: '...my_username...'
      definitionId: 6cc561e7-8b38-4621-919b-0687fe3682b7
      workspaceId: 2b2d880a-23fd-4463-8627-0a837b28bb7e
Copy

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 This property is required. string
The unique name of the resource.
args This property is required. DestinationPostgresArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name This property is required. str
The unique name of the resource.
args This property is required. 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 This property is required. string
The unique name of the resource.
args This property is required. DestinationPostgresArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name This property is required. string
The unique name of the resource.
args This property is required. DestinationPostgresArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name This property is required. String
The unique name of the resource.
args This property is required. 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,
        JdbcUrlParams = "string",
        Password = "string",
        DropCascade = false,
        RawDataSchema = "string",
        Schema = "string",
        Ssl = false,
        SslMode = new Airbyte.Inputs.DestinationPostgresConfigurationSslModeArgs
        {
            Allow = null,
            Disable = null,
            Prefer = null,
            Require = null,
            VerifyCa = new Airbyte.Inputs.DestinationPostgresConfigurationSslModeVerifyCaArgs
            {
                CaCertificate = "string",
                ClientKeyPassword = "string",
            },
            VerifyFull = new Airbyte.Inputs.DestinationPostgresConfigurationSslModeVerifyFullArgs
            {
                CaCertificate = "string",
                ClientCertificate = "string",
                ClientKey = "string",
                ClientKeyPassword = "string",
            },
        },
        TunnelMethod = new Airbyte.Inputs.DestinationPostgresConfigurationTunnelMethodArgs
        {
            NoTunnel = null,
            PasswordAuthentication = new Airbyte.Inputs.DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs
            {
                TunnelHost = "string",
                TunnelUser = "string",
                TunnelUserPassword = "string",
                TunnelPort = 0,
            },
            SshKeyAuthentication = new Airbyte.Inputs.DestinationPostgresConfigurationTunnelMethodSshKeyAuthenticationArgs
            {
                SshKey = "string",
                TunnelHost = "string",
                TunnelUser = "string",
                TunnelPort = 0,
            },
        },
        UnconstrainedNumber = false,
        DisableTypeDedupe = false,
    },
    WorkspaceId = "string",
    DefinitionId = "string",
    Name = "string",
});
Copy
example, err := airbyte.NewDestinationPostgres(ctx, "destinationPostgresResource", &airbyte.DestinationPostgresArgs{
Configuration: &.DestinationPostgresConfigurationArgs{
Host: pulumi.String("string"),
Username: pulumi.String("string"),
Database: pulumi.String("string"),
Port: pulumi.Float64(0),
JdbcUrlParams: pulumi.String("string"),
Password: pulumi.String("string"),
DropCascade: pulumi.Bool(false),
RawDataSchema: pulumi.String("string"),
Schema: pulumi.String("string"),
Ssl: pulumi.Bool(false),
SslMode: &.DestinationPostgresConfigurationSslModeArgs{
Allow: &.DestinationPostgresConfigurationSslModeAllowArgs{
},
Disable: &.DestinationPostgresConfigurationSslModeDisableArgs{
},
Prefer: &.DestinationPostgresConfigurationSslModePreferArgs{
},
Require: &.DestinationPostgresConfigurationSslModeRequireArgs{
},
VerifyCa: &.DestinationPostgresConfigurationSslModeVerifyCaArgs{
CaCertificate: pulumi.String("string"),
ClientKeyPassword: pulumi.String("string"),
},
VerifyFull: &.DestinationPostgresConfigurationSslModeVerifyFullArgs{
CaCertificate: pulumi.String("string"),
ClientCertificate: pulumi.String("string"),
ClientKey: pulumi.String("string"),
ClientKeyPassword: pulumi.String("string"),
},
},
TunnelMethod: &.DestinationPostgresConfigurationTunnelMethodArgs{
NoTunnel: &.DestinationPostgresConfigurationTunnelMethodNoTunnelArgs{
},
PasswordAuthentication: &.DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs{
TunnelHost: pulumi.String("string"),
TunnelUser: pulumi.String("string"),
TunnelUserPassword: pulumi.String("string"),
TunnelPort: pulumi.Float64(0),
},
SshKeyAuthentication: &.DestinationPostgresConfigurationTunnelMethodSshKeyAuthenticationArgs{
SshKey: pulumi.String("string"),
TunnelHost: pulumi.String("string"),
TunnelUser: pulumi.String("string"),
TunnelPort: pulumi.Float64(0),
},
},
UnconstrainedNumber: pulumi.Bool(false),
DisableTypeDedupe: pulumi.Bool(false),
},
WorkspaceId: pulumi.String("string"),
DefinitionId: pulumi.String("string"),
Name: pulumi.String("string"),
})
Copy
var destinationPostgresResource = new DestinationPostgres("destinationPostgresResource", DestinationPostgresArgs.builder()
    .configuration(DestinationPostgresConfigurationArgs.builder()
        .host("string")
        .username("string")
        .database("string")
        .port(0)
        .jdbcUrlParams("string")
        .password("string")
        .dropCascade(false)
        .rawDataSchema("string")
        .schema("string")
        .ssl(false)
        .sslMode(DestinationPostgresConfigurationSslModeArgs.builder()
            .allow()
            .disable()
            .prefer()
            .require()
            .verifyCa(DestinationPostgresConfigurationSslModeVerifyCaArgs.builder()
                .caCertificate("string")
                .clientKeyPassword("string")
                .build())
            .verifyFull(DestinationPostgresConfigurationSslModeVerifyFullArgs.builder()
                .caCertificate("string")
                .clientCertificate("string")
                .clientKey("string")
                .clientKeyPassword("string")
                .build())
            .build())
        .tunnelMethod(DestinationPostgresConfigurationTunnelMethodArgs.builder()
            .noTunnel()
            .passwordAuthentication(DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs.builder()
                .tunnelHost("string")
                .tunnelUser("string")
                .tunnelUserPassword("string")
                .tunnelPort(0)
                .build())
            .sshKeyAuthentication(DestinationPostgresConfigurationTunnelMethodSshKeyAuthenticationArgs.builder()
                .sshKey("string")
                .tunnelHost("string")
                .tunnelUser("string")
                .tunnelPort(0)
                .build())
            .build())
        .unconstrainedNumber(false)
        .disableTypeDedupe(false)
        .build())
    .workspaceId("string")
    .definitionId("string")
    .name("string")
    .build());
Copy
destination_postgres_resource = airbyte.DestinationPostgres("destinationPostgresResource",
    configuration={
        "host": "string",
        "username": "string",
        "database": "string",
        "port": 0,
        "jdbc_url_params": "string",
        "password": "string",
        "drop_cascade": False,
        "raw_data_schema": "string",
        "schema": "string",
        "ssl": False,
        "ssl_mode": {
            "allow": {},
            "disable": {},
            "prefer": {},
            "require": {},
            "verify_ca": {
                "ca_certificate": "string",
                "client_key_password": "string",
            },
            "verify_full": {
                "ca_certificate": "string",
                "client_certificate": "string",
                "client_key": "string",
                "client_key_password": "string",
            },
        },
        "tunnel_method": {
            "no_tunnel": {},
            "password_authentication": {
                "tunnel_host": "string",
                "tunnel_user": "string",
                "tunnel_user_password": "string",
                "tunnel_port": 0,
            },
            "ssh_key_authentication": {
                "ssh_key": "string",
                "tunnel_host": "string",
                "tunnel_user": "string",
                "tunnel_port": 0,
            },
        },
        "unconstrained_number": False,
        "disable_type_dedupe": False,
    },
    workspace_id="string",
    definition_id="string",
    name="string")
Copy
const destinationPostgresResource = new airbyte.DestinationPostgres("destinationPostgresResource", {
    configuration: {
        host: "string",
        username: "string",
        database: "string",
        port: 0,
        jdbcUrlParams: "string",
        password: "string",
        dropCascade: false,
        rawDataSchema: "string",
        schema: "string",
        ssl: false,
        sslMode: {
            allow: {},
            disable: {},
            prefer: {},
            require: {},
            verifyCa: {
                caCertificate: "string",
                clientKeyPassword: "string",
            },
            verifyFull: {
                caCertificate: "string",
                clientCertificate: "string",
                clientKey: "string",
                clientKeyPassword: "string",
            },
        },
        tunnelMethod: {
            noTunnel: {},
            passwordAuthentication: {
                tunnelHost: "string",
                tunnelUser: "string",
                tunnelUserPassword: "string",
                tunnelPort: 0,
            },
            sshKeyAuthentication: {
                sshKey: "string",
                tunnelHost: "string",
                tunnelUser: "string",
                tunnelPort: 0,
            },
        },
        unconstrainedNumber: false,
        disableTypeDedupe: false,
    },
    workspaceId: "string",
    definitionId: "string",
    name: "string",
});
Copy
type: airbyte:DestinationPostgres
properties:
    configuration:
        database: string
        disableTypeDedupe: false
        dropCascade: false
        host: string
        jdbcUrlParams: string
        password: string
        port: 0
        rawDataSchema: string
        schema: string
        ssl: false
        sslMode:
            allow: {}
            disable: {}
            prefer: {}
            require: {}
            verifyCa:
                caCertificate: string
                clientKeyPassword: string
            verifyFull:
                caCertificate: string
                clientCertificate: string
                clientKey: string
                clientKeyPassword: string
        tunnelMethod:
            noTunnel: {}
            passwordAuthentication:
                tunnelHost: string
                tunnelPort: 0
                tunnelUser: string
                tunnelUserPassword: string
            sshKeyAuthentication:
                sshKey: string
                tunnelHost: string
                tunnelPort: 0
                tunnelUser: string
        unconstrainedNumber: false
        username: string
    definitionId: string
    name: string
    workspaceId: string
Copy

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 This property is required. DestinationPostgresConfiguration
WorkspaceId This property is required. string
DefinitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
Name string
Name of the destination e.g. dev-mysql-instance.
Configuration This property is required. DestinationPostgresConfigurationArgs
WorkspaceId This property is required. string
DefinitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
Name string
Name of the destination e.g. dev-mysql-instance.
configuration This property is required. DestinationPostgresConfiguration
workspaceId This property is required. String
definitionId String
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
name String
Name of the destination e.g. dev-mysql-instance.
configuration This property is required. DestinationPostgresConfiguration
workspaceId This property is required. string
definitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
name string
Name of the destination e.g. dev-mysql-instance.
configuration This property is required. DestinationPostgresConfigurationArgs
workspace_id This property is required. str
definition_id str
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
name str
Name of the destination e.g. dev-mysql-instance.
configuration This property is required. Property Map
workspaceId This property is required. String
definitionId String
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. 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 This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
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
CreatedAt double
DefinitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. 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
CreatedAt float64
DefinitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. 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
createdAt Double
definitionId String
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. 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
createdAt number
definitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. 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
created_at float
definition_id str
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. 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
createdAt Number
definitionId String
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. 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 This property is required. string
Name of the database.
Host This property is required. string
Hostname of the database.
Username This property is required. string
Username to use to access the database.
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. Default: false
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. Default: false
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.
Port double
Port of the database. Default: 5432
RawDataSchema string
The schema to write raw tables into
Schema string
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
Ssl bool
Encrypt data using SSL. When activating SSL, please select one of the connection modes. Default: false
SslMode DestinationPostgresConfigurationSslMode
SSL connection modes. \n\ndisable\n\n - Chose this mode to disable encryption of communication between Airbyte and destination database \n\nallow\n\n - Chose this mode to enable encryption only when required by the source database \n\nprefer\n\n - Chose this mode to allow unencrypted connection only if the source database does not support encryption \n\nrequire\n\n - Chose this mode to always require encryption. If the source database server does not support encryption, connection will fail \n\nverify-ca\n\n - Chose this mode to always require encryption and to verify that the source database server has a valid SSL certificate \n\nverify-full\n\n - This is the most secure mode. Chose this mode to always require encryption and to verify the identity of the source 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). Default: false
Database This property is required. string
Name of the database.
Host This property is required. string
Hostname of the database.
Username This property is required. string
Username to use to access the database.
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. Default: false
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. Default: false
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.
Port float64
Port of the database. Default: 5432
RawDataSchema string
The schema to write raw tables into
Schema string
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
Ssl bool
Encrypt data using SSL. When activating SSL, please select one of the connection modes. Default: false
SslMode DestinationPostgresConfigurationSslMode
SSL connection modes. \n\ndisable\n\n - Chose this mode to disable encryption of communication between Airbyte and destination database \n\nallow\n\n - Chose this mode to enable encryption only when required by the source database \n\nprefer\n\n - Chose this mode to allow unencrypted connection only if the source database does not support encryption \n\nrequire\n\n - Chose this mode to always require encryption. If the source database server does not support encryption, connection will fail \n\nverify-ca\n\n - Chose this mode to always require encryption and to verify that the source database server has a valid SSL certificate \n\nverify-full\n\n - This is the most secure mode. Chose this mode to always require encryption and to verify the identity of the source 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). Default: false
database This property is required. String
Name of the database.
host This property is required. String
Hostname of the database.
username This property is required. String
Username to use to access the database.
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. Default: false
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. Default: false
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.
port Double
Port of the database. Default: 5432
rawDataSchema String
The schema to write raw tables into
schema String
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
ssl Boolean
Encrypt data using SSL. When activating SSL, please select one of the connection modes. Default: false
sslMode DestinationPostgresConfigurationSslMode
SSL connection modes. \n\ndisable\n\n - Chose this mode to disable encryption of communication between Airbyte and destination database \n\nallow\n\n - Chose this mode to enable encryption only when required by the source database \n\nprefer\n\n - Chose this mode to allow unencrypted connection only if the source database does not support encryption \n\nrequire\n\n - Chose this mode to always require encryption. If the source database server does not support encryption, connection will fail \n\nverify-ca\n\n - Chose this mode to always require encryption and to verify that the source database server has a valid SSL certificate \n\nverify-full\n\n - This is the most secure mode. Chose this mode to always require encryption and to verify the identity of the source 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). Default: false
database This property is required. string
Name of the database.
host This property is required. string
Hostname of the database.
username This property is required. string
Username to use to access the database.
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. Default: false
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. Default: false
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.
port number
Port of the database. Default: 5432
rawDataSchema string
The schema to write raw tables into
schema string
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
ssl boolean
Encrypt data using SSL. When activating SSL, please select one of the connection modes. Default: false
sslMode DestinationPostgresConfigurationSslMode
SSL connection modes. \n\ndisable\n\n - Chose this mode to disable encryption of communication between Airbyte and destination database \n\nallow\n\n - Chose this mode to enable encryption only when required by the source database \n\nprefer\n\n - Chose this mode to allow unencrypted connection only if the source database does not support encryption \n\nrequire\n\n - Chose this mode to always require encryption. If the source database server does not support encryption, connection will fail \n\nverify-ca\n\n - Chose this mode to always require encryption and to verify that the source database server has a valid SSL certificate \n\nverify-full\n\n - This is the most secure mode. Chose this mode to always require encryption and to verify the identity of the source 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). Default: false
database This property is required. str
Name of the database.
host This property is required. str
Hostname of the database.
username This property is required. str
Username to use to access the database.
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. Default: false
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. Default: false
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.
port float
Port of the database. Default: 5432
raw_data_schema str
The schema to write raw tables into
schema str
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
ssl bool
Encrypt data using SSL. When activating SSL, please select one of the connection modes. Default: false
ssl_mode DestinationPostgresConfigurationSslMode
SSL connection modes. \n\ndisable\n\n - Chose this mode to disable encryption of communication between Airbyte and destination database \n\nallow\n\n - Chose this mode to enable encryption only when required by the source database \n\nprefer\n\n - Chose this mode to allow unencrypted connection only if the source database does not support encryption \n\nrequire\n\n - Chose this mode to always require encryption. If the source database server does not support encryption, connection will fail \n\nverify-ca\n\n - Chose this mode to always require encryption and to verify that the source database server has a valid SSL certificate \n\nverify-full\n\n - This is the most secure mode. Chose this mode to always require encryption and to verify the identity of the source 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). Default: false
database This property is required. String
Name of the database.
host This property is required. String
Hostname of the database.
username This property is required. String
Username to use to access the database.
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. Default: false
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. Default: false
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.
port Number
Port of the database. Default: 5432
rawDataSchema String
The schema to write raw tables into
schema String
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
ssl Boolean
Encrypt data using SSL. When activating SSL, please select one of the connection modes. Default: false
sslMode Property Map
SSL connection modes. \n\ndisable\n\n - Chose this mode to disable encryption of communication between Airbyte and destination database \n\nallow\n\n - Chose this mode to enable encryption only when required by the source database \n\nprefer\n\n - Chose this mode to allow unencrypted connection only if the source database does not support encryption \n\nrequire\n\n - Chose this mode to always require encryption. If the source database server does not support encryption, connection will fail \n\nverify-ca\n\n - Chose this mode to always require encryption and to verify that the source database server has a valid SSL certificate \n\nverify-full\n\n - This is the most secure mode. Chose this mode to always require encryption and to verify the identity of the source 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). Default: false

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.

DestinationPostgresConfigurationSslModeVerifyCa
, DestinationPostgresConfigurationSslModeVerifyCaArgs

CaCertificate This property is required. string
CA certificate
ClientKeyPassword string
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
CaCertificate This property is required. string
CA certificate
ClientKeyPassword string
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
caCertificate This property is required. String
CA certificate
clientKeyPassword String
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
caCertificate This property is required. string
CA certificate
clientKeyPassword string
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
ca_certificate This property is required. str
CA certificate
client_key_password str
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
caCertificate This property is required. String
CA certificate
clientKeyPassword String
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.

DestinationPostgresConfigurationSslModeVerifyFull
, DestinationPostgresConfigurationSslModeVerifyFullArgs

CaCertificate This property is required. string
CA certificate
ClientCertificate This property is required. string
Client certificate
ClientKey This property is required. string
Client key
ClientKeyPassword string
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
CaCertificate This property is required. string
CA certificate
ClientCertificate This property is required. string
Client certificate
ClientKey This property is required. string
Client key
ClientKeyPassword string
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
caCertificate This property is required. String
CA certificate
clientCertificate This property is required. String
Client certificate
clientKey This property is required. String
Client key
clientKeyPassword String
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
caCertificate This property is required. string
CA certificate
clientCertificate This property is required. string
Client certificate
clientKey This property is required. string
Client key
clientKeyPassword string
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
ca_certificate This property is required. str
CA certificate
client_certificate This property is required. str
Client certificate
client_key This property is required. str
Client key
client_key_password str
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
caCertificate This property is required. String
CA certificate
clientCertificate This property is required. String
Client certificate
clientKey This property is required. String
Client key
clientKeyPassword String
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.

DestinationPostgresConfigurationTunnelMethod
, DestinationPostgresConfigurationTunnelMethodArgs

DestinationPostgresConfigurationTunnelMethodPasswordAuthentication
, DestinationPostgresConfigurationTunnelMethodPasswordAuthenticationArgs

TunnelHost This property is required. string
Hostname of the jump server host that allows inbound ssh tunnel.
TunnelUser This property is required. string
OS-level username for logging into the jump server host
TunnelUserPassword This property is required. string
OS-level password for logging into the jump server host
TunnelPort double
Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
TunnelHost This property is required. string
Hostname of the jump server host that allows inbound ssh tunnel.
TunnelUser This property is required. string
OS-level username for logging into the jump server host
TunnelUserPassword This property is required. string
OS-level password for logging into the jump server host
TunnelPort float64
Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
tunnelHost This property is required. String
Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser This property is required. String
OS-level username for logging into the jump server host
tunnelUserPassword This property is required. String
OS-level password for logging into the jump server host
tunnelPort Double
Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
tunnelHost This property is required. string
Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser This property is required. string
OS-level username for logging into the jump server host
tunnelUserPassword This property is required. string
OS-level password for logging into the jump server host
tunnelPort number
Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
tunnel_host This property is required. str
Hostname of the jump server host that allows inbound ssh tunnel.
tunnel_user This property is required. str
OS-level username for logging into the jump server host
tunnel_user_password This property is required. str
OS-level password for logging into the jump server host
tunnel_port float
Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
tunnelHost This property is required. String
Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser This property is required. String
OS-level username for logging into the jump server host
tunnelUserPassword This property is required. String
OS-level password for logging into the jump server host
tunnelPort Number
Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

DestinationPostgresConfigurationTunnelMethodSshKeyAuthentication
, DestinationPostgresConfigurationTunnelMethodSshKeyAuthenticationArgs

SshKey This property is required. string
OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
TunnelHost This property is required. string
Hostname of the jump server host that allows inbound ssh tunnel.
TunnelUser This property is required. string
OS-level username for logging into the jump server host.
TunnelPort double
Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
SshKey This property is required. string
OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
TunnelHost This property is required. string
Hostname of the jump server host that allows inbound ssh tunnel.
TunnelUser This property is required. string
OS-level username for logging into the jump server host.
TunnelPort float64
Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
sshKey This property is required. String
OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
tunnelHost This property is required. String
Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser This property is required. String
OS-level username for logging into the jump server host.
tunnelPort Double
Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
sshKey This property is required. string
OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
tunnelHost This property is required. string
Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser This property is required. string
OS-level username for logging into the jump server host.
tunnelPort number
Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
ssh_key This property is required. 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 This property is required. str
Hostname of the jump server host that allows inbound ssh tunnel.
tunnel_user This property is required. str
OS-level username for logging into the jump server host.
tunnel_port float
Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
sshKey This property is required. String
OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
tunnelHost This property is required. String
Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser This property is required. String
OS-level username for logging into the jump server host.
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. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
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. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
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. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
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. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
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. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
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. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
resourceRequirements Property Map
optional resource requirements to run workers (blank for unbounded allocations)

DestinationPostgresResourceAllocationJobSpecificResourceRequirements
, DestinationPostgresResourceAllocationJobSpecificResourceRequirementsArgs

Import

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

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.