SnowflakeComputingConnectionPool

Description:

Provides Snowflake Connection Pooling Service. Connections can be asked from pool and returned after usage.

Tags:

snowflake, dbcp, jdbc, database, connection, pooling, store

Properties:

In the list below, the names of required properties appear in bold. Any other properties (not in bold) are considered optional. The table also indicates any default values, and whether a property supports the NiFi Expression Language.

Display NameAPI NameDefault ValueAllowable ValuesDescription
Connection URL Formatconnection-url-formatFull URL
  • Full URL Provide connection URL in a single property
  • Account Name Provide a Snowflake Account Name
  • Account Locator Provide a Snowflake Account Locator
The format of the connection URL.
Snowflake URLDatabase Connection URLExample connection string: jdbc:snowflake://[account].[region].snowflakecomputing.com/?[connection_params] The connection parameters can include db=DATABASE_NAME to avoid using qualified table names such as DATABASE_NAME.PUBLIC.TABLE_NAME
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Connection URL Format] Property has a value of "Full URL".
Account Locatoraccount-locatorSnowflake account locator to use for connection.
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Connection URL Format] Property has a value of "Account Locator".
Cloud Regioncloud-regionSnowflake cloud region to use for connection.
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Connection URL Format] Property has a value of "Account Locator".
Cloud Typecloud-typeSnowflake cloud type to use for connection.
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Connection URL Format] Property has a value of "Account Locator".
Organization Nameorganization-nameSnowflake organization name to use for connection.
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Connection URL Format] Property has a value of "Account Name".
Account Nameaccount-nameSnowflake account name to use for connection.
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Connection URL Format] Property has a value of "Account Name".
UsernameDatabase UserThe Snowflake user name.
Supports Expression Language: true (will be evaluated using variable registry only)
PasswordPasswordThe password for the Snowflake user.
Sensitive Property: true
Supports Expression Language: true (will be evaluated using variable registry only)
DatabasedatabaseThe database to use by default. The same as passing 'db=DATABASE_NAME' to the connection string.
Supports Expression Language: true (will be evaluated using variable registry only)
SchemaschemaThe schema to use by default. The same as passing 'schema=SCHEMA' to the connection string.
Supports Expression Language: true (will be evaluated using variable registry only)
WarehousewarehouseThe warehouse to use by default. The same as passing 'warehouse=WAREHOUSE' to the connection string.
Supports Expression Language: true (will be evaluated using variable registry only)
Proxy Configuration Serviceproxy-configuration-serviceController Service API:
ProxyConfigurationService
Implementation: StandardProxyConfigurationService
Specifies the Proxy Configuration Controller Service to proxy network requests. If set, it supersedes proxy settings configured per component.
Validation queryValidation-queryValidation query used to validate connections before returning them. When connection is invalid, it gets dropped and new valid connection will be returned. Note!! Using validation might have some performance penalty.
Supports Expression Language: true (will be evaluated using variable registry only)
Max Wait TimeMax Wait Time500 millisThe maximum amount of time that the pool will wait (when there are no available connections) for a connection to be returned before failing, or -1 to wait indefinitely.
Supports Expression Language: true (will be evaluated using variable registry only)
Max Total ConnectionsMax Total Connections8The maximum number of active connections that can be allocated from this pool at the same time, or negative for no limit.
Supports Expression Language: true (will be evaluated using variable registry only)
Minimum Idle Connectionsdbcp-min-idle-conns0The minimum number of connections that can remain idle in the pool without extra ones being created. Set to or zero to allow no idle connections.
Supports Expression Language: true (will be evaluated using variable registry only)
Max Idle Connectionsdbcp-max-idle-conns8The maximum number of connections that can remain idle in the pool without extra ones being released. Set to any negative value to allow unlimited idle connections.
Supports Expression Language: true (will be evaluated using variable registry only)
Max Connection Lifetimedbcp-max-conn-lifetime-1The maximum lifetime in milliseconds of a connection. After this time is exceeded the connection will fail the next activation, passivation or validation test. A value of zero or less means the connection has an infinite lifetime.
Supports Expression Language: true (will be evaluated using variable registry only)
Time Between Eviction Runsdbcp-time-between-eviction-runs-1The number of milliseconds to sleep between runs of the idle connection evictor thread. When non-positive, no idle connection evictor thread will be run.
Supports Expression Language: true (will be evaluated using variable registry only)
Minimum Evictable Idle Timedbcp-min-evictable-idle-time30 minsThe minimum amount of time a connection may sit idle in the pool before it is eligible for eviction.
Supports Expression Language: true (will be evaluated using variable registry only)
Soft Minimum Evictable Idle Timedbcp-soft-min-evictable-idle-time-1The minimum amount of time a connection may sit idle in the pool before it is eligible for eviction by the idle connection evictor, with the extra condition that at least a minimum number of idle connections remain in the pool. When the not-soft version of this option is set to a positive value, it is examined first by the idle connection evictor: when idle connections are visited by the evictor, idle time is first compared against it (without considering the number of idle connections in the pool) and then against this soft option, including the minimum idle connections constraint.
Supports Expression Language: true (will be evaluated using variable registry only)

Dynamic Properties:

Supports Sensitive Dynamic Properties: Yes

Dynamic Properties allow the user to specify both the name and value of a property.

NameValueDescription
JDBC property nameSnowflake JDBC property valueSnowflake JDBC driver property name and value applied to JDBC connections.
Supports Expression Language: true (will be evaluated using variable registry only)

State management:

This component does not store state.

Restricted:

This component is not restricted.

System Resource Considerations:

None specified.