Snowflake

You can configure Snowflake only as a target.

To configure the connection details for Snowflake in your Micro-Integration, see Snowflake Connection Parameters

You must also define at least one Micro-Integration Flow that specifies:

the endpoints where data is consumed from and published to. For more information, see Micro-Integration Flow Parameters.
how the header and payload fields should be mapped. For more information, see Mapping Headers and Payloads

For message headers, see Snowflake Message Headers.

Snowflake Connection Parameters

The following table describes the connection parameters for Snowflake.

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	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.

Micro-Integration Flow Parameters

You must configure the endpoint parameters for each Flow. Each Flow can have different settings, but they all share the connection details of the parent Micro-Integration.

Snowflake Target Parameters

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

Field	Description
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.

Provide feedback