Amazon Mobile Analytics
User Guide

If Data Does Not Appear in Amazon Redshift Cluster

First check to see if your data is being exported to the Amazon S3 bucket set up by Mobile Analytics. Successful export of data to your Amazon S3 bucket is a prerequisite for proper auto-export to Amazon Redshift. If your data is not appearing in Amazon S3, see If Auto Export to S3 Fails.

If you have just set up the auto-export to Amazon Redshift, make sure you wait at least an hour before you query Amazon Redshift. By default, the Amazon EC2 instance loads events from Amazon S3 into Amazon Redshift every hour. To load events sooner than one hour, you can log into the Amazon EC2 instance and adjust the crontab settings. Amazon Redshift export can be attempted at any rate by the Amazon EC2 instance, but won’t be picked up for auto-export to Amazon Redshift until the data is exported to the Amazon S3 bucket.

If you enabled CloudWatch metrics and logs when setting up the auto-export, follow these steps to investigate:

  1. Navigate to the CloudWatch console.

  2. Look at the log group with MobileAnalyticsAutoExportToRedshift as the prefix. If you have multiple of these log groups, look for the one with a uuid at the end matching the uuid in your latest AWS CloudFormation stack name.

  3. In the selected log group, look at the latest log stream. This shows the logs produced by the Amazon EC2 instance when loading events into Amazon Redshift. Because the Amazon EC2 instance loads events every hour by default, expect to see logs on the hour boundaries. Review these logs for any errors.

						CloudWatch logs for checking auto-export to Amazon Redshift
  4. Look at the CloudWatch metrics in the AWSMobileAnalyticsDataExport namespace. Look specifically at the LoadEventsDuration metric to see any trending errors or gaps in event loading to Amazon Redshift.

						CloudWatch metrics for checking auto-export to Amazon Redshift
  5. If you need assistance after reviewing these logs, you can send snippets or screenshots of these logs to Support for additional debugging help.

If you did not enable CloudWatch metrics and logs when setting up the auto-export, it will be harder to determine what the Amazon EC2 instance might experience when loading events. You will have to rely on the information found in the Amazon Redshift load logs. Connect to your Amazon Redshift cluster and query the stl_load_errors table as follows:

select * from stl_load_errors;

For more information, see System Tables for Troubleshooting Data Loads.