In this article
...
Field Name | Field Type | Description | ||
---|---|---|---|---|
Label* | String | Specify a unique label for the account. Default Value: N/A | ||
Account properties* | The information required to create a connection to the database. | |||
JDBC JARs | Use this field set to define JDBC Drivers. This field set consists of the JDBC Driver field. | |||
JDBC Driver* | String | Specify the JDBC driver to use. Click the Upload icon to upload the JDBC driver that you want. Click Add to add a row for specifying a JDBC driver. Specify each driver in a separate row.
Default Value: N/A | ||
JDBC Driver Class* | String | Specify the JDBC Driver class name to use. Default Value: [None] | ||
JDBC URL | String | Specify the JDBC URL to use. Default Value: [None] | ||
Username | String | Specify the database username to use. Default Value: N/A | ||
Password | String | Specify the database password to use. Default Value: N/A | ||
Database name | String | Choose a database to which the account must be connected. The available options are:
If you use PostgreSQL JDBC driver to connect to Redshift database, the Auto detect option automatically detects the PostgreSQL database instead of Redshift. The behavior of the JDBC Snaps is optimized for the selected database. Default Value: Auto detect | ||
Test Query | String | Activates on selecting on selecting Auto detect for Database name. Specify a custom query to validate the database connection.
Default Value: N/A | ||
Advanced properties* | ||||
Min pool size* | Integer | Specify the minimum number of idle connections a pool will maintain at a time.
| ||
Max pool size* | Integer | Specify the maximum number of idle connections a pool will maintain at a time. Default Value: 15 Example: 10 | ||
Max idle time* | Integer | Specify the number of seconds a connection will exist in the pool before being destroyed. Default Value: 60 Example: 300 | ||
Checkout timeout* | Integer | Specify the number of milliseconds to wait for a connection to be available in the pool. A timeout of zero makes the Snap wait infinitely. After a certain time, an exception is thrown and the Pipeline fails. Default Value: 10000 Example:10000 | ||
Url properties | Use this field set to define URL properties to use in the JDBC URL. | |||
Url property name | String | Specify the name for the URL property. Default Value: N/A | ||
Url property value | String | Specify a value for the property name. Default Value: N/A | ||
Auto commit | Checkbox | Select this checkbox to commit a batch immediately after the batch executes. So, only the current executing batch will be rolled back if the Snap fails. | ||
Fetch size* | Integer | Specify the number of records to retrieve from the DB at a time. Default Value: 100 Example: 100 | ||
Batch size* | Integer | Specify the number of query statements to execute at a time. SELECT queries are not batched.
Default Value: 50 |
...