Reporting Cache - ja-guzzle/guzzle_docs GitHub Wiki

Ideally there will be requirement to maintain reporting cache in the SQL server and in some cases on SQL Warehouse.

  1. Suggestion is to limit this data to : only required tables, use features of reporting tool to navigate to details when required,
  2. Dimension table should be copied fully (except dated ones), fact table should be loaded incrementally.
  3. Ensure end to end batch flow covers loading from staging to foundation to aggregate to reporting cache.
  4. Ideal to leverage the computation
  5. Use appropriate Spark connector for better performance
  6. Perform recon to ensure the data ties back
  7. Ensure there are no data type alignment issues - including number and date types
⚠️ **GitHub.com Fallback** ⚠️