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

​
Prerequisites

  • A Snowflake account
  • ACCOUNTADMIN or another role with permission to import marketplace listings
  • Your Snowflake account identifier shared with your Vetcove contact

​
Step 1: Provide Your Snowflake Account Identifier

Before you can access the private listing, Vetcove needs to associate your Snowflake account with the manufacturers you should be able to query. Send your Snowflake account identifier to your Vetcove contact. Once Vetcove confirms your account has been added, continue to the next step.

​
Step 2: Install the Listing

  1. In Snowflake, navigate to Marketplace -> Snowflake Marketplace
  2. Search for Vetcove
  3. Select the Vetcove Manufacturer Data Share listing
  4. Click Get and follow the prompts to create a database from the listing
You can choose the database name during setup. The examples in these docs use VETCOVE_MANUFACTURER_DATA.

​
Step 3: Grant Access to Your Roles

Grant imported privileges on the shared database to the roles that need query access: 
GRANT IMPORTED PRIVILEGES ON DATABASE VETCOVE_MANUFACTURER_DATA TO ROLE <your_role>;

​
Step 4: Verify Setup

Run a small query against one of the shared schemas: 
SELECT COUNT(*) AS row_count
FROM VETCOVE_MANUFACTURER_DATA.B2B_SHARE.STOCK_STATUS_BY_SUPPLIER_WEEK;
If you are using the Home Delivery share, you can also check: 
SELECT COUNT(*) AS row_count
FROM VETCOVE_MANUFACTURER_DATA.HD_SHARE.HD_SALES_ORDER_ITEMS;

​
Schema Reference

B2B Marketplace views are located in the B2B_SHARE schema: 
SHOW VIEWS IN VETCOVE_MANUFACTURER_DATA.B2B_SHARE;
Home Delivery views are located in the HD_SHARE schema: 
SHOW VIEWS IN VETCOVE_MANUFACTURER_DATA.HD_SHARE;

​
Troubleshooting

IssueResolution
Listing not visible in MarketplaceConfirm your Snowflake account identifier was provided to Vetcove and added to the private listing
Insufficient privilegesConfirm your active role can import the listing and has imported privileges on the created database
No rows returnedConfirm your Snowflake account has been mapped to the expected manufacturer or vendor IDs
Unexpected database nameReplace VETCOVE_MANUFACTURER_DATA in examples with the database name selected during listing installation