The IDR Enterprise Data Product (EDP) leverages the Snowflake External Table feature to reference external data product(s) maintained by the Data Product Owner(s) and Contributor(s) natively in cloud storage such as AWS S3. In addition to External Tables, the IDR EDP also contains data contributed via Snowflake Data Shares, providing access to data in other Snowflake accounts without requiring data replication. This investment and the existing Snowflake feature, enables the IDR to immediately onboard any new CMS data product(s).
The IDR EDP features include:
- Extends Data Mesh capability
- Integration with CMS Business Intelligence Tools
- Seamless search, query, and join across all objects
- User access is controlled by EUA job codes
IDR EDP Architecture
The IDRC High-Level Architecture diagram below shows the Snowflake metadata layers of IDR, including the Enterprise Data Product:
- EDPs — Enterprise Data Product(s)
- ADMs — Analytic Data Mart(s)
- VDMs — Virtual Data Mart(s)
- IDR Proper: Database Schemas
TRA 2025 Release 1 • General Distribution / Unclassified Information