Sending E-Mails to the SNS Subscribers

Once you create an Amazon SNS connection, you can proceed to configure the data source in Sigma Studio for sending e-mails on the generated status of the reports to the existing subscribers of a topic in the Amazon SNS email delivery service. 

For sending e-mails on the generated status of the reports to the existing subscribers of a topic in the Amazon SNS email delivery service, perform the following steps:

1. Click the Data Source  icon on an existing Amazon SNS connection, e.g. NEW AMAZON SNS CONNECTION.
   
   Refer Connectors – Amazon SNS for more information on creating an Amazon SNS connection.
   
   
   
   The Create New Data Source page appears.
   
   
   
   
2. Enter a unique data source name in the Data Source Name field, e.g. AMAZON SNS DS.
   
   
   
   

3. In the Topic Name field, provide the topic name present in the connected SNS delivery service, e.g. SNSCHECK.
   

   
   
   

4. If required, you can add the message attributes to the SNS data source. In the Message Attributes section, provide the appropriate message name and path in the respective fields of Name and Path.
   

   For message attributes, if you provide Name, Path and Value, then, only the attributes provided for the Name and the Path fields will be taken into consideration. You can assign any one of the message attributes for either the Path or the Value field. In case, if you do not want to specify a message attribute path in the Path field, then you can directly specify the message attribute value in the Value field. It is not essential to provide the message attributes for both the Path and Value fields. You can even create the SNS data source without adding any message attributes, as the message attributes are only optional for configuring the SNS data source.

   If the report’s filter value needs to be shown in the SNS notification:

   • In the Value field, enter the filter column ID directly.

   OR

   • In the Value field, enter as ${COLUMN_ID}.

   
   
   
   

5. To add a message attribute, click the Plus  icon, whereas to delete an existing message attribute, click the Remove  icon.
   
   
   
   

6. Click Save to save the SNS data source.
   

   When you try to exit the Data Source screen, before saving the configured SNS data source, a warning pop-up message appears, as shown in the following screen shot:
   

   • Click Cancel, if you do not want to exit the Data Source screen.
   • Click Ok, if you want to exit the Data Source screen.

   
   
   
   A success message for creating the data source appears as shown in the following screenshot:
   
   
   
   

7. Click Ok.

Client Customization

To customize an Amazon SNS data source for a specific corporate client or customer, perform the following steps in Sigma Studio:

1. Hover the mouse on the created Amazon SNS data source (AMAZON SNS DS) and click the  icon. Proceed to select the Customize DS for Client option to configure a customized client data source.
   
   
   
   The Customize DS for Client page appears.
   
   
   
   

2. Click the Client lookup field and select the Corporate Client or Customer of your choice, e.g. HIGHSCORE.

   The Parent Data Source Id and Connection Name are non-editable fields.  icon is used to export the S3 data source in the SQL format, while  is used to delete the S3 data source.

   
   
   
   

3. Enter a unique data source name in the Data Source Name field, e.g. HIGHSCORE SNS DS.
   
   
   
   

4. In the Topic Name field, provide the topic name present in the connected SNS delivery service, e.g. SNSCHECK.
   

   
   
   

5. If required, you can add the message attributes to the client customized SNS data source. In the Message Attributes section, provide the appropriate message name and path in the respective fields of Name and Path.
   

   For message attributes, if you provide Name, Path and Value, then, only the attributes provided for the Name and the Path fields will be taken into consideration. You can assign any one of the message attributes for either the Path or the Value field. In case, if you do not want to specify a message attribute path in the Path field, then you can directly specify the message attribute value in the Value field. It is not essential to provide the message attributes for both the Path and Value fields. You can even create the client customized SNS data source without adding any message attributes, as the message attributes are only optional for configuring the client customized SNS data source.

   
   
   
   

6. To add a message attribute, click the Plus  icon, whereas to delete an existing message attribute, click the Remove  icon.
   
   
   
   

7. Click Save to save the client customized SNS data source.
   

   When you try to exit the Customize DS for Client screen, before saving the configured SNS data source, a warning pop-up message appears, as shown in the following screen shot:
   

   • Click Cancel, if you do not want to exit the Customize DS for Client screen.
   • Click Ok, if you want to exit the Customize DS for Client screen.

   
   
   
   A success message for creating the data source appears as shown in the following screenshot:
   
   
   
   

8. Click Ok.
   Once the SNS data source with the client customization is created, you can proceed to configure a report based on your needs and requirements. To configure reports for the SNS email delivery service channel, refer Configuring SNS channel for Reports.