---
title: "Using Snowflake Data Share"
date: "2024-05-14T06:19:35+00:00"
summary:
image:
type: "page"
url: "/customer-data-platform/using-snowflake-data-share"
id: "38280dd9-c21b-4b42-b482-726a9b21a6fd"
---

This page provides information about using the Snowflake data share for the following scenario:

IT engineers want to integrate data using data share listings.

Data Share prerequisites:
-------------------------

*   Data Share is an add-on request that requires an entitlement discussion with an Account Manager (AM) before provisioning begins.
    
*   AM initiates the provisioning process.
    
*   Customers must provide:
    *   A Snowflake Account ID.
    *   A list of [required tables](https://docs.acquia.com/customer-data-platform/docs/integration-and-data-collection/data-export/snowflake-data-share?previewMode=current#section-list-ofavailable-tables) for sharing.
*   AM completes the provisioning process and provides the data share name before data consumption begins.
    

Important

All contractual discussions must occur through the Account Manager. [Acquia Support](https://docs.acquia.com/service-offerings/contacting-acquia-support) does not handle Data Share requests.

Pre-provisioning requirement for account identifier submission to Acquia
------------------------------------------------------------------------

*   You must be an **ACCOUNTADMIN** or have a role with the **IMPORT SHARE** and **CREATE DATABASE** permissions.
    
*   You must use [**Snowflake Snowsight**](https://docs.snowflake.com/en/user-guide/ui-snowsight-gs "https://docs.snowflake.com/en/user-guide/ui-snowsight-gs"). If you are using the Snowflake Classic UI, click the **Snowsight** icon.
    
*   You must send the account identifier to Acquia. Acquia notifies you when the data share is ready. You can share the account identifier with Acquia through the following ways:
    
    *   [Classic console](#classic-console)
    *   [Snowflake web UI](#snowflake-web-ui)

### Classic console

To get the account identifier from classic console:

1.  Log in to the Snowflake database.
2.  Click your user name.
3.  In the **Account Information** section, click **Copy**.
    
    ![cdp_snowflake-acc-identifier.png](https://acquia.widen.net/content/4a1eb88c-aaee-4e25-9213-f8aa4d2d86e8/web/cdp_snowflake-acc-identifier.png?h=480&itok=dD6n3jwg)
    

### Snowflake web UI

To get the account identifier from the Snowflake web UI:

1.  Log in to the Snowflake database.
2.  Click **Account name** and hover on the item list.
3.  In the **Snowglobe** section, click the Copy icon.
    
    ![cdp_snowflake-acc-identifier-snowglobe.png](https://acquia.widen.net/content/645e989f-b6be-42a8-93af-507ba2a62598/web/cdp_snowflake-acc-identifier-snowglobe.png?w=480&itok=Q98bwTAH)
    

Post-provisioning completion using Snowflake Data Share
-------------------------------------------------------

To use Snowflake data share:

1.  Select the **ACCOUNTADMIN** role.
    
2.  Go to **Data** > **Private Sharing.**
    
    Search for listing with the name format: **A1SF Listing <EnvironmentID> <TenantID>**
    
3.  Click **Get**.
    
    ![cdp_snowflake-get.png](https://acquia.widen.net/content/428c1866-cf4c-467f-920e-86a651a8d3e0/web/cdp_snowflake-get.png?w=720&itok=VsloMzZ-)
    
    The following are the scenarios: 
    
    *   If the email associated with the current user is verified, the system displays the following dialog box:
        
    
    ![cdp_snowflake-verified-email.png](https://acquia.widen.net/content/434cff61-0ce0-4298-8c6c-2625b2f116a9/web/cdp_snowflake-verified-email.png?h=480&itok=UACIEWcS)
    
    *   If the email associated with the current user is not verified, the system displays the following dialog box:
        
    
    ![cdp_snowflake-resend-email.png](https://acquia.widen.net/content/502a01c5-ed40-455a-a883-846c7face8c8/web/cdp_snowflake-resend-email.png?w=480&itok=xtV25m9M)
    
    1.  Click **Re-send verification email**.
        
        The system sends you the verification email.
        
    2.  Check your inbox and validate the verification email. 
        
        ![cdp_snowflake-validate-email.png](https://acquia.widen.net/content/6190447f-16cd-4bfd-8a26-6e3c415c6376/web/cdp_snowflake-validate-email.png?w=720&itok=CR1AE-9w)
        
    3.  Click **VALIDATE YOUR EMAIL**.
        
        The system displays the success message dialog box.
        
    4.  Go to the Snowflake database and click **Get**.
        
        The system sends an email notification once the data is synced.
        
4.  Go to the Snowflake database and click **Get**.
    
    The system displays the following dialog box:
    
    ![cdp_snowflake-shared-listings.png](https://acquia.widen.net/content/8976142a-c5a7-4434-afc5-ccc162a0beee/web/cdp_snowflake-shared-listings.png?w=720&itok=fqq9FGtA)
    
5.  Click **Get**.
    
    The system displays the following dialog box:
    
    ![cdp_snowflake-get-listing.png](https://acquia.widen.net/content/fbee8007-4a77-464c-9e4b-3f80e68e09b6/web/cdp_snowflake-get-listing.png?w=480&itok=uJapYjxj)
    
6.  Click **Get**.
    
    The system displays the following dialog box:
    
    ![cdp_snowflake-readytouse.png](https://acquia.widen.net/content/18b78f25-4f47-47c9-91a7-f6a2f51f3254/web/cdp_snowflake-readytouse.png?w=480&itok=9I9XteVe)
    
7.  To query the shared objects, click **Query Data**.
    
    ![cdp_snowflake-query-data.png](https://acquia.widen.net/content/575a56fb-82ba-46a1-b8dc-8f0b2ee215fd/web/cdp_snowflake-query-data.png?w=720&itok=dEujWWpJ)
    
8.  Verify the number of tables, their names, and the update frequency to ensure the data share aligns with your request.
9.  Notify your Acquia Customer Value Manager or Account Manager after you complete the validation steps for the data share or if you require further assistance.