SnowflakeConnectionService¶
Description¶
Provides pooled database connections to Snowflake services
Properties¶
In the list below required Properties are shown with an asterisk (*). Other properties are considered optional. The table also indicates any default values, and whether a property supports the NiFi Expression Language.
Display Name |
API Name |
Default Value |
Allowable Values |
Description |
|---|---|---|---|---|
Account * |
Account |
Snowflake Account Identifier with Organization Name and Account Name formatted as [organization-name]-[account-name] |
||
Authentication Strategy * |
Authentication Strategy |
PASSWORD |
|
Strategy for authenticating Snowflake connections |
Connection Strategy * |
Connection Strategy |
STANDARD |
|
Strategy for connecting to Snowflake services |
Connection Timeout * |
Connection Timeout |
30 seconds |
Maximum amount of time to wait for a connection from a reusable pool |
|
Database Name |
Database Name |
Default Snowflake Database for connections |
||
Idle Timeout * |
Idle Timeout |
10 minutes |
Maximum amount of time for a connection to remain idle in a reusable pool |
|
Maximum Connections * |
Maximum Connections |
10 |
Maximum number of connections created and managed in a reusable pool |
|
Maximum Lifetime * |
Maximum Lifetime |
30 minutes |
Maximum lifetime for each connection in a reusable pool |
|
Password * |
Password |
Snowflake Password for authenticating connections |
||
Private Key Service * |
Private Key Service |
RSA Private Key Service for authenticating connections |
||
Role |
Role |
Default Snowflake Role for connections |
||
Schema |
Schema |
Default Snowflake Schema for connections |
||
User * |
User |
Snowflake User for authenticating connections |
||
Warehouse |
Warehouse |
Default Snowflake Warehouse for connections |
State management¶
This component does not store state.
Restricted¶
This component is not restricted.
System Resource Considerations¶
This component does not specify system resource considerations.