Cassandra Database Account
Account settings
- Expression icon (
): Allows using JavaScript
syntax to access SnapLogic Expressions to set field values dynamically (if enabled). If
disabled, you can provide a static value. Learn more. - SnapGPT (
): Generates SnapLogic Expressions
based on natural language using SnapGPT. Learn
more. - Suggestion icon (
): Populates a
list of values dynamically based on your Snap configuration.
You can select only one attribute at a time using the icon.
Type into the field if it supports a comma-separated list of values. - Upload
: Uploads files. Learn more.
| Field / Field set | Type | Description |
|---|---|---|
| Label | String |
Required. Specify a unique label for the account. Default value: N/A Example: Cassandra Database Account |
| Account properties | Required. Enter in the information to create a connection to the database. | |
| Hostname | String/Expression | Required. The server's address to connect to. You may want to provide multiple hostnames when using a Cassandra cluster. To do so, separate each hostname with two uninterrupted hyphens; for example, host1--host2--host3. Warning:
The multiple hostnames support is not applicable for IP addresses. Default value: None. |
| Port Number | String/Expression | Required. The database server's port to connect
to. Default value: 9160 |
| Database name | String/Expression | Required. The database name to connect to. Default value: None. |
| Username | String/Expression | Username that is allowed 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. Default value: None. |
| Password | String/Expression | 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. Default value: None. |
| Advanced properties | ||
| Auto commit | Checkbox/Expression |
When selected, each of the batches is committed immediately after it is executed. If the Snap fails, only the batch being executed at that moment is rolled back. When deselected, the Snap execution output is committed only after all the batches are executed. If the Snap fails, the entire transaction is rolled back, unless the Snap finds invalid input data before it sends the insert request to the server, and routes the error documents to the Error view. Default status: Selected |
| Batch size | Integer/Expression | Required. Number of statements to execute at a
time. Warning: Select queries are not batched. Warning: Using a large batch size could use up the JDBC placeholder
limit of 2100.
Default value: 50 |
| Fetch size | Integer/Expression | Required. Number of rows to fetch at a time when
executing a query. Warning: Large values could cause the server to run
out of memory. Default value: 100 |
| Min pool size | Integer/Expression | Required. Minimum number of connections a pool will
maintain at a time. Default value: 3 |
| Max pool size | Integer/Expression | Required. Maximum number of connections a pool will
maintain at a time. Default value: 50 |
| Max life time | Integer/Expression | Required. 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. Default value: 30 |
| Idle Timeout | Integer/Expression | Required. 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. Default value: 5 |
| Checkout timeout | Integer/Expression | Required. Number of milliseconds to wait for a
connection to be available when the pool is exhausted. Note: If you specify
0, the Snap waits infinitely until the connection is available. Therefore,
we recommend you not to specify 0 for Checkout Timeout. Default value: 10000 |
| URL Properties | ||
| URL property name | String/Expression | URL property name. Default value: None. |
| URL property value | String/Expression | URL property value. Default value: None. |