Snowflake Data Share
Snowflake Data Share
The Data Share (platform-ca | platform-eu | platform-au) feature of the Coveo Administration Console provides a convenient way to retrieve your data if you already have a Snowflake account. You can use this feature to extract and integrate your data into your account and leverage it using your business intelligence (BI) tool of choice.
The BestTech organization stores their data in their own Snowflake data lake. Meanwhile, they have a Coveo-powered search page, and they would like to retrieve the corresponding data and add it to their data lake. As a result, they use the Data Share feature, which accesses their data from Coveo’s UA database and shares it to their Snowflake account.
There are two steps that you must complete to set up your data share:
-
Initiate the data share in the Coveo Administration Console and link it to your Snowflake account.
-
Access the Snowflake console and create a database in your Snowflake account to complete the share.
|
Notes
|
Initiate Data Share
-
On the Raw Data page, under Snowflake Access > Data Share (platform-ca | platform-eu | platform-au), click Initiate data share.
-
In the Initiate Data Share dialog that appears, enter the Snowflake account locator.
NoteIf you’re unsure about which account locator to enter, you can find the correct one by entering
select current_account()
in the Snowflake console. -
Click the dropdown menu and select the region where your Snowflake account is hosted.
Notes-
Data sharing is currently supported for a limited number of regions, which are listed in the dropdown menu.
-
If you’re unsure about which region to select, you can find the correct one by entering
select current_region()
in the Snowflake console.
-
-
Click Initiate.
-
On the Snowflake console:
|
Leading practice
If you’re creating the database using SQL:
|
Your Snowflake account appears in the Data Share subtab, and you can begin exploring your Coveo data on the Snowflake console.

|
Notes
|
Regions and site
For information on sharing data in different regions, see Sharing Data With Data Consumers in a Different Region and Cloud Platform.
Region | Site |
---|---|
US |
|
Canada |
Main: Canada (Central) - ca-central-1 |
Europe |
|
Asia |
Main: Asia Pacific (Sydney) - ap-southeast-2 |
Revoke Data Share
-
Use SQL to run the following query:
USE ROLE accountadmin; DROP DATABASE <NAME>;
Where you replace
<NAME>
with the database you want to remove. -
On the Raw Data page, under Snowflake Access > Data Share (platform-ca | platform-eu | platform-au), click the account name from the Data Share list, and then click Revoke.
Required privileges
Privileges required to view or manage Data Share.
Action | Service - Domain | Required access level |
---|---|---|
Share data |
Organization - Organization |
View |
Analytics - Snowflake management |
Edit |
|
Analytics - Administrate |
Allowed |