Once an integration is enabled, you may need to determine when data from that source was last updated in DWA. The integrations table lists the expected refresh frequency of most integrations. For specific details, access the Warehouse Status Report within Tableau. This report includes:
- Overall success rate
- Percent of your integrations facing problems
- Percent of allocated disk space in use
- Time of the most recent successful refresh for each integration
- How long it took each integration to complete
- Disk space used by each schema
Find this report in the Explore tab under DWA - KORE > Warehouse Status > Warehouse Status Report.
The report also provides a chart that illustrates when each integration most recently ran and how long it took. Hover the mouse cursor over a bar in the chart for specific details.
The final section of the report shows historical data for integrations. Select a schema from the drop-down box and the number of days' data to view. (These details are purged after 1 to 2 weeks, so choosing a longer time window won't produce more results.) This view is particularly useful for determining the approximate time when you can expect new data to be available in the warehouse. In the example below, the Fanatics integration typically runs between 7:10am and 7:20am—so if you needed to produce a report each morning using Fanatics data, it would be best to run it around 8:00am. However, there is no guarantee that future updates will always occur in this time window.
Integrations may occasionally fail for a variety of reasons, but most errors are transient or self-correcting—see KORE's SLO for DWA. If an integration fails and you wish to investigate yourself, you can view the STL Load Errors report in Tableau. Find it in the Explore tab under DWA - KORE > STL Load Errors > STL Load Errors. Refer to Amazon's documentation for explanations of data available in this report. Amazon only retains these logs for a few days at most, so the report will appear blank if no errors have been recorded within that time.