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());
    }
}
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:
          allow: {}
          disable: {}
          prefer: {}
          require: {}
          verifyCa:
            caCertificate: '...my_ca_certificate...'
            clientKeyPassword: '...my_client_key_password...'
          verifyFull:
            caCertificate: '...my_ca_certificate...'
            clientCertificate: '...my_client_certificate...'
            clientKey: '...my_client_key...'
            clientKeyPassword: '...my_client_key_password...'
        tunnel_method:
          noTunnel: {}
          passwordAuthentication:
            tunnelHost: '...my_tunnel_host...'
            tunnelPort: 22
            tunnelUser: '...my_tunnel_user...'
            tunnelUserPassword: '...my_tunnel_user_password...'
          sshKeyAuthentication:
            sshKey: '...my_ssh_key...'
            tunnelHost: '...my_tunnel_host...'
            tunnelPort: 22
            tunnelUser: '...my_tunnel_user...'
        unconstrained_number: false
        username: '...my_username...'
      definitionId: 6cc561e7-8b38-4621-919b-0687fe3682b7
      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,
        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",
});
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"),
})
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());
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")
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",
});
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
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
DestinationPostgres Configuration 
- WorkspaceId 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
DestinationPostgres Configuration Args 
- WorkspaceId 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
DestinationPostgres Configuration 
- workspaceId 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
DestinationPostgres Configuration 
- workspaceId 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
DestinationPostgres Configuration Args 
- workspace_id 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 Property Map
- workspaceId 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.
- CreatedAt float64
- DestinationId string
- DestinationType string
- Id string
- The provider-assigned unique ID for this managed resource.
- createdAt Double
- destinationId String
- destinationType String
- id String
- The provider-assigned unique ID for this managed resource.
- createdAt number
- destinationId string
- destinationType string
- id string
- The provider-assigned unique ID for this managed resource.
- created_at float
- destination_id str
- destination_type str
- id str
- The provider-assigned unique ID for this managed resource.
- createdAt Number
- destinationId String
- destinationType String
- id String
- The provider-assigned unique ID for this managed resource.
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,
        workspace_id: Optional[str] = None) -> DestinationPostgresfunc 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.
