Snowflake Data Share

The Data Share 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.

Example

The BestTech organization stores their data in their own Snowflake data lake. Meanwhile, they have a Coveo-powered search page, and they’d 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 in order to set up your data share:

  1. Initiate the data share in the Coveo Administration Console and link it to your Snowflake account.

  2. Access the Snowflake console and create a database in your Snowflake account in order to complete the share.

Notes
  • You can have multiple data shares active simultaneously.

  • To learn more about creating and configuring shares with Snowflake, see Working with Shares.

Initiate Data Share

  1. In the Snowflake Access tab of the Raw Data (platform-eu | platform-au) page, click the Data Share subtab.

  2. Click Initiate data share.

  3. In the Initiate Data Share dialog that appears, enter the Snowflake account locator.

    Note

    If you’re unsure about which account locator to enter, you can find the correct one by entering select current_account() in the Snowflake console.

  4. Click the drop-down 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.

  5. Click Initiate.

  6. On the Snowflake console, create a database linked to the data share. You can create the database by following the steps provided by Snowflake in the Creating a Database from a Share page.

Tip

If you’re creating the database using SQL:

  1. Run the following query:

    USE role accountadmin;
    SHOW shares;
  2. Take note of the data obtained from the Name column in the SQL results table. If you have more than one share, then you’ll see multiple rows, therefore be sure to note the info for the correct share.

  3. Run the following statement to create the database:

    CREATE DATABASE <NAME> FROM SHARE <PROVIDER_ACCOUNT>.<SHARE_NAME>

    Where you replace:

    • <NAME> with the database name of your choice.

    • <PROVIDER_ACCOUNT>.<SHARE_NAME> with the data obtained from the Name column following the initial query (e.g., COVEO.PROVIDER.COVEO_UA).

Your Snowflake account appears in the Data Share subtab, and you can begin exploring your Coveo data on the Snowflake console.

Data Share
Notes
  • The Status column indicates the status of the share. If the status is Invalid, the Snowflake account locator you entered and/or the region you selected may be incorrect. If the status is Pending, the data share is still in the process of synchronizing.

  • A data share with a Snowflake account in the same region as one of our Snowflake Disaster Recovery (DR) sites takes more time to synchronize, therefore the share may be unavailable for up to one hour.

  • When you’ve shared the data with a specific account, the users within that account can view the data but can’t edit it.

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

  • Main: US East (N. Virginia) - us-east-1

  • DR: US West (Oregon) - us-west-2

Europe

  • Main: EU (Ireland) - eu-west-1

  • DR: EU (Frankfurt) - eu-central-1

Asia

Main: Asia Pacific (Sydney) - ap-southeast-2

Revoke Data Share

To remove an account from the Data Share list, click the account name, and then click Revoke.

Required Privileges

Privileges required to view or manage Data Share.

Action Service - Domain Required access level

Share Data

Analytics - Administrate

Allowed

Analytics - Snowflake Management

Edit

What's next for me?