In this article
...
Use this account type to connect Redshift Snaps with data sources.
Prerequisites
Access to the following folders:
- Private project folder
- Project Space’s shared folder
- Global shared folder
Limitations
The default JDBC URL jdbc:postgre:://<hostname>:<port>/<db>
does not work, because it is not compatible with JDBC 2.x drivers. If you are using 2.x version of Amazon Redshift drivers, you must explicitly provide the JDBC URL as shown:jdbc:redshift://<hostname>:<port>/<db>
to configure the account successfully.
Known Issues
None.
Account Settings
Field | Field Type | Description | ||
---|---|---|---|---|
Label* Default Value: N/A | String | Specify a unique label for the account. | ||
JDBC Driver Class Default Value: org.postgresql.Driver | String/Expression | Specify a name of the JBDC driver class to use. | ||
JDBC jars Default Value: N/A | String/Expression | Specify a list of JDBC jar files to be loaded.
| ||
JDBC Url Default Value: N/A | String/Expression | Enter the Url of the JDBC database.
| ||
Account properties* | Enter in the information to create a connection to the database. | |||
Endpoint* Default Value: N/A | String/Expression | Enter the server's address to connect to. | ||
Port Number* Default Value: 5439 | Numeric/Expression | Enter the database server's port to connect. | ||
Database name* Default Value: N/A | String/Expression | Enter the database name to connect. | ||
Username Default Value: N/A | String/Expression | Enter the username to connect to the database. Username will be used as the default username when retrieving connections. The username must be valid in order to set up the data source. | ||
Password Default Value: N/A | String/Expression | Enter the password used to connect to the data source. Password will be used as the default password when retrieving connections. The password must be valid in order to set up the data source. | ||
S3 Bucket Default Value: N/A | String/Expression | Enter the external S3 Bucket name residing in an external AWS account, to use for staging data onto Redshift.
| ||
S3 Folder Default Value: N/A | String/Expression | Enter the relative path to a folder in S3 Bucket. This is used as a root folder for staging data onto Redshift. | ||
S3 Access-key ID Default Value: N/A | String/Expression | Enter the S3 Access key ID part of AWS authentication.
| ||
S3 Secret key Default Value: N/A | String/Expression | Enter the S3 Secret key part of AWS Authentication.
| ||
S3 Security Token Default Value: N/A | String/Expression | Specify the S3 Security token part of AWS Authentication for using temporary credentials (AWS STS). | ||
IAM properties | Specify the IAM properties information for Redshift to communicate with IAM |
AWS account ID Default Value: N/A | String/Expression | Enter the ID of the Amazon Web Services account to be used for performing bulk load operation.
| ||
IAM role name Default Value: N/A | String/Expression | Enter the name of the IAM role that has been assigned to the Redshift cluster to access the S3 bucket provided above.
| ||
Region name Default Value: N/A | String/Expression | Enter the name of the region the Redshift cluster. | ||
Advanced properties | Specify advanced properties to support this account. | |||
Auto commit Default Value: Selected | Checkbox | Select this check box to enable the Snap to commit offsets automatically as messages are consumed and sent to the output view. | ||
Batch size* Default Value: 50 | Integer/Expression | Enter the number of statements to execute at a time.
| ||
Fetch size* Default Value:100 | Integer/Expression | Enter the number of rows to fetch at a time when executing a query.
| ||
Max pool size* Default Value: 50 | Integer/Expression | Enter the maximum number of connections a pool will maintain at a time.
| ||
Max life time* Default Value: 30 | Integer/Expression | Enter the maximum lifetime of a connection in the pool. Ensure that the value you enter is a few seconds shorter than any database or infrastructure-imposed connection time limit. A value of 0 indicates an infinite lifetime, subject to the Idle Timeout value. An in-use connection is never retired. Connections are removed only after they are closed. | ||
Idle Timeout* Default Value: 5 | Integer/Expression | Enter the maximum amount of time a connection is allowed to sit idle in the pool. A value of 0 indicates that idle connections are never removed from the pool. | ||
Checkout timeout* Default Value:1000 | Integer/Expression | Enter the number of milliseconds to wait for a connection to be available when the pool is exhausted. Zero waits forever. An exception will be thrown after the wait time has expired. | ||
URL Properties | Specify the URL properties associated with this account. | |||
URL property name Default Value: N/A | String/Expression | Enter the URL property name. | ||
URL property value Default Value: N/A | String/Expression | Enter the URL property value. |
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
...