Snowflake

You can only configure Snowflake as a target.

For message headers, see Snowflake Message Headers.

Snowflake Target Parameters

The following table describes the parameters for configuring Snowflake as a target.

Field Description

Snowflake URL

The URL of the Snowflake instance. For example, the format of the URL can be <LOCATOR>.<REGION>.snowflakecomputing.com:443. For more information about the URL and account information, see the Snowflake documentation.

Snowflake Username

The username to log in to Snowflake.

Role

The type of role in Snowflake. For example, ACCOUNTADMIN, SECURITYADMIN, USERADMIN, SYSADMIN, or PUBLIC. For more information about the Snowflake roles, see the Snowflake documentation.

Private Key Path

The path to the private key file. For more information about the private key path, see the Snowflake documentation.

Private Key Password

The password for the private key, if applicable. For more information about the private key password, see the Snowflake documentation.
Database

The uppercase Snowflake database name.

Alternatively, you can set the Smart Topic Destination on the Mapping step to a fully-qualified table name (database.schema.table), which will override this destination.
Schema

The uppercase Snowflake schema name.

Alternatively, you can set the Smart Topic Destination on the Mapping step to a fully-qualified table name (database.schema.table), which will override this destination.
Table

The uppercase Snowflake table name.

Alternatively, you can set the Smart Topic Destination on the Mapping step to a fully-qualified table name (database.schema.table), which will override this destination.
Provisioning Mode

Specifies whether and how the Micro-Integration provisions the specified target table:

  • NONE—the Micro-Integration does not attempt to create the table.

  • CREATE—the table is created if it does not exist.
Acknowledgment Mode

Controls when the Micro-Integration sends acknowledgments to the event broker service:

  • ON_COMMIT—the Micro-Integration waits until a row has been successfully committed to the target table before sending a message acknowledgment.

  • ON_INSERT—the acknowledgment is sent as soon as the message has been written to the Snowflake channel or stage.