Drivetrain Knowledge Hub
  • Getting started
    • Start here
      • Navigating Drivetrain
      • Key terms & concepts
    • Reports
      • Interacting with reports
      • Creating a report
      • Collaborating on a report
    • Data
      • Connecting data sources
      • Explore your datasets
      • Transforming and enriching data
    • Metrics
      • Metric Builder overview
      • Creating a metric from a dataset
      • Creating a metric using formula
      • Adding dimensions
    • Models
  • Modeling
    • Models page overview
    • Creating a model
    • Formatting a variable
    • Adding plan/forecast numbers to a variable
    • Lists overview
    • Adding dimensions to a model
    • Saving and managing versions
    • Creating and comparing scenarios
    • Setting up reconciliation workflows
    • Collaborating on models (commenting)
    • More model elements
    • Practical example
  • Formulas
    • Formulas in Drivetrain
      • Referencing metrics in formulas
      • Operators
      • Functions
        • ABS
        • AND
        • AVERAGE
        • BLANK
        • BOMONTH
        • CEIL
        • COLLAPSE
        • CONCAT
        • DATE
        • DATEADD
        • DATEDIFF
        • DATEVALUE
        • DAY
        • DAYSINMONTH
        • EOMONTH
        • EQUALS (or EQ)
        • EVEN
        • FINANCIALYEARSTARTMONTH
        • FLOOR
        • FORECAST
        • IF
        • ISBLANK
        • LAST ACTUALS DATE
        • LOOKUP
        • LOWER
        • MAX
        • MID
        • MIN
        • MOD
        • MONTH
        • NETWORKDAYS
        • NOT
        • ODD
        • OR
        • PERIOD
        • PRORATA
        • QUARTERTODATE
        • ROUND
        • ROUNDDOWN
        • ROUNDUP
        • SLN
        • SUM
        • SUMMARIZE
        • THIS MONTH
        • TODAY
        • VALUE
        • UPPER
        • YEAR
        • YEARTODATE
  • User Administration and Access
    • Access control & permissions
      • Creating a user
      • Creating and managing roles
      • Understanding permissions in roles
      • Reviewing user permissions
    • Data masking
  • Data Governance
    • How Drivetrain ensures data quality
  • Integration guide
    • Integrate with Drivetrain
  • 📡Extending Drivetrain
    • Drivetrain API
      • Get metric list API
      • Get metric data API
    • Export to data warehouses
      • Export to BigQuery
    • Google Sheets add-on
    • Integration for Slack
Powered by GitBook
On this page
  • Prerequisites
  • Setup Instructions
  • Step 1: Choose connection method
  • Step 2: Complete Drivetrain configuration
  • Appendix: Firewall Settings/IP Whitelisting

Was this helpful?

  1. Integration guide
  2. Integrate with Drivetrain
  3. Databases and Warehouses

Integrating with Redshift

Last updated 11 months ago

Was this helpful?

Prerequisites

To connect Redshift to Drivetrain, you need the following:

  • Access to the AWS console

  • A Redshift cluster

  • SELECT access granted for the following tables:

    • PG_CLASS

    • PG_NAMESPACE

    • PG_DATABASE

    • STV_TBL_PERM

Setup Instructions

Step 1: Choose connection method

Connect directly

Connect using private networking

Step 2: Complete Drivetrain configuration

In Drivetrain, go to Data > New Data Source > Redshift > Connect and:

  1. Enter the Redshift cluster Host name.

  2. In the Port field, enter the port number for the corresponding host name.

  3. Enter the corresponding Database name.

  4. Enter the User name for the Redshift cluster.

  5. Enter the Password.

  6. Choose a Connection method: DIRECTLY or PRIVATE NETWORKING.

  7. Click Save and Test. Your Redshift connector is now connected!

Appendix: Firewall Settings/IP Whitelisting

Drivetrain uses Fivetran for the Redshift connection. Please configure your firewall and/or other access control systems to allow incoming connections to your host and port from these IPs for your region:

Geography
Region
IP Address (CIDR)
IP Addresses (Range)

US

us-east-1 (N. Virginia)

Default region

3.239.194.48/29

3.239.194.48 - 3.239.194.55

US

us-east-2 (Ohio)

3.145.219.16/29

3.145.219.16 - 3.145.219.23

US

us-west-2 (Oregon)

35.80.36.104/29

35.80.36.104 - 35.80.36.111

US

us-gov-west-1 (GovCloud US West)

3.30.186.152/29

3.30.186.152 - 3.30.186.159

Canada

ca-central-1 (Montréal)

Default region

3.99.193.224/29

3.99.193.224 - 3.99.193.231

EU

eu-west-1 (Dublin)

3.251.214.192/29

3.251.214.192 - 3.251.214.199

EU

eu-central-1 (Frankfurt)

Default region

3.67.81.32/29

3.67.81.32 - 3.67.81.39

Australia

ap-southeast-2 (Sydney)

Default region

3.26.88.224/29

3.26.88.224 - 3.26.88.231

UK

eu-west-2 (London)

Default region

18.168.224.40/29

18.168.224.40 - 18.168.224.47

India

ap-south-1 (Mumbai)

Default region

3.111.138.160/29

3.111.138.160 - 3.111.138.167

Singapore

ap-southeast-1 (Singapore)

Default region

18.143.203.104/29

18.143.203.104 - 18.143.203.111

Japan

ap-northeast-1 (Tokyo)

Default region

43.207.101.168/29

43.207.101.168 - 43.207.101.175

That’s it! Inform your Drivetrain customer success manager so that they can get started!

If you connect directly, create a rule in a security group that allows access to your Redshift instance and port from the IPs listed in the .

AWS PrivateLink allows VPCs and AWS-hosted or on-premises services to communicate with one another without exposing traffic to the public internet. PrivateLink is the most secure connection method. Learn more in .

Configure your firewall and/or other access control systems to allow incoming connections to your host and port from IPs for your region ().

AWS’ PrivateLink documentation
Prequisites
Setup Instructions
Step 1: Choose connection method
Step 2: Complete Drivetrain configuration
Appendix: Firewall Settings/IP Whitelisting
table below
IPs listed below
Page cover image