airbyte.SourcePostgres

Coming soon!

Coming soon!

Coming soon!

Coming soon!

name string

The unique name of the resource.

args SourcePostgresArgs

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 SourcePostgresArgs

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 SourcePostgresArgs

The arguments to resource properties.

opts ResourceOption

Bag of options to control resource's behavior.

name string

The unique name of the resource.

args SourcePostgresArgs

The arguments to resource properties.

opts CustomResourceOptions

Bag of options to control resource's behavior.

name String

The unique name of the resource.

args SourcePostgresArgs

The arguments to resource properties.

options CustomResourceOptions

Bag of options to control resource's behavior.

Configuration SourcePostgresConfiguration

WorkspaceId string

DefinitionId string

The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.

Name string

Name of the source e.g. dev-mysql-instance.

SecretId string

Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.

Configuration SourcePostgresConfigurationArgs

WorkspaceId string

DefinitionId string

The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.

Name string

Name of the source e.g. dev-mysql-instance.

SecretId string

Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.

configuration SourcePostgresConfiguration

workspaceId String

definitionId String

The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.

name String

Name of the source e.g. dev-mysql-instance.

secretId String

Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.

configuration SourcePostgresConfiguration

workspaceId string

definitionId string

The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.

name string

Name of the source e.g. dev-mysql-instance.

secretId string

Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.

configuration SourcePostgresConfigurationArgs

workspace_id str

definition_id str

The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.

name str

Name of the source e.g. dev-mysql-instance.

secret_id str

Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.

configuration Property Map

workspaceId String

definitionId String

The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.

name String

Name of the source e.g. dev-mysql-instance.

secretId String

Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.

CreatedAt double

Id string

The provider-assigned unique ID for this managed resource.

ResourceAllocation SourcePostgresResourceAllocation

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.

SourceId string

SourceType string

CreatedAt float64

Id string

The provider-assigned unique ID for this managed resource.

ResourceAllocation SourcePostgresResourceAllocation

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.

SourceId string

SourceType string

createdAt Double

id String

The provider-assigned unique ID for this managed resource.

resourceAllocation SourcePostgresResourceAllocation

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.

sourceId String

sourceType String

createdAt number

id string

The provider-assigned unique ID for this managed resource.

resourceAllocation SourcePostgresResourceAllocation

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.

sourceId string

sourceType string

created_at float

id str

The provider-assigned unique ID for this managed resource.

resource_allocation SourcePostgresResourceAllocation

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.

source_id str

source_type str

createdAt Number

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.

sourceId String

sourceType String

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.

Database string

Name of the database.

Host string

Hostname of the database.

Username string

Username to access the database.

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 '&'. (Eg. key1=value1&key2=value2&key3=value3). For more information read about \n\nJDBC URL parameters\n\n.

Password string

Password associated with the username.

Port double

Port of the database. Default: 5432

ReplicationMethod SourcePostgresConfigurationReplicationMethod

Configures how data is extracted from the database.

Schemas List<string>

The list of schemas (case sensitive) to sync from. Defaults to public.

SslMode SourcePostgresConfigurationSslMode

SSL connection modes. Read more \n\n in the docs\n\n.

TunnelMethod SourcePostgresConfigurationTunnelMethod

Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

Database string

Name of the database.

Host string

Hostname of the database.

Username string

Username to access the database.

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 '&'. (Eg. key1=value1&key2=value2&key3=value3). For more information read about \n\nJDBC URL parameters\n\n.

Password string

Password associated with the username.

Port float64

Port of the database. Default: 5432

ReplicationMethod SourcePostgresConfigurationReplicationMethod

Configures how data is extracted from the database.

Schemas []string

The list of schemas (case sensitive) to sync from. Defaults to public.

SslMode SourcePostgresConfigurationSslMode

SSL connection modes. Read more \n\n in the docs\n\n.

TunnelMethod SourcePostgresConfigurationTunnelMethod

Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

database String

Name of the database.

host String

Hostname of the database.

username String

Username to access the database.

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 '&'. (Eg. key1=value1&key2=value2&key3=value3). For more information read about \n\nJDBC URL parameters\n\n.

password String

Password associated with the username.

port Double

Port of the database. Default: 5432

replicationMethod SourcePostgresConfigurationReplicationMethod

Configures how data is extracted from the database.

schemas List<String>

The list of schemas (case sensitive) to sync from. Defaults to public.

sslMode SourcePostgresConfigurationSslMode

SSL connection modes. Read more \n\n in the docs\n\n.

