Who gets this? Data Warehouse Push is currently only available in beta for Postscript brands on the enterprise plan. To begin using Data Warehouse Push, please be sure to first contact your Customer Success Manager.
Data Warehouse Push allows Postscript to automatically send both historical and new data stored in-app, including clicks, order attribution, and more, to your designated data warehouse.
In this article, we'll walk you through the three steps for configuring your Redshift destination.
IMPORTANT! Once complete, share the credentials with Postscript and we'll handle the rest.
Prerequisites
An active AWS account with access to Amazon Redshift
A Redshift cluster (provisioned or serverless). If you don't have one, create a cluster here.
Once created, authorize external access to the cluster.
Step 1: Create a Database User and Schema
Connect to your Redshift cluster using a SQL client (e.g. DBeaver, SQL Workbench/J) with your admin credentials, then run the following commands.
Replace <postscript_user>, <myPwd>, and <schema_name> with your preferred values.
-- Create a user for Postscript CREATE USER <postscript_user> WITH PASSWORD '<myPwd>' CREATEUSER; -- Create a schema for Postscript to write to CREATE SCHEMA IF NOT EXISTS <schema_name> AUTHORIZATION <postscript_user>; -- Grant the necessary permissions GRANT SELECT ON ALL TABLES IN SCHEMA <schema_name> TO <postscript_user>; GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA <schema_name> TO <postscript_user>; GRANT USAGE ON SCHEMA <schema_name> TO <postscript_user>;
If you want Postscript to write to multiple schemas, repeat the GRANT commands for each additional schema.
Step 2: Allow Postscript IPs Through Your Security Group
In the AWS Console, navigate to your Redshift cluster → Properties → VPC security group. In the security group's Inbound rules, add a rule of type Redshift and set the source to the Postscript IP addresses (provided separately by the Postscript team).
Step 3: Gather Your Connection Details
Share the following with Postscript:
Field | Description |
Host | The cluster endpoint, found on the cluster's General Information page. If using Redshift Serverless, use the Workgroup Endpoint. |
Port | Default is |
Database | The database name you configured during cluster creation. |
Schema | The schema name you created in Step 1 (e.g. |
Username | The user you created in Step 1 (e.g. |
Password | The password set for that user in Step 1. |
Get Support
Have questions? Please feel free to reach out to our Support team at [email protected] or via live chat.
Need ongoing channel strategy guidance? Please fill out this form and we'll connect you to one of our certified partners.