Hi there!
I’m using the BigQuery Export feature. According to the documentation, the historical data export is limited to the past 6 months. Is there any way to extend this period? I have data that is older than 6 months that I’d like to export.
Extending BigQuery Export Historical Data Beyond 6 Months | Mixpanel Community
Hi Anton- Julianne from Mixpanel Support here.
I hate to be the bearer of bad news, but it isn't possible to extend the 6-month limit. This is a built-in restriction to ensure optimal performance and reliability of the service for all users. For data older than 6 months, you can use Mixpanel's Raw Export API to export your data.
If you are bulk exporting event data from the Raw Export API, I recommend using the Mixpanel-utils Python module. The Python module hits the Export API but is better optimized to utilize specific resources on the computer, so it won't time out as quickly.
For large amounts of data, I would recommend exporting the data compressed (gzip)/raw_stream=TRUE, as by default raw_stream=false loads the data into RAM and could result in this error if the amount of data is too large (note, you do need a program to open the gz file).