tunnelMethod SourcePostgresConfigurationTunnelMethod

Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

database string

Name of the database.

host string

Hostname of the database.

username string

Username to access the database.

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 '&'. (Eg. key1=value1&key2=value2&key3=value3). For more information read about \n\nJDBC URL parameters\n\n.

password string

Password associated with the username.

port number

Port of the database. Default: 5432

replicationMethod SourcePostgresConfigurationReplicationMethod

Configures how data is extracted from the database.

schemas string[]

The list of schemas (case sensitive) to sync from. Defaults to public.

sslMode SourcePostgresConfigurationSslMode

SSL connection modes. Read more \n\n in the docs\n\n.

tunnelMethod SourcePostgresConfigurationTunnelMethod

Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

database str

Name of the database.

host str

Hostname of the database.

username str

Username to access the database.

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 '&'. (Eg. key1=value1&key2=value2&key3=value3). For more information read about \n\nJDBC URL parameters\n\n.

password str

Password associated with the username.

port float

Port of the database. Default: 5432

replication_method SourcePostgresConfigurationReplicationMethod

Configures how data is extracted from the database.

schemas Sequence[str]

The list of schemas (case sensitive) to sync from. Defaults to public.

ssl_mode SourcePostgresConfigurationSslMode

SSL connection modes. Read more \n\n in the docs\n\n.

tunnel_method SourcePostgresConfigurationTunnelMethod

Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

database String

Name of the database.

host String

Hostname of the database.

username String

Username to access the database.

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 '&'. (Eg. key1=value1&key2=value2&key3=value3). For more information read about \n\nJDBC URL parameters\n\n.

password String

Password associated with the username.

port Number

Port of the database. Default: 5432

replicationMethod Property Map

Configures how data is extracted from the database.

schemas List<String>

The list of schemas (case sensitive) to sync from. Defaults to public.

sslMode Property Map

SSL connection modes. Read more \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.

DetectChangesWithXminSystemColumn SourcePostgresConfigurationReplicationMethodDetectChangesWithXminSystemColumn

\n\nRecommended\n\n - Incrementally reads new inserts and updates via Postgres \n\nXmin system column\n\n. Suitable for databases that have low transaction pressure.

ReadChangesUsingWriteAheadLogCdc SourcePostgresConfigurationReplicationMethodReadChangesUsingWriteAheadLogCdc

\n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using the Postgres \n\nwrite-ahead log (WAL)\n\n. This needs to be configured on the source database itself. Recommended for tables of any size.

ScanChangesWithUserDefinedCursor SourcePostgresConfigurationReplicationMethodScanChangesWithUserDefinedCursor

Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).

DetectChangesWithXminSystemColumn SourcePostgresConfigurationReplicationMethodDetectChangesWithXminSystemColumn

\n\nRecommended\n\n - Incrementally reads new inserts and updates via Postgres \n\nXmin system column\n\n. Suitable for databases that have low transaction pressure.

ReadChangesUsingWriteAheadLogCdc SourcePostgresConfigurationReplicationMethodReadChangesUsingWriteAheadLogCdc

\n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using the Postgres \n\nwrite-ahead log (WAL)\n\n. This needs to be configured on the source database itself. Recommended for tables of any size.

ScanChangesWithUserDefinedCursor SourcePostgresConfigurationReplicationMethodScanChangesWithUserDefinedCursor

Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).

detectChangesWithXminSystemColumn SourcePostgresConfigurationReplicationMethodDetectChangesWithXminSystemColumn

\n\nRecommended\n\n - Incrementally reads new inserts and updates via Postgres \n\nXmin system column\n\n. Suitable for databases that have low transaction pressure.

readChangesUsingWriteAheadLogCdc SourcePostgresConfigurationReplicationMethodReadChangesUsingWriteAheadLogCdc

\n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using the Postgres \n\nwrite-ahead log (WAL)\n\n. This needs to be configured on the source database itself. Recommended for tables of any size.

scanChangesWithUserDefinedCursor SourcePostgresConfigurationReplicationMethodScanChangesWithUserDefinedCursor

Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).

detectChangesWithXminSystemColumn SourcePostgresConfigurationReplicationMethodDetectChangesWithXminSystemColumn

\n\nRecommended\n\n - Incrementally reads new inserts and updates via Postgres \n\nXmin system column\n\n. Suitable for databases that have low transaction pressure.

readChangesUsingWriteAheadLogCdc SourcePostgresConfigurationReplicationMethodReadChangesUsingWriteAheadLogCdc

