PostgreSqlSource Class

public final class PostgreSqlSource
extends TabularSource

A copy activity source for PostgreSQL databases.

Constructor Summary

Constructor Description
PostgreSqlSource()

Creates an instance of PostgreSqlSource class.

Method Summary

Modifier and Type Method and Description
static PostgreSqlSource fromJson(JsonReader jsonReader)

Reads an instance of PostgreSqlSource from the JsonReader.

Object getQuery()

Get the query property: Database query.

String getType()

Get the type property: Copy source type.

PostgreSqlSource setAdditionalColumns(Object additionalColumns)

Set the additionalColumns property: Specifies the additional columns to be added to source data.

PostgreSqlSource setMaxConcurrentConnections(Object maxConcurrentConnections)

Set the maxConcurrentConnections property: The maximum concurrent connection count for the source data store.

PostgreSqlSource setQuery(Object query)

Set the query property: Database query.

PostgreSqlSource setQueryTimeout(Object queryTimeout)

Set the queryTimeout property: Query timeout.

PostgreSqlSource setSourceRetryCount(Object sourceRetryCount)

Set the sourceRetryCount property: Source retry count.

PostgreSqlSource setSourceRetryWait(Object sourceRetryWait)

Set the sourceRetryWait property: Source retry wait.

JsonWriter toJson(JsonWriter jsonWriter)

Methods inherited from CopySource

Methods inherited from TabularSource

Methods inherited from java.lang.Object

Constructor Details

PostgreSqlSource

public PostgreSqlSource()

Creates an instance of PostgreSqlSource class.

Method Details

fromJson

public static PostgreSqlSource fromJson(JsonReader jsonReader)

Reads an instance of PostgreSqlSource from the JsonReader.

Parameters:

jsonReader - The JsonReader being read.

Returns:

An instance of PostgreSqlSource if the JsonReader was pointing to an instance of it, or null if it was pointing to JSON null.

Throws:

IOException

- If an error occurs while reading the PostgreSqlSource.

getQuery

public Object getQuery()

Get the query property: Database query. Type: string (or Expression with resultType string).

Returns:

the query value.

getType

public String getType()

Get the type property: Copy source type.

Overrides:

PostgreSqlSource.getType()

Returns:

the type value.

setAdditionalColumns

public PostgreSqlSource setAdditionalColumns(Object additionalColumns)

Set the additionalColumns property: Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).

Overrides:

PostgreSqlSource.setAdditionalColumns(Object additionalColumns)

Parameters:

additionalColumns

setMaxConcurrentConnections

public PostgreSqlSource setMaxConcurrentConnections(Object maxConcurrentConnections)

Set the maxConcurrentConnections property: The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer).

Overrides:

PostgreSqlSource.setMaxConcurrentConnections(Object maxConcurrentConnections)

Parameters:

maxConcurrentConnections

setQuery

public PostgreSqlSource setQuery(Object query)

Set the query property: Database query. Type: string (or Expression with resultType string).

Parameters:

query - the query value to set.

Returns:

the PostgreSqlSource object itself.

setQueryTimeout

public PostgreSqlSource setQueryTimeout(Object queryTimeout)

Set the queryTimeout property: Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+)\.)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

Overrides:

PostgreSqlSource.setQueryTimeout(Object queryTimeout)

Parameters:

queryTimeout

setSourceRetryCount

public PostgreSqlSource setSourceRetryCount(Object sourceRetryCount)

Set the sourceRetryCount property: Source retry count. Type: integer (or Expression with resultType integer).

Overrides:

PostgreSqlSource.setSourceRetryCount(Object sourceRetryCount)

Parameters:

sourceRetryCount

setSourceRetryWait

public PostgreSqlSource setSourceRetryWait(Object sourceRetryWait)

Set the sourceRetryWait property: Source retry wait. Type: string (or Expression with resultType string), pattern: ((\d+)\.)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

Overrides:

PostgreSqlSource.setSourceRetryWait(Object sourceRetryWait)

Parameters:

sourceRetryWait

toJson

public JsonWriter toJson(JsonWriter jsonWriter)

Overrides:

PostgreSqlSource.toJson(JsonWriter jsonWriter)

Parameters:

jsonWriter

Throws:

Applies to