Skip to main content
This guide walks you through installing the Vetcove Corporate Data Share from the Snowflake Marketplace and making it queryable in your Snowflake environment.

​
Prerequisites

  • A Snowflake account (any edition, any region)
  • ACCOUNTADMIN role or a role with IMPORT SHARE privileges

​
Step 1: Provide Your Snowflake Account Identifier

Before you can access the listing, Vetcove needs to add your account to the private marketplace listing. Send your Snowflake account identifier to your Vetcove contact. Once Vetcove confirms your account has been added, proceed to the next step.

​
Step 2: Install the Listing from Snowflake Marketplace

  1. In Snowflake, navigate to Marketplace → Snowflake Marketplace
  2. Search Vetcove in the search bar
  3. Select the Vetcove Corporate Data Share Beta listing
  4. Click Get and follow the prompts to create a database from the listing
After installation, you should see a database with two schemas corresponding to our B2B procurement and PIMS/Home Delivery platforms.
The private listing includes cross-region replication, so your Snowflake account does not need to be in any specific cloud or region. However, if your account is outside of AWS us-east-2, the initial data replication may take some time to complete before the data is available for querying.

​
Step 3: Grant Access to Your Roles

Grant usage on the database and schema to the roles that need access: 
GRANT IMPORTED PRIVILEGES ON DATABASE <database_name> TO ROLE <your_role>;

​
Step 4: Verify Setup

Run a test query to confirm everything is working: 
USE DATABASE vetcove_corporate_data_share_beta;
USE SCHEMA PHD_ENRICHED;

SELECT COUNT(*) AS clinic_count
FROM CLINIC_ENRICHED;
You should see a count of clinics belonging to your corporate group.

​
Schema Reference

All PIMS/Home Delivery enriched views are located in the PHD_ENRICHED schema: 
SHOW VIEWS IN <database_name>.PHD_ENRICHED;
All B2B procurement enriched views are located in the B2B_ENRICHED schema: 
SHOW VIEWS IN <database_name>.B2B_ENRICHED;

​
Troubleshooting

IssueResolution
Listing not visible in MarketplaceConfirm your Snowflake account identifier was provided to Vetcove and that your account has been added to the private listing
Insufficient privilegesEnsure you are using the ACCOUNTADMIN role or a role with IMPORT SHARE privileges
Zero rows returnedData is filtered by corporate group; verify your account mapping with Vetcove
Stale dataData refreshes every 6 hours; check the last_updated column for the most recent processing timestamp