What’s Included
The data share exposes enriched views — denormalized, business-ready tables that combine related entities for easy querying. These views are compatible with the structure of Vetcove’s existing APIs, making it straightforward to build analytics on top of familiar data shapes. The data is organized in two schemas:- b2b_enriched — secure views from derived from our B2B procurement platform
- phd_enriched — secure views from derived from our Home Delivery and PIMS platforms (PimsHomeDelivery)
- Buyers — buyer locations and corporate metadata
- Supplier Orders & Order Items — procurement order activity with pricing, vendor, and receiving details
- Invoices & Invoice Items — supplier invoice records with line-item financial breakdowns
- Budgets — monthly and weekly buyer spend budgets with configured targets and actuals
- Prescriptions — third-party pharmacy prescription requests
- Clinics, Clients, and Patients — organizational hierarchy and demographics
- Orders and Order Items — purchasing activity with pricing, fees, and vendor details
- Invoices — billing records with line-item financial breakdowns
- Prescriptions — prescription and fill lifecycle data
- Appointments and Medical Records — scheduling and clinical documentation
- Subscriptions — recurring order configurations
- Care Reminders — standard and custom patient care reminders
- Catalog Items — product catalog with manufacturer and category info
- Manual Discount History — audit trail of invoice discounts
- Care Plans & Benefits — care plan definitions, benefits, clinic pricing, and patient enrollments
- Inventory Codes — organization-level and clinic-level inventory items with preferences and stock quantities
Data Freshness
Data is processed and refreshed every 6 hours. Each view includes alast_updated column that reflects the most recent modification timestamp across all source tables contributing to that record.
Data Isolation
Every record includes avetcove_corporate_id column. The data share is configured so that your Snowflake account only sees records belonging to your corporate group — no additional filtering is required in your queries.
Engineering API Documentation
The data share views are compatible with the structure of Vetcove’s engineering APIs. If you’re also integrating via API, these references may be helpful:PHD API (Connect)
REST API for Home Delivery and PIMS platform data
B2B API
REST API for procurement platform data
Next Steps
- Set up the data share in your Snowflake account
- Run some starter queries to explore the data
- Browse the data model for PHD or B2B to understand table relationships