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!

Granting access

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:

redshift://[$user_name]:[$password]@[$cluster_name]-[$redshift_cluster_name]-[$endpoint].[$aws_region].redshift.amazonaws.com:[$port]/[$customer_database]

like so:

redshift://faraday1:FakePassword@cluster-redshiftcluster-h2e1y2e978had.cxmkjxwwbofc.us-east-1.redshift.amazonaws.com:5439/customer_database

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:

clientname-data-public-elb-xxxxx.us-east-1.elb.amazonaws.com

redshift.clientname.co

Example Full Redshift URLs:

cluster-redshiftcluster-h2e1y2e978had.cxmkjxwwbofc.us-east-1.redshift.amazonaws.com

cb-us-east-1-prod-financewarehouse.sam232yad2ha6.us-east-1.redshift.amazonaws.com

5. Please review the Knowledgebase article we have here:

https://knowledgebase.faraday.io/en/articles/2887608-what-fields-are-required-when-sending-data-to-faraday

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.

Note that:

  • 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).

Did this answer your question?