StandardSnowflakeIngestManagerProviderService

Description:

Provides a Snowflake Ingest Manager for Snowflake pipe processors

Tags:

snowflake, jdbc, database, connection

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
Account Identifier Formataccount-identifier-formatAccount Name
  • Full URL Provide an account identifier in a single property
  • Account Name Provide a Snowflake Account Name
  • Account Locator Provide a Snowflake Account Locator
The format of the account identifier.
Snowflake URLhost-urlExample host url: [account-locator].[cloud-region].[cloud].snowflakecomputing.com
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Account Identifier 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 [Account Identifier 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 [Account Identifier 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 [Account Identifier 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 [Account Identifier 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 [Account Identifier Format] Property has a value of "Account Name".
User Nameuser-nameThe Snowflake user name.
Supports Expression Language: true (will be evaluated using variable registry only)
Private Key Serviceprivate-key-serviceController Service API:
PrivateKeyService
Implementation: StandardPrivateKeyService
Specifies the Controller Service that will provide the private key. The public key needs to be added to the user account in the Snowflake account beforehand.
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)
PipepipeThe Snowflake pipe to ingest from.
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.