Sending Mixpanel Data Directly to On-Premises Solutions

·

Hi team, Currently , we are getting the mixpanel data into our snowflake using a data pipeline (mixpanel_pipeline) . We have a use case now , can we send the mixpanel data to an on-prem directly ???? If that is possible , please let me know . Thanks

2 comments

Santi (.
·
·
Hi Md, yes it's definitely possible using our RAW Export API. You can get full documentation details here: https://developer.mixpanel.com/reference/raw-event-export To help with this process you can use the Python utils module that has some functions to help interact with the API including a CSV export and built-in parameters to handle large exports: https://github.com/mixpanel/mixpanel-utils?tab=readme-ov-file#export-events The data pipelines package only exports to cloud warehouses so another alternative would be to periodically export data into a storage location like AWS S3, Google Cloud Storage, or Azure Blob Storage. From there, you can fetch the data and load it into your on-premises system. Using this approach adds an intermediate step compared to the previous approach where the data flows directly to your system via raw api but the benefit is that Data Pipelines does not have API rate limits and takes care of deduplication, sync, and scheduling
❤️1
Md S.
·
·
Thanks Santi (., this helps.
🙏1