The following describes the steps and inputs needed to configure a Redshift storage location within your Openbridge account. The process is simple and quick, only requiring minimum information need to be able to connect and write data to your instance.

Step 1: Openbridge Storage Name

This is a label that you provide so you can uniquely identify this database in Openbridge. Some customers may have multiple databases so labeling each will help you identify the system you want us to deliver data into.

Step 2: Setup A Schema

We expect a schema to be present in Redshift called openbridge. This is the schema we will write data into.

Step 3: Whitelist Openbridge IP

If you have a firewall setup, you will need to whitelist our IPs:

Step 4:  Name Of Database

This is the name of the Redshift database you want Openbridge to use. 

Step 5:  Host And Port

Enter the host (or IP) address as well as the port.

Step 6:  User and Password

Supply the user and password that Openbridge should use to authorize connections to your system.

Configuring Redshift

This guide will walk you through different commands you can run to make sure that Redshift is set up correctly with the required schema, users, and permissions.

For example, here is a collection of SQL statements that you can use within your Redshift instance to get it set up for us:

You will want to replace {{username}}, {{mydatabase}}, {{userpassword}} with your correct values
create database {{mydatabase}};
\connect {{mydatabase}}
create user {{username}} with password '{{userpassword}}';
grant create on database {{mydatabase}} to {{username}};
create schema if not exists openbridge authorization {{username}};
grant all on schema openbridge to {{username}};
Did this answer your question?