SnowflakeConnectionService

Description

Provides pooled database connections to Snowflake services

Tags

connection, database, jdbc, snowflake

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
Authentication Strategy *	Authentication Strategy	Password	Password Key Pair Snowflake Session Token	Strategy for authenticating Snowflake connections
Account *	Account			Snowflake Account Identifier with Organization Name and Account Name formatted as [organization-name]-[account-name] This property is only considered if: the property Authentication Strategy has a value of PASSWORD or KEY_PAIR
User *	User			Snowflake User for authenticating connections This property is only considered if: the property Authentication Strategy has a value of PASSWORD or KEY_PAIR
Password *	Password			Snowflake Password for authenticating connections This property is only considered if: the property Authentication Strategy has a value of PASSWORD
Private Key Service *	Private Key Service		Controller Service: PrivateKeyService Implementations: StandardPrivateKeyService	RSA Private Key Service for authenticating connections This property is only considered if: the property Authentication Strategy has a value of KEY_PAIR
Connection Strategy *	Connection Strategy	Standard	Standard Private Connectivity	Strategy for connecting to Snowflake services This property is only considered if: the property Authentication Strategy has a value of PASSWORD or KEY_PAIR
Connection Timeout *	Connection Timeout	30 seconds		Maximum amount of time to wait for a connection from a reusable pool
Idle Timeout *	Idle Timeout	10 minutes		Maximum amount of time for a connection to remain idle in a reusable pool
Maximum Lifetime *	Maximum Lifetime	30 minutes		Maximum lifetime for each connection in a reusable pool
Maximum Connections *	Maximum Connections	10		Maximum number of connections created and managed in a reusable pool
Warehouse	Warehouse			Default Snowflake Warehouse for connections
Database Name	Database Name			Default Snowflake Database for connections
Schema	Schema			Default Snowflake Schema for connections
Role	Role			Default Snowflake Role 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.

See Also