Setup

In order to set up your BallotReady / Redshift integration, you will need to first allow-list an IP address. In the initial sync table(s) will be created in the specified schema. 

If you are a Civis user, contact support@civisanalytics.com with your static IP. Support at Civis will need to take the following steps to enable your setup of a BallotReady sync:

1. Allow-list the IP address provided to you by BallotReady in your Redshift cluster. 

2. Create a Redshift user with permissions to read, write, and create tables in the destination schema.

   1. For tighter security, you can use a specific schema for this data and only give permissions to that schema. If you do, make sure to send the schema name along with permissions.

3. Use a onetimesecret to securely share the username, password, and cluster connection string (JDBC URL) with BallotReady.

   1. By default the data will be written to the public schema. If you would like the table to be created somewhere else, provide the destination schema to BallotReady.

Usage

How often will the data sync?

The data will sync to Redshift hourly.

What should I expect to see in Redshift?

This sync will create two tables, one of user data and one with user actions. Depending on the BallotReady integrations you set up, this sync may include a third table with related IDs.

The events captured from BallotReady depend on the customized flow you have set up. Events will be added as BallotReady releases new features. Check here to see the most up to date list of events included as a part of this integration.

The three tables you will see in Redshift are outlined below:

Person data

Field	Description	Sample value
person_id	Maps to person_id in the event table	773985ac-a492-4a4e-8147-9a92a89adf6f
ballot_id	Unique ID assigned by BallotReady	6870051
first_name	First name	Anna
last_name	Last name	Smith
address_line1	address	411 N 114th St
address_line2	address	Omaha, NE 68154
city	city	Omaha
state	state	NE
zip	zipcode	68154
phone	phone number	14105678989
email	email	anna@gmail.com

Events data

External IDs