Redshift Warehouse Setup

Warehouses are only available for users on the Freshpaint business plan.

To get started with warehouse setup, please create a new user for Freshpaint that has create permission for your DB. This can be done with the following script:

CREATE USER freshpaint PASSWORD <password>;
GRANT CREATE ON DATABASE <database> TO freshpaint;

2. Once this user has been created, please reach out to support@freshpaint.io with the following information about your DB:

3. Additionally, please make sure your DB is publicly addressable, and then whitelist the following IPs:

  • 44.229.168.72/32

  • 35.227.135.0/29

  • 35.234.176.144/29

  • 52.0.2.4/32

Once this is completed, we'll need to finish the setup on our end. Notify support@freshpaint.io and we'll take it from here.

We can also connect through an SSH proxy upon request.

Last updated