Skip to main content

Full Data Dump

What is Full Data Dump?​

Full data dump exports contain complete snapshots of master data tables. These exports:

  • Include all records - Complete table contents regardless of modification date
  • 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​

Assets & Equipment​

  • Asset - Coolers, refrigerators, and equipment master data
  • Planogram - Planogram configurations and layouts
  • Smart Device - IoT sensors and cameras

Monitoring & Users​

  • Alert - Alert history (last 90 days)
  • User - User accounts and permissions

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

Not Recommended for:

  • Ongoing incremental updates → Use Incremental Data Delta instead
  • Real-time dashboards → Use Incremental Data Delta
  • Frequent syncs → Use Incremental Data Delta (more efficient)

Migration Recommendation​

If you're currently using full data dump for regular updates:

  1. Initial Load: Use full data dump once to populate your warehouse
  2. Ongoing Updates: Switch to Incremental Data Delta for daily/hourly updates
  3. Periodic Refresh: Run full data dump monthly/quarterly for reconciliation

This hybrid approach reduces data transfer by 90%+ while maintaining data accuracy.

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​