\n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using the Postgres \n\nwrite-ahead log (WAL)\n\n. This needs to be configured on the source database itself. Recommended for tables of any size.

scanChangesWithUserDefinedCursor SourcePostgresConfigurationReplicationMethodScanChangesWithUserDefinedCursor

Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).

detect_changes_with_xmin_system_column SourcePostgresConfigurationReplicationMethodDetectChangesWithXminSystemColumn

\n\nRecommended\n\n - Incrementally reads new inserts and updates via Postgres \n\nXmin system column\n\n. Suitable for databases that have low transaction pressure.

read_changes_using_write_ahead_log_cdc SourcePostgresConfigurationReplicationMethodReadChangesUsingWriteAheadLogCdc

\n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using the Postgres \n\nwrite-ahead log (WAL)\n\n. This needs to be configured on the source database itself. Recommended for tables of any size.

scan_changes_with_user_defined_cursor SourcePostgresConfigurationReplicationMethodScanChangesWithUserDefinedCursor

Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).

detectChangesWithXminSystemColumn Property Map

\n\nRecommended\n\n - Incrementally reads new inserts and updates via Postgres \n\nXmin system column\n\n. Suitable for databases that have low transaction pressure.

readChangesUsingWriteAheadLogCdc Property Map

\n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using the Postgres \n\nwrite-ahead log (WAL)\n\n. This needs to be configured on the source database itself. Recommended for tables of any size.

scanChangesWithUserDefinedCursor Property Map

Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).

Publication string

A Postgres publication used for consuming changes. Read about \n\npublications and replication identities\n\n.

ReplicationSlot string

A plugin logical replication slot. Read about \n\nreplication slots\n\n.

AdditionalProperties string

Parsed as JSON.

HeartbeatActionQuery string

Specifies a query that the connector executes on the source database when the connector sends a heartbeat message. Please see the \n\nsetup guide\n\n for how and when to configure this setting. Default: ""

InitialLoadTimeoutHours double

The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8

InitialWaitingSeconds double

The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 1200 seconds. Valid range: 120 seconds to 2400 seconds. Read about \n\ninitial waiting time\n\n. Default: 1200

InvalidCdcCursorPositionBehavior string

Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value into the WAL. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]

LsnCommitBehaviour string

Determines when Airbyte should flush the LSN of processed WAL logs in the source database. After loading Data in the destination is default. If While reading Data is selected, in case of a downstream failure (while loading data into the destination), next sync would result in a full sync. Default: "After loading Data in the destination"; must be one of ["While reading Data", "After loading Data in the destination"]

Plugin string

A logical decoding plugin installed on the PostgreSQL server. Default: "pgoutput"; must be "pgoutput"

QueueSize double

The size of the internal queue. This may interfere with memory consumption and efficiency of the connector, please be careful. Default: 10000

Publication string

A Postgres publication used for consuming changes. Read about \n\npublications and replication identities\n\n.

ReplicationSlot string

A plugin logical replication slot. Read about \n\nreplication slots\n\n.

AdditionalProperties string

Parsed as JSON.

HeartbeatActionQuery string

Specifies a query that the connector executes on the source database when the connector sends a heartbeat message. Please see the \n\nsetup guide\n\n for how and when to configure this setting. Default: ""

InitialLoadTimeoutHours float64

The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8

InitialWaitingSeconds float64

The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 1200 seconds. Valid range: 120 seconds to 2400 seconds. Read about \n\ninitial waiting time\n\n. Default: 1200

InvalidCdcCursorPositionBehavior string

Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value into the WAL. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]

LsnCommitBehaviour string

Determines when Airbyte should flush the LSN of processed WAL logs in the source database. After loading Data in the destination is default. If While reading Data is selected, in case of a downstream failure (while loading data into the destination), next sync would result in a full sync. Default: "After loading Data in the destination"; must be one of ["While reading Data", "After loading Data in the destination"]

Plugin string

A logical decoding plugin installed on the PostgreSQL server. Default: "pgoutput"; must be "pgoutput"

QueueSize float64

The size of the internal queue. This may interfere with memory consumption and efficiency of the connector, please be careful. Default: 10000

publication String

A Postgres publication used for consuming changes. Read about \n\npublications and replication identities\n\n.

replicationSlot String

A plugin logical replication slot. Read about \n\nreplication slots\n\n.

additionalProperties String

Parsed as JSON.

heartbeatActionQuery String

