Email Notification Configuration

The Snowflake CapStorm Salesforce Connector has the ability to send email messages on completion or failure of CopyStorm replication jobs. To securely enable this capability, a Notification Integration must be created and access must to the Notification Integration must be granted to the application. This page explains why this is necessary and provides the required steps for successful configuration.

Why is a Notification Integration Required?

Snowflake enforces a security-first model for external communications. If an application needs to send notifications (e.g. through SYSTEM$SEND_EMAIL), Snowflake requires:

  • Explicit declaration of the allowed external notification service.
  • Controlled permissions for which applications can use the integration.

This ensures:

  • Only approved applications can send notifications.
  • External communication targets (like email services) are tightly scoped.
  • Auditing and observability are maintained for outgoing communications.

Creating and Granting the Notification Integration to the Snowflake CapStorm Salesforce Connector

The below SQL can be utilized to successfully create a Notification Integration within the Snowflake environment and grant access to the Snowflake CapStorm Salesforce Connector. The following must be replaced in the provided SQL statements:

  • DEFAULT_RECIPIENTS: A comma separated list of email addresses that should receive the CopyStorm job completion emails.
    • e.g. ( ‘example@capstorm.com’, ‘support@capstorm.com’ )
  • <<Name of Application>>: The actual name of the application within the Snowflake environment.

Identifying the Name of the Application

The following command can be executed within Snowflake to provide a list of applications available in the logged in Snowflake instance. The name field is the target name of the application that should be utilized in the Notification Integration grant.

Copy to Clipboard

SQL to Create and Grant Access

Copy to Clipboard

Utilizing the Notification Integration in the Snowflake CapStorm Salesforce Connector

After creating the Notification Integration, configuration of the integration can be done through the Setup page.