This article covers some frequently asked questions about exporting data out of Amplitude.
These questions all have the same answer. There is currently no way to export selected raw data for a chart or all data for selected events. Amplitude was built to perform large-scale, complex analyses inside the application. Because of this, isolating and exporting event data in a SQL-like manner is not supported.
However, there are a few alternatives that might help you.
To export all values of an event and its event properties, you can use Amplitude's Export API. This API will export all events across a specified time range and return them in JSON format. Once exported, you can extract the values of the specific events you are looking for.
If your data exceeds the size limitation of the Export API, consider using the self-service Amazon S3 Export option (described below) instead.
With the Query add-on, you can perform SQL-like queries in an Amplitude-maintained Snowflake instance. For customers who have an existing relationship with Snowflake, Amplitude can also share data from an Amplitude-managed Snowflake account to a customer-managed Snowflake account. This add-on is only available for Growth and Enterprise accounts, and would require an additional purchase on top of a paid plan.
You can integrate Amplitude with Amazon S3 to export your event data to an Amazon S3 bucket This integration is available in all accounts, including accounts with free plans. Learn more about Amazon S3 Export.
Thanks for your feedback!
October 9th, 2024
Need help? Contact Support
Visit Amplitude.com
Have a look at the Amplitude Blog
Learn more at Amplitude Academy
© 2024 Amplitude, Inc. All rights reserved. Amplitude is a registered trademark of Amplitude, Inc.