Growth/Enterprise customers who purchased Redshift ETL can query their raw data via their dedicated Amazon Redshift cluster.
NOTE: Amplitude no longer offers hosted Redshift. Instead, you can purchase the Query add-on. It includes an Amplitude-managed Snowflake data warehouse. Redshift ETL is still available as an add-on.
With Redshift ETL, Amplitude will extract, transform, and load (ETL) data from Amazon S3 to your Redshift cluster. This requires Amplitude to have write-access and any Amplitude IP addresses to be whitelisted in Redshift. Please reach out to your CSM for the IP addresses.
Most of the data is loaded at a delay of 3 hours; however, sometimes lags caused by temporary unavailability or general overloading of your cluster can occur. Amplitude will not maintain the health of your cluster. If you would like to pause the ETL process for maintenance, please contact Amplitude support.
For legacy clients who purchased an Amplitude hosted Redshift cluster, you can query raw data via the SQL tab within the Amplitude Dashboard. Alternatively, you can connect directly to your Redshift cluster via a terminal or third-party application like SQL Workbench.