1. Attentive
  2. App Marketplace
  3. Customer data integrations

Snowflake

Updated

Snowflake’s AI Data Cloud helps you share data, build applications, and power your business with AI. You can sync your data between Attentive and Snowflake to use data from Snowflake across the Attentive platform and to send valuable insights from Attentive to Snowflake.

There are two parts to this Attentive <> Snowflake data share. You have the option to enable either or both:

Setting up this integration can provide the following benefits:

  • Bidirectional data sync makes your data available across Attentive and Snowflake. Within Attentive, this lets you create highly targeted subscriber segments and further personalize your campaigns and journeys.
  • Sync first-party data between Snowflake and Attentive with flexible import and export options for smarter insights and actions when using our AI products.

Prerequisites

You must meet the following requirements to set up this integration:

  • The user setting up the share must have ACCOUNTADMIN access in order to trigger the data share.
  • If you use a non-AWS region like Azure, GCP, or another cloud region, and you've procured on the Snowflake marketplace, please take the following steps:
    • Reach out to your Attentive CSM or the White Glove team (whiteglove@attentivemobile.com) to let them know you’d like to set up the Attentive + Snowflake integration.
    • Attentive will follow up to provide you with Attentive’s Snowflake Identifier and an additional guide that explains how to set up the integration.

Inbound data share (Snowflake > Attentive)

The inbound data share sends data from Snowflake to Attentive, such as product data, subscriber attributes, site activity, and more.

Sample inbound datasets (Snowflake > Attentive)

Data you can sync can include:

  • First-party data: This can include events on your website, like product views and purchases. This can also include activities that happen outside of your website, like in-store purchases and returns, ad engagement, loyalty events, email activity, and reviews. You can use this data for marketing activation, segmentation, and journey activation.
  • Third-party data: This can include engagement with ads, loyalty program activity, ticket purchase data, and much more.
  • Customer attributes: This can include customer first and last name, area code, birthday, loyalty status, and more. You can use attributes—like gender, birthday, and first name—along with metrics—like product affinity, average order value, purchase frequency, and purchase categories— for more personalized segments.
  • Product catalog details: This can include product names, descriptions, SKUs, prices, and more. This can help you gain access to detailed product data to significantly enhance the accuracy of your outputs, especially when it comes to product recommendations.
  • Purchase data: This can include historical and in-store purchase data including past purchases, frequency of purchases, average order value, favorite product categories, and seasonal buying trends. You can use this data to better understand subscriber intent and activity.

Set up inbound data sharing between Snowflake and Attentive in Snowflake's Marketplace (Snowflake > Attentive)

Note: If you get stuck at any point in this process, you can clear the app’s metadata to start over with a clean install by running these two SQL commands:

truncate table ATTENTIVE_PRODUCT_CUSTOMER_AND_EVENT_DATA_SYNC.data.share_status;

truncate table ATTENTIVE_PRODUCT_CUSTOMER_AND_EVENT_DATA_SYNC.data.object_status;
  1. Go to the Snowflake Marketplace and select the Attentive App. The name of the Attentive App is Attentive: Product, Customer, and Event Data Sync.
  2. Click Get in the top right corner and again on the subsequent screen.
    ‘Attentive: Product, Customer, and Event Data Sync' page with a blue 'Get' button, overview text describing Snowflake data sync features, and a right-hand list of six category tags in blue, such as 'Audience Activation' and 'Customer Acquisition’.
  3. After clicking Get, you can customize the application name and virtual warehouse to use for the installation. Click Get again to begin the installation process.
    Panel showing 'Attentive: Product, Customer, and Event Data Sync' with options to name the application and select the warehouse, a blue 'Get' button, and a note about role switching to 'ACCOUNTADMIN'.
  4. Click Configure to begin the setup process.
    Success message with a green checkmark, 'Successfully Installed' heading, and two buttons labeled 'Configure' in blue and 'Done' in white.
    Once the app loads (it will show loading steps 1-8), the app in the image below loads.
    'Snowflake Attentive: Data Sync' page with a yellow banner displaying the 'attentive' logo, a left-side yellow panel with 'Refresh App' and 'Refresh Share Status' buttons.
  5. Fill in the company name and contact email address, then click Proceed to Next Step.
    'Create Private Listing' form with fields for 'Company' pre-filled and 'Contact Email Address' set, a blue 'Proceed to Next Step' button, and a yellow note prompting to fill out contact information.
  6. The popup below appears. Click Grant Privileges to enable future setup steps. 
    'Create Private Listing' page with a red warning box about required 'IMPORTED PRIVILEGES ON SNOWFLAKE DB', and a pop-up prompting to grant account-level privileges with 'Cancel' and 'Grant Privileges' buttons.
  7. In Step 2, select a database you’ll contribute to the share from. Then in Step 3, select the schemas to include in the share.
    'Configure Share: Schema Selection' section with two schema selected under the database and displayed in the 'Selected schemas' table below.
  8. In Step 4, select the objects to include in the share.
    'Configure Share: Object Selection' section with two selected tables under two schemas in the 'ATTENTIVE_APP_TESTING' database, followed by instructions to execute SQL with a 'Run All' button image.
  9. In Step 5, click the indicated launch link to open a new Snowsight worksheet. Execute the provided SQL using the Run Now command. You should see all steps execute successfully, resulting in a “Listing was successfully created” status, as shown in the image below. Go back to the app and click Refresh App before moving on to the next step.
    SQL worksheet in Snowflake showing a query to create a warehouse named 'attentive_share_wh', grant usage to an app, and confirm success with a 'Listing
  10. Confirm that you see the shared objects in the image below. If you see a green check mark next to Shared Object Status, the setup process is complete! You’ll be contacted by an Attentive representative within the next 1-2 business days. 'Shared Object Status' section showing a green checkmark with two shared objects listed and a note about adding objects and refreshing the share status.
  11. When you’re finished with setup in Snowflake, reach out to your Attentive CSM or White Glove (whiteglove@attentivemobile.com) and ask them to turn on the data share from Attentive to Snowflake.

Outbound data share (Attentive > Snowflake)

Our outbound data share allows you to:

  • Make Attentive event & performance data available directly in your Snowflake account.
  • Centralize reporting of Attentive performance data easily within Snowflake.
  • Achieve faster time-to-value by using Snowflake instead of SFTP solutions.

Outbound datasets (Attentive > Snowflake)

The outbound data share sends two data feeds to Snowflake:

  • Attentive General Events: Event data generated from user interactions with your Attentive-powered experiences, such as message receipts, link clicks, subscription opt-ins, and purchase events.
  • Conversions: Purchase and attribution data, including message attribution, order values, and product details.

Set up outbound data sharing between Attentive and Snowflake (Attentive > Snowflake)

Important note: For optimal performance, make all queries to Attentive’s data share with a date and/or type filter.
  1. Share your Snowflake account identifier with your Attentive CSM or White Glove (whiteglove@attentivemobile.com). See Account identifiers | Snowflake Documentation to learn how to find your account identifier. Attentive will configure outbound data sharing on your behalf.

    Note: Attentive needs account identifiers to be in the following format: orgname.account_name
  2. After Attentive configures your outbound data share, go to Data Products > Private Sharing in your Snowflake instance.
  3. Click Get to accept the data share from Attentive and start data syncing.
    Screenshot of Snowflake's Private Sharing page showing one privately shared listing titled ‘Attentive Snowflake Data Share Company ID 5, and two direct shares: ‘ACCOUNT_USAGE’ and ‘SAMPLE_DATA.
  •  

Frequently asked questions

How long does it take for Attentive data to appear in Snowflake?

Attentive data appears in Snowflake within 24 hours of its creation.

Does Attentive backfill old event data to Snowflake?

Yes. Attentive backfills historical event data to Snowflake, making all past data available in your Snowflake account.

Does this integration copy Attentive data to my Snowflake account?

No. This integration uses Snowflake’s Secure Data Sharing feature, which doesn’t copy data.

In Snowflake, can I edit data shared from Attentive?

No. Data shared via Secure Data Sharing is read-only.

Can I control access to my Attentive data in Snowflake?

Yes. Use Snowflake’s role-based access controls to manage access to shared data.

How fast are queries to Attentive data shared with Snowflake?

Query speed, performance, and cost depend on the warehouse size you use in Snowflake.

  • Larger datasets may require a larger warehouse size to run queries efficiently.
  • For guidance on selecting the appropriate warehouse size, see Snowflake’s warehouse overview.

Can I share data with Attentive if we use Azure, GCP, or another cloud region?

Yes. If you use Azure, GCP, or another cloud region and have procured on the Snowflake marketplace, you can still share data with Attentive. However, you must configure the share manually in the Snowflake UI.

I get a MANAGE LISTING AUTOFULFILLMENT error during listing creation. How do I resolve this?

If you get the following error:

Insufficient privileges. MANAGE LISTING AUTOFULFILLMENT privilege is
required to configure listing autofulfillment. ORGADMIN has to grant
this for the account. If its already granted by ORGADMIN,
then ACCOUNTADMIN needs to grant it.

Then you must enable cross-cloud auto-fulfillment for the account. To do so, execute the following command using the ORGADMIN role:

use role orgadmin;
SELECT SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT('<your_account_name>');

For more information about provider listing auto-fulfillment, refer to Snowflake's Configure Cross-Cloud Auto-Fulfillment documentation.

How is data transfer security handled?

No actual data is copied or transferred between accounts. All sharing uses Snowflake’s secure services layer and metadata store. For more details, refer to Snowflake’s security documentation.

Will cross-region sharing affect performance or incur extra costs?

Yes, but the additional costs are minimal. For more details, contact your Snowflake representative.

Articles in this section

See more
Was this article helpful?
0 out of 0 found this helpful