I'm using bigquery to store apigee analytics data. We need this data to be relatively up to date, so I've set up exports to run hourly. However, it seems that we must export exactly 24h of data at a time, no more, no less (start date and end date must be one day apart and it exports data between 00:00:00UTC and 00:00:00UTC). As the day reaches the end, this becomes highly inefficient, since I'm getting a whole day's worth of requests but only need the requests that ran on that last hour. Is there another way to set time intervals for the analytics export?
Also, how long after a request is made does it show up on the analytics export? Is it nearly instant or is there a time delay?
LinkedIn
Twitter
