Full Data Dump
What is Full Data Dump?
Full data dump exports contain complete snapshots of master data tables. These exports:
- Include records within the documented scope - Check each entity for retention windows, such as the 90-day alert history
- Larger file sizes - Contain the entire dataset
- Less frequent - Typically run daily or weekly
- Initial setup - Used for first-time data warehouse population
Available Master Data
Location & Organization
- Outlet - Location/outlet master data with addresses and coordinates
- Channel - Location type/channel reference data (On-Premise, Off-Premise, etc.)
- Location Classification - Location classification categories
- Market - Market hierarchy and territories
Products & Catalog
- Product - Product catalog with SKUs, brands, and specifications
- Brand - Brand and manufacturer master data
- Product Pricing - Product pricing by case size
- Location Product - Location-specific product pricing
Assets & Equipment
- Asset - Coolers, refrigerators, and equipment master data
- Planogram - Planogram configurations and layouts
- Smart Device - IoT sensors and cameras
Monitoring & Users
When to Use Full Data Dump
Recommended for:
- Initial data warehouse setup
- Complete data refresh/reconciliation
- Monthly or quarterly full refreshes
- Data validation and auditing
For entities that support delta exports, use Incremental Data Delta for ongoing updates. Delta exports cover the entities listed on that page; they are not a replacement for every full-data export. Follow the Data Integration Specification for export scheduling and processing rules.
Field Documentation
Most master data exports share common fields. See Common Fields Reference for details on:
- Client Information
- Location Information
- Product Information
- Asset Information
- Audit Fields
Next Steps
- Review Incremental Data Delta for entities that support incremental updates
- Review Data Integration Specification for setup guidance
- Check Version History for version changes
- Contact your CoolR integration specialist to plan your migration strategy