Skip to Main Content

VGM Fulfillment is a licensed third-party logistics provider and wholesale distributor of medical devices. They serve 25,000+ clients nationwide and assist millions suffering from obstructive sleep apnea (OSA). Headquartered in Waterloo, Iowa, VGM’s four fulfillment centers cover all 50 states.


A Need for Secure Data Sharing

VGM needed to securely share its SQL server data containing shipping dates, requested ship dates, invoice numbers, quantities ordered, quantities processed, order status, shipping status, and tracking numbers with customers while maintaining control of granular access rights. In addition, the solution needed to integrate with their existing Azure infrastructure and accommodate growing volumes of data.

Unfortunately, because of how the existing data-sharing framework was set up, data could not be shared with one customer without giving that customer access to other customers’ data.

VGM handled this challenge through manual processes that took longer and introduced errors.

VGM needed a change, and they turned to Spaulding Ridge for a solution.


An Adaptable Data Stack with Advanced Security Capabilities

We built a data stack that moved data from VGM’s SQL server to Azure and then into Snowflake. Then in Snowflake, we established a “Data Clean Room”—a secure, closed environment that allows multiple parties to collaborate and share data in a privacy-safe manner. VGM could now share and match first-party data with customer data to derive the insights they needed while protecting customer privacy.

We built a UTILS table to hold all IDs associated with a specific parent account in the customer table, which linked those IDs to the respective customer’s Snowflake account locator values. In the dynamic table, we pull in all data where customers have Snowflake accounts (using the UTILS table). If the account exists, the data is loaded into the table. In the secure view shared with other Snowflake accounts, a common table expression will match the account locator values from the UTILS table with the built-in Snowflake function, returning the locator value. The view will only select parent accounts on the same row as the account locator, which will then be used for the rest of the view, allowing customers to be pulled in. Through this, customers can only see their respective IDs, protecting their privacy and data.


Consolidation of Data and Resources Optimizes Success for the Present and Future

VGM now has nine tables for data-sharing initiatives and automated capabilities to enhance accuracy, acquiring accurate insights into SQL data. The Data Clean Room enabled 10 data-sharing objects, enhancing customer capabilities and privacy. This enabled VGM’s customers to access all their logistical information, enabling them to make better cost-cutting decisions throughout their supply chain process.

We provided VGM with two sample test scripts, three training recordings, and one query for the nine tables. These tools created a resource for VGM to reference to ensure the new data-sharing solution kept working smoothly.

With VGM’s customers able to access their private data securely, VGM has a better roadmap to achieving their mission and enhancing their customer experience.

 Start your journey