CREATE NOTIFICATION INTEGRATION (email)¶

Creates a new notification integration in the account or replaces an existing integration for sending email messages.

See also:: ALTER NOTIFICATION INTEGRATION (email) , DESCRIBE INTEGRATION , DROP INTEGRATION , SHOW INTEGRATIONS

Syntax¶

CREATE [ OR REPLACE ] NOTIFICATION INTEGRATION [ IF NOT EXISTS ] <name>
  TYPE = EMAIL
  ENABLED = { TRUE | FALSE }
  [ ALLOWED_RECIPIENTS = ( '<email_address>' [ , ... '<email_address>' ] ) ]
  [ DEFAULT_RECIPIENTS = ( '<email_address>' [ , ... '<email_address>' ] ) ]
  [ DEFAULT_SUBJECT = '<subject_line>' ]
  [ COMMENT = '<string_literal>' ]

Copy

Required parameters¶

name

String that specifies the identifier (i.e. name) for the integration; must be unique in your account.

In addition, the identifier must start with an alphabetic character and cannot contain spaces or special characters unless the entire identifier string is enclosed in double quotes (for example, "My object"). Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

ENABLED = { TRUE | FALSE }

Specifies whether to initiate operation of the integration or suspend it.

TRUE enables the integration.
FALSE disables the integration for maintenance. Any integration between Snowflake and a third-party service fails to work.

TYPE = EMAIL: Specifies that the integration creates an interface between Snowflake and a third-party email service.

Optional parameters¶

ALLOWED_RECIPIENTS = ( 'email_address' [ , ... 'email_address' ] )

(For TYPE = EMAIL) A comma-separated list of quoted email addresses that can receive notification emails from this integration.

You must specify email addresses of users in the current account. These users must verify their email addresses.

The maximum number of email addresses that you can specify is 50.

If you omit this parameter, you can send email notifications to any verified email address in the current account.

DEFAULT_RECIPIENTS = ( 'email_address' [ , ... 'email_address' ] )

Specifies the list of default recipients for messages sent with this integration. Use a comma-separated list of quoted email addresses to specify the default recipients.

You must specify email addresses of users in the current account. These users must verify their email addresses.

To override the default recipients for a given message, use the EMAIL_INTEGRATION_CONFIG helper function when calling the SYSTEM$SEND_SNOWFLAKE_NOTIFICATION stored procedure.

DEFAULT_SUBJECT = 'subject_line'

Specifies the default subject line for messages sent with this integration.

The subject cannot exceed 256 characters in length.

Default: ‘Snowflake Email Notification’

To override the default subject line for a given message, use the EMAIL_INTEGRATION_CONFIG helper function when calling the SYSTEM$SEND_SNOWFLAKE_NOTIFICATION stored procedure.

COMMENT = 'string_literal'

String (literal) that specifies a comment for the integration.

Default: No value

Access control requirements¶

A role used to execute this SQL command must have the following privileges at a minimum:

Privilege	Object	Notes
CREATE INTEGRATION	Account	Only the ACCOUNTADMIN role has this privilege by default. The privilege can be granted to additional roles as needed.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Usage notes¶

Regarding metadata:

Attention

Customers should ensure that no personal data (other than for a User object), sensitive data, export-controlled data, or other regulated data is entered as metadata when using the Snowflake service. For more information, see Metadata fields in Snowflake.
CREATE OR REPLACE <object> statements are atomic. That is, when an object is replaced, the old object is deleted and the new object is created in a single transaction.

Examples¶

See Sending email notifications.