Growth/Enterprise customers who purchased Redshift ETL can query their raw data via their dedicated Amazon Redshift cluster.
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.