Specifies a query that the connector executes on the source database when the connector sends a heartbeat message. Please see the \n\nsetup guide\n\n for how and when to configure this setting. Default: ""

initialLoadTimeoutHours Double

The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8

initialWaitingSeconds Double

The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 1200 seconds. Valid range: 120 seconds to 2400 seconds. Read about \n\ninitial waiting time\n\n. Default: 1200

invalidCdcCursorPositionBehavior String

Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value into the WAL. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]

lsnCommitBehaviour String

Determines when Airbyte should flush the LSN of processed WAL logs in the source database. After loading Data in the destination is default. If While reading Data is selected, in case of a downstream failure (while loading data into the destination), next sync would result in a full sync. Default: "After loading Data in the destination"; must be one of ["While reading Data", "After loading Data in the destination"]

plugin String

A logical decoding plugin installed on the PostgreSQL server. Default: "pgoutput"; must be "pgoutput"

queueSize Double

The size of the internal queue. This may interfere with memory consumption and efficiency of the connector, please be careful. Default: 10000

publication string

A Postgres publication used for consuming changes. Read about \n\npublications and replication identities\n\n.

replicationSlot string

A plugin logical replication slot. Read about \n\nreplication slots\n\n.

additionalProperties string

Parsed as JSON.

heartbeatActionQuery string

Specifies a query that the connector executes on the source database when the connector sends a heartbeat message. Please see the \n\nsetup guide\n\n for how and when to configure this setting. Default: ""

initialLoadTimeoutHours number

The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8

initialWaitingSeconds number

The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 1200 seconds. Valid range: 120 seconds to 2400 seconds. Read about \n\ninitial waiting time\n\n. Default: 1200

invalidCdcCursorPositionBehavior string

Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value into the WAL. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]

lsnCommitBehaviour string

Determines when Airbyte should flush the LSN of processed WAL logs in the source database. After loading Data in the destination is default. If While reading Data is selected, in case of a downstream failure (while loading data into the destination), next sync would result in a full sync. Default: "After loading Data in the destination"; must be one of ["While reading Data", "After loading Data in the destination"]

plugin string

A logical decoding plugin installed on the PostgreSQL server. Default: "pgoutput"; must be "pgoutput"

queueSize number

The size of the internal queue. This may interfere with memory consumption and efficiency of the connector, please be careful. Default: 10000

publication str

A Postgres publication used for consuming changes. Read about \n\npublications and replication identities\n\n.

replication_slot str

A plugin logical replication slot. Read about \n\nreplication slots\n\n.

additional_properties str

Parsed as JSON.

heartbeat_action_query str

Specifies a query that the connector executes on the source database when the connector sends a heartbeat message. Please see the \n\nsetup guide\n\n for how and when to configure this setting. Default: ""

initial_load_timeout_hours float

The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8

initial_waiting_seconds float

The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 1200 seconds. Valid range: 120 seconds to 2400 seconds. Read about \n\ninitial waiting time\n\n. Default: 1200

invalid_cdc_cursor_position_behavior str

Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value into the WAL. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]

lsn_commit_behaviour str

Determines when Airbyte should flush the LSN of processed WAL logs in the source database. After loading Data in the destination is default. If While reading Data is selected, in case of a downstream failure (while loading data into the destination), next sync would result in a full sync. Default: "After loading Data in the destination"; must be one of ["While reading Data", "After loading Data in the destination"]

plugin str

A logical decoding plugin installed on the PostgreSQL server. Default: "pgoutput"; must be "pgoutput"

queue_size float

The size of the internal queue. This may interfere with memory consumption and efficiency of the connector, please be careful. Default: 10000

publication String

A Postgres publication used for consuming changes. Read about \n\npublications and replication identities\n\n.

replicationSlot String

A plugin logical replication slot. Read about \n\nreplication slots\n\n.

additionalProperties String

Parsed as JSON.

heartbeatActionQuery String

Specifies a query that the connector executes on the source database when the connector sends a heartbeat message. Please see the \n\nsetup guide\n\n for how and when to configure this setting. Default: ""

initialLoadTimeoutHours Number

The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8

initialWaitingSeconds Number

The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 1200 seconds. Valid range: 120 seconds to 2400 seconds. Read about \n\ninitial waiting time\n\n. Default: 1200

invalidCdcCursorPositionBehavior String

Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value into the WAL. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]

lsnCommitBehaviour String

