Redshift Export

Last updated:

Using the Redshift Export app requires either PostHog Cloud, or a self-hosted PostHog instance running version 1.30.0 or later.

Not running 1.30.0? Find out how to update your self-hosted PostHog deployment!

You'll also need access to a Redshift Cluster to export to.

Installation

  1. Create a Redshift Cluster
  2. Make sure PostHog can access your cluster

This might require a few things:

  1. Create a user with table creation privileges

We need to create a new table to store events and execute INSERT queries. You can and should block us from doing anything else on any other tables. Giving us table creation permissions should be enough to ensure this:

SQL
CREATE USER posthog WITH PASSWORD '123456yZ';
GRANT CREATE ON DATABASE your_database TO posthog;
  1. Add the connection details at the configuration step in PostHog

Configuration

OptionDescription
Redshift host
Type: string
Required: True
Example: redshift-cluster-name.xxxxxxxxxxx.us-east-1.redshift.amazonaws.com
Cluster port
Type: string
Required: True
Default: 5439
Database name
Type: string
Required: True
Table name
Type: string
Required: False
The plugin will create a table with this name to store the events in
Username available to the plugin for accessing your database instance
Type: string
Required: True
This user needs table creation access
Password for the username specified above
Type: string
Required: True
Make sure it's a strong one!
Upload at least every X seconds
Type: string
Required: True
If there are events to upload and this many seconds has passed since the last upload, send the events to Redshift. The value must be between 1 and 600.
Maximum upload size in megabytes
Type: string
Required: True
Always keep the uploaded files below this size limit, uploading more frequently than the time limit if needed. Events are kept in memory until then, so make sure your server has enough of it. The value must be between 1 and 10 MB.
Events to ignore
Type: string
Required: False
Comma separated list of events to ignore
Data type to store properties
Type: choice
Required: False
ADVANCED

FAQ

Is the source code for this app available?

PostHog is open-source and so are all apps on the platform. The source code for the Redshift Export app is available on GitHub.

Who created this app?

We'd like to thank PostHog team members Yakko Majuri and Marius Andra, as well as community member Jean Roman for creating the Redshift Export app.

Who maintains this app?

This app is maintained by PostHog. If you have issues with the app not functioning as intended, please let us know!

What if I have feedback on this app?

We love feature requests and feedback! Please tell us what you think! to tell us what you think.

Or, if you see the feedback widget enabled, use that!

What if my question isn't answered above?

We love answering questions. Ask us anything via our community forum, or drop us a message.

Questions?

Was this page useful?

Next article

RudderStack Export

The Rudderstack Export app enables you to send events from PostHog, to RudderStack. RudderStack will recognize PostHog as a data source, so you can use RudderStack's data pipeline features to send PostHog event data to other platforms. Requirements The Rudderstack Export app requires either PostHog Cloud, or a self-hosted PostHog instance running version 1.30.0 or later. Not running 1.30.0? Find out how to update your self-hosted PostHog deployment ! You'll also need access to the Rudderstack…

Read next article