- Configuration
DestinationPostgres Configuration 
- 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.
- WorkspaceId string
- Configuration
DestinationPostgres Configuration Args 
- 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.
- WorkspaceId string
- configuration
DestinationPostgres Configuration 
- 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.
- workspaceId String
- configuration
DestinationPostgres Configuration 
- 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.
- workspaceId string
- configuration
DestinationPostgres Configuration Args 
- 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.
- 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.
- workspaceId String
Supporting Types
DestinationPostgresConfiguration, DestinationPostgresConfigurationArgs      
- Database string
- Name of the database.
- Host string
- Hostname of the database.
- Username string
- Username to use to access the database.
- DisableType boolDedupe 
- 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
- JdbcUrl stringParams 
- 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
- RawData stringSchema 
- 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 DestinationPostgres Configuration Ssl Mode 
- 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 DestinationPostgres Configuration Tunnel Method 
- 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 string
- Name of the database.
- Host string
- Hostname of the database.
- Username string
- Username to use to access the database.
- DisableType boolDedupe 
- 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
- JdbcUrl stringParams 
- 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
- RawData stringSchema 
- 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 DestinationPostgres Configuration Ssl Mode 
- 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 DestinationPostgres Configuration Tunnel Method 
- 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 String
- Name of the database.
- host String
- Hostname of the database.
- username String
- Username to use to access the database.
- disableType BooleanDedupe 
- 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
- jdbcUrl StringParams 
- 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
- rawData StringSchema 
- 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 DestinationPostgres Configuration Ssl Mode 
- 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 DestinationPostgres Configuration Tunnel Method 
- 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 string
- Name of the database.
- host string
- Hostname of the database.
- username string
- Username to use to access the database.
- disableType booleanDedupe 
- 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
- jdbcUrl stringParams 
- 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
- rawData stringSchema 
- 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 DestinationPostgres Configuration Ssl Mode 
- 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 DestinationPostgres Configuration Tunnel Method 
- 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 str
- Name of the database.
- host str
- Hostname of the database.
- username str
- Username to use to access the database.
- disable_type_ booldedupe 
- 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_ strparams 
- 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_ strschema 
- 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 DestinationPostgres Configuration Ssl Mode 
- 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 DestinationPostgres Configuration Tunnel Method 
- 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 String
- Name of the database.
- host String
- Hostname of the database.
- username String
- Username to use to access the database.
- disableType BooleanDedupe 
- 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
- jdbcUrl StringParams 
- 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
- rawData StringSchema 
- 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
DestinationPostgres Configuration Ssl Mode Allow 
- Allow SSL mode.
- Disable
DestinationPostgres Configuration Ssl Mode Disable 
- Disable SSL.
- Prefer
DestinationPostgres Configuration Ssl Mode Prefer 
- Prefer SSL mode.
- Require
DestinationPostgres Configuration Ssl Mode Require 
- Require SSL mode.
- VerifyCa DestinationPostgres Configuration Ssl Mode Verify Ca 
- Verify-ca SSL mode.
- VerifyFull DestinationPostgres Configuration Ssl Mode Verify Full 
- Verify-full SSL mode.
- Allow
DestinationPostgres Configuration Ssl Mode Allow 
- Allow SSL mode.
- Disable
DestinationPostgres Configuration Ssl Mode Disable 
- Disable SSL.
- Prefer
DestinationPostgres Configuration Ssl Mode Prefer 
- Prefer SSL mode.
- Require
DestinationPostgres Configuration Ssl Mode Require 
- Require SSL mode.
- VerifyCa DestinationPostgres Configuration Ssl Mode Verify Ca 
- Verify-ca SSL mode.
- VerifyFull DestinationPostgres Configuration Ssl Mode Verify Full 
- Verify-full SSL mode.
- allow
DestinationPostgres Configuration Ssl Mode Allow 
- Allow SSL mode.
- disable
DestinationPostgres Configuration Ssl Mode Disable 
- Disable SSL.
- prefer
DestinationPostgres Configuration Ssl Mode Prefer 
- Prefer SSL mode.
- require
DestinationPostgres Configuration Ssl Mode Require 
- Require SSL mode.
- verifyCa DestinationPostgres Configuration Ssl Mode Verify Ca 
- Verify-ca SSL mode.
- verifyFull DestinationPostgres Configuration Ssl Mode Verify Full 
- Verify-full SSL mode.
- allow
DestinationPostgres Configuration Ssl Mode Allow 
- Allow SSL mode.
- disable
DestinationPostgres Configuration Ssl Mode Disable 
- Disable SSL.
- prefer
DestinationPostgres Configuration Ssl Mode Prefer 
- Prefer SSL mode.
- require
DestinationPostgres Configuration Ssl Mode Require 
- Require SSL mode.
- verifyCa DestinationPostgres Configuration Ssl Mode Verify Ca 
- Verify-ca SSL mode.
- verifyFull DestinationPostgres Configuration Ssl Mode Verify Full 
- Verify-full SSL mode.
- allow
DestinationPostgres Configuration Ssl Mode Allow 
- Allow SSL mode.
- disable
DestinationPostgres Configuration Ssl Mode Disable 
- Disable SSL.
- prefer
DestinationPostgres Configuration Ssl Mode Prefer 
- Prefer SSL mode.
- require
DestinationPostgres Configuration Ssl Mode Require 
- Require SSL mode.
- verify_ca DestinationPostgres Configuration Ssl Mode Verify Ca 
- Verify-ca SSL mode.
- verify_full DestinationPostgres Configuration Ssl Mode Verify Full 
- Verify-full SSL mode.
- 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 string
- CA certificate
- ClientKey stringPassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
- CaCertificate string
- CA certificate
- ClientKey stringPassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
- caCertificate String
- CA certificate
- clientKey StringPassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
- caCertificate string
- CA certificate
- clientKey stringPassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
- ca_certificate str
- CA certificate
- client_key_ strpassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
- caCertificate String
- CA certificate
- clientKey StringPassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
DestinationPostgresConfigurationSslModeVerifyFull, DestinationPostgresConfigurationSslModeVerifyFullArgs              
- CaCertificate string
- CA certificate
- ClientCertificate string
- Client certificate
- ClientKey string
- Client key
- ClientKey stringPassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
- CaCertificate string
- CA certificate
- ClientCertificate string
- Client certificate
- ClientKey string
- Client key
- ClientKey stringPassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
- caCertificate String
- CA certificate
- clientCertificate String
- Client certificate
- clientKey String
- Client key
- clientKey StringPassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
- caCertificate string
- CA certificate
- clientCertificate string
- Client certificate
- clientKey string
- Client key
- clientKey stringPassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
- ca_certificate str
- CA certificate
- client_certificate str
- Client certificate
- client_key str
- Client key
- client_key_ strpassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
- caCertificate String
- CA certificate
- clientCertificate String
- Client certificate
- clientKey String
- Client key
- clientKey StringPassword 
- Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
DestinationPostgresConfigurationTunnelMethod, DestinationPostgresConfigurationTunnelMethodArgs          
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
- TunnelUser stringPassword 
- 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 string
- Hostname of the jump server host that allows inbound ssh tunnel.
- TunnelUser string
- OS-level username for logging into the jump server host
- TunnelUser stringPassword 
- 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 String
- Hostname of the jump server host that allows inbound ssh tunnel.
- tunnelUser String
- OS-level username for logging into the jump server host
- tunnelUser StringPassword 
- 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 string
- Hostname of the jump server host that allows inbound ssh tunnel.
- tunnelUser string
- OS-level username for logging into the jump server host
- tunnelUser stringPassword 
- 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 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_ strpassword 
- 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 String
- Hostname of the jump server host that allows inbound ssh tunnel.
- tunnelUser String
- OS-level username for logging into the jump server host
- tunnelUser StringPassword 
- 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 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- tunnelPort Number
- Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
Import
$ 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 airbyteTerraform Provider.