Determines when Airbyte should flush the LSN of processed WAL logs in the source database. After loading Data in the destination is default. If While reading Data is selected, in case of a downstream failure (while loading data into the destination), next sync would result in a full sync. Default: "After loading Data in the destination"; must be one of ["While reading Data", "After loading Data in the destination"]

plugin String

A logical decoding plugin installed on the PostgreSQL server. Default: "pgoutput"; must be "pgoutput"

queueSize Number

The size of the internal queue. This may interfere with memory consumption and efficiency of the connector, please be careful. Default: 10000

Allow SourcePostgresConfigurationSslModeAllow

Enables encryption only when required by the source database.

Disable SourcePostgresConfigurationSslModeDisable

Disables encryption of communication between Airbyte and source database.

Prefer SourcePostgresConfigurationSslModePrefer

Allows unencrypted connection only if the source database does not support encryption.

Require SourcePostgresConfigurationSslModeRequire

Always require encryption. If the source database server does not support encryption, connection will fail.

VerifyCa SourcePostgresConfigurationSslModeVerifyCa

Always require encryption and verifies that the source database server has a valid SSL certificate.

VerifyFull SourcePostgresConfigurationSslModeVerifyFull

This is the most secure mode. Always require encryption and verifies the identity of the source database server.

Allow SourcePostgresConfigurationSslModeAllow

Enables encryption only when required by the source database.

Disable SourcePostgresConfigurationSslModeDisable

Disables encryption of communication between Airbyte and source database.

Prefer SourcePostgresConfigurationSslModePrefer

Allows unencrypted connection only if the source database does not support encryption.

Require SourcePostgresConfigurationSslModeRequire

Always require encryption. If the source database server does not support encryption, connection will fail.

VerifyCa SourcePostgresConfigurationSslModeVerifyCa

Always require encryption and verifies that the source database server has a valid SSL certificate.

VerifyFull SourcePostgresConfigurationSslModeVerifyFull

This is the most secure mode. Always require encryption and verifies the identity of the source database server.

allow SourcePostgresConfigurationSslModeAllow

Enables encryption only when required by the source database.

disable SourcePostgresConfigurationSslModeDisable

Disables encryption of communication between Airbyte and source database.

prefer SourcePostgresConfigurationSslModePrefer

Allows unencrypted connection only if the source database does not support encryption.

require SourcePostgresConfigurationSslModeRequire

Always require encryption. If the source database server does not support encryption, connection will fail.

verifyCa SourcePostgresConfigurationSslModeVerifyCa

Always require encryption and verifies that the source database server has a valid SSL certificate.

verifyFull SourcePostgresConfigurationSslModeVerifyFull

This is the most secure mode. Always require encryption and verifies the identity of the source database server.

allow SourcePostgresConfigurationSslModeAllow

Enables encryption only when required by the source database.

disable SourcePostgresConfigurationSslModeDisable

Disables encryption of communication between Airbyte and source database.

prefer SourcePostgresConfigurationSslModePrefer

Allows unencrypted connection only if the source database does not support encryption.

require SourcePostgresConfigurationSslModeRequire

Always require encryption. If the source database server does not support encryption, connection will fail.

verifyCa SourcePostgresConfigurationSslModeVerifyCa

Always require encryption and verifies that the source database server has a valid SSL certificate.

verifyFull SourcePostgresConfigurationSslModeVerifyFull

This is the most secure mode. Always require encryption and verifies the identity of the source database server.

allow SourcePostgresConfigurationSslModeAllow

Enables encryption only when required by the source database.

disable SourcePostgresConfigurationSslModeDisable

Disables encryption of communication between Airbyte and source database.

prefer SourcePostgresConfigurationSslModePrefer

Allows unencrypted connection only if the source database does not support encryption.

require SourcePostgresConfigurationSslModeRequire

Always require encryption. If the source database server does not support encryption, connection will fail.

verify_ca SourcePostgresConfigurationSslModeVerifyCa

Always require encryption and verifies that the source database server has a valid SSL certificate.

verify_full SourcePostgresConfigurationSslModeVerifyFull

This is the most secure mode. Always require encryption and verifies the identity of the source database server.

allow Property Map

Enables encryption only when required by the source database.

disable Property Map

Disables encryption of communication between Airbyte and source database.

prefer Property Map

Allows unencrypted connection only if the source database does not support encryption.

require Property Map

Always require encryption. If the source database server does not support encryption, connection will fail.

verifyCa Property Map

Always require encryption and verifies that the source database server has a valid SSL certificate.

verifyFull Property Map

This is the most secure mode. Always require encryption and verifies the identity of the source database server.

AdditionalProperties string

Parsed as JSON.

AdditionalProperties string

Parsed as JSON.

additionalProperties String

Parsed as JSON.

additionalProperties string

Parsed as JSON.

additional_properties str

Parsed as JSON.

additionalProperties String

Parsed as JSON.

AdditionalProperties string

Parsed as JSON.

AdditionalProperties string

Parsed as JSON.

additionalProperties String

Parsed as JSON.

additionalProperties string

Parsed as JSON.

additional_properties str

Parsed as JSON.

additionalProperties String

Parsed as JSON.

AdditionalProperties string

Parsed as JSON.

AdditionalProperties string

Parsed as JSON.

additionalProperties String

Parsed as JSON.

additionalProperties string

Parsed as JSON.

additional_properties str

Parsed as JSON.

additionalProperties String

Parsed as JSON.

AdditionalProperties string

Parsed as JSON.

AdditionalProperties string

Parsed as JSON.

additionalProperties String

Parsed as JSON.

additionalProperties string

Parsed as JSON.

additional_properties str

Parsed as JSON.

additionalProperties String

Parsed as JSON.

CaCertificate string

CA certificate

AdditionalProperties string

Parsed as JSON.

ClientCertificate string

Client certificate

ClientKey string

Client key

ClientKeyPassword string

Password for keystorage. If you do not add it - the password will be generated automatically.

CaCertificate string

CA certificate

AdditionalProperties string

Parsed as JSON.

ClientCertificate string

Client certificate

ClientKey string

Client key

ClientKeyPassword string

Password for keystorage. If you do not add it - the password will be generated automatically.

caCertificate String

CA certificate

additionalProperties String

Parsed as JSON.

clientCertificate String

Client certificate

clientKey String

Client key

clientKeyPassword String

Password for keystorage. If you do not add it - the password will be generated automatically.

caCertificate string

CA certificate

additionalProperties string

Parsed as JSON.

clientCertificate string

Client certificate

clientKey string

Client key

clientKeyPassword string

Password for keystorage. If you do not add it - the password will be generated automatically.

ca_certificate str

CA certificate

additional_properties str

Parsed as JSON.

client_certificate str

Client certificate

client_key str

Client key

client_key_password str

Password for keystorage. If you do not add it - the password will be generated automatically.

caCertificate String

CA certificate

additionalProperties String

Parsed as JSON.

clientCertificate String

Client certificate

clientKey String

Client key

clientKeyPassword String

Password for keystorage. If you do not add it - the password will be generated automatically.

CaCertificate string

CA certificate

AdditionalProperties string

Parsed as JSON.

ClientCertificate string

Client certificate

ClientKey string

Client key

ClientKeyPassword string

Password for keystorage. If you do not add it - the password will be generated automatically.

CaCertificate string

CA certificate

AdditionalProperties string

Parsed as JSON.

ClientCertificate string

Client certificate

ClientKey string

Client key

ClientKeyPassword string

Password for keystorage. If you do not add it - the password will be generated automatically.

caCertificate String

CA certificate

additionalProperties String

Parsed as JSON.

clientCertificate String

Client certificate

clientKey String

Client key

clientKeyPassword String

Password for keystorage. If you do not add it - the password will be generated automatically.

caCertificate string

CA certificate

additionalProperties string

Parsed as JSON.

clientCertificate string

Client certificate

clientKey string

Client key

clientKeyPassword string

Password for keystorage. If you do not add it - the password will be generated automatically.

ca_certificate str

CA certificate

additional_properties str

Parsed as JSON.

client_certificate str

Client certificate

client_key str

Client key

client_key_password str

Password for keystorage. If you do not add it - the password will be generated automatically.

caCertificate String

CA certificate

additionalProperties String

Parsed as JSON.

clientCertificate String

Client certificate

clientKey String

Client key

clientKeyPassword String

Password for keystorage. If you do not add it - the password will be generated automatically.

NoTunnel SourcePostgresConfigurationTunnelMethodNoTunnel

PasswordAuthentication SourcePostgresConfigurationTunnelMethodPasswordAuthentication

SshKeyAuthentication SourcePostgresConfigurationTunnelMethodSshKeyAuthentication

NoTunnel SourcePostgresConfigurationTunnelMethodNoTunnel

PasswordAuthentication SourcePostgresConfigurationTunnelMethodPasswordAuthentication

SshKeyAuthentication SourcePostgresConfigurationTunnelMethodSshKeyAuthentication