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. ( ‘[email protected]’, ‘[email protected]’ )

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

/*
  Provides details about installed applications within the Snowflake instance.
*/
SHOW APPLICATIONS;

SQL to Create and Grant Access

/*
  Creates the Notification Integration required for sending emails out of the
  Snowpark environment.
*/
CREATE NOTIFICATION INTEGRATION IF NOT EXISTS CapStorm_Notifications 
TYPE=EMAIL ENABLED=TRUE DEFAULT_RECIPIENTS = ( '[email protected]' ) DEFAULT_SUBJECT = 'CapStorm Job Notification';

/*
  Provides access to the notification integration for the application.
  NOTE: "<<Name of Application>>" must be replaced with the name of the application.
*/
GRANT USAGE ON INTEGRATION CapStorm_Notifications TO APPLICATION <<Name of Application>>;

Utilizing the Notification Integration in the Snowflake CapStorm Salesforce Connector

After creating the Notification Integration, replication jobs can be configured to send job completion emails through the Setup page.

Configuring Email Notifications Within the CopyStorm Application

Email notifications for SFDC record replication jobs can be configured through the Setup page, but can also be manually configured through the CopyStorm application. To do so, navigate to the Notifications tab of CopyStorm, provide the list of desired email(s), and the configured integration name.

Note that when manually providing the Notification Integration in the configuration file, the same steps listed in the Creating and Granting the Notification Integration to the Snowflake CapStorm Salesforce Connector section must be taken to grant the application access to send emails through Snowflake.