Faraday 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!
1: Create a “read-only” user for Faraday within your Redshift
More on how-to: Redshift user creation docs
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:
anatomy of the Redshift JDBC URL is roughly:
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 review the Knowledgebase article we have here:
If you already know what schema and tables you want to grant us access to, please do so. Otherwise, your Customer Success point-of-contact (AM, PM and/or CSE) will schedule a data discovery call with you to determine what data we will need access to.
6. Create a new Source on https://app.faraday.io/sources, click "Create source" and select Redshift as the Source, then input values for the fields shown.
Incremental column: this is optional, but helps us in determining how we set up the source table in our warehouse.
Redshift Table: this is a text field - if you want to include multiple tables, you may do so by separating their names with a "," (comma).