Redshift Warehouse Setup
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:
host
username
password
can be sent securely through onetimesecret.com
database name
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.
Last updated
Was this helpful?