Faraday’s pre-built integration with Redshift as a source allows you to share your Redshift data with 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 account!

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 for what fields are required.

If you already know what schema and tables you want to grant us access to, please do so. Otherwise, your Project Manager will schedule a Data Discovery call with you to determine what data we will need access to.

Sending credentials securely to Faraday:

Go to the Faraday app’s Sources console, click Create source at the top.

  1. Search for Redshift as a Source location, enter a descriptive name, and click Next.

  2. Enter your Redshift details, and click Next.

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

  3. Under Finalize, click Create source. Faraday can now begin the integration process. Once you finalize this source integration, our Customer Success team will be able to finish the configuration and we can begin utilizing your Redshift data!

Did this answer your question?