Configuring Data Share
Required Information
To establish a secure connection between SalesIntel and your Snowflake account, please provide your Data Sharing Account Identifier to your SalesIntel success team:
Required Detail
Description
Example
Data Sharing Account Identifier
Your unique account name/locator
OQHVFZT.HRC05820
How to locate your identifier:
Method 1: Log into your Snowflake console and navigate to the bottom-left corner. Hover over Account, then hover over your active account and click View account details to retrieve the Data Sharing Account Identifier in ORGNAME.ACCOUNTNAME format.
Method 2: Execute the following command in a Snowflake worksheet:
SELECT CURRENT_ORGANIZATION_NAME() || '.' || CURRENT_ACCOUNT_NAME();
Setup Instructions
Once SalesIntel publishes the listing to your account, you will receive a confirmation email. Follow these steps to access the data through the Snowflake Horizon Catalog interface.
Step 1: Navigate to External Sharing
Log in to your Snowflake account as an Account Administrator (ACCOUNTADMIN)
In the left navigation sidebar, locate Horizon Catalog
Click Data sharing
Select External sharing from the menu
Step 2: Accept the Shared Data
Ensure the Shared with you tab is selected
Locate the listing from SalesIntel under Direct Shares
Click on the listing and select Get Data
Step 3: Create Database and Assign Access
Provide a name for the local database (e.g., SALESINTEL_DATA)
Select which Roles should have permission to query this data (e.g., ANALYST_ROLE)
Click Create Database
Step 4: Validate Access
The database is now available in your worksheet objects. You can begin querying immediately - no manual refresh is required. All updates from SalesIntel flow automatically to this database.
Last updated