Faraday’s can tap right into your AWS Redshift to share data to your Faraday account.
Doing so, we can utilize your lead, customer, and churn data for predictive outcomes, e.g. "Lead generation, lead conversion, or likelihood to churn, or simply append Faraday data back into your Redshift, or other destinations!
Redshift user creation docs: https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_USER.html
1: Create a “read-only” user for Faraday in your Redshift
2: Whitelist the following IP addresses, so our services can connect
3: All the information we need can be formatted in a
JDBC URL , a url that contains the information we need to login. A
JDBC url looks like this:
4. If you use a
load balancer (also called an
ELB ), we need the load balancer URL AND the full Redshift URL. This comprises around 30% of Redshift integrations.
Example ELB URLs:
Example Full Redshift URLs:
5. Please see https://knowledgebase.faraday.io/en/articles/2887608-what-fields-are-required-when-sending-data-to-faraday for the information we need. If you already know what schema and tables you want to grant us access to, please do so, otherwise, your Customer success manager will schedule a data discovery call with you and a Faraday Customer success engineer to determine what data we will need access to.
6. Create a new Source on https://app.faraday.io/sources, select Redshift as a Source type, and add properties for the JDBC URL and ELB