Skip to content

Latest commit

 

History

History
28 lines (21 loc) · 1.47 KB

redshift-setup.md

File metadata and controls

28 lines (21 loc) · 1.47 KB
title beta
Redshift Reverse ETL Setup
true

Set up Redshift as your Reverse ETL source.

info "" Redshift for Reverse ETL is in beta and Segment’s First-Access and Beta terms govern this feature. If you’d like to learn more, reach out to your CSM, AE, or SE.

To set up Redshift with Reverse ETL:

  1. Log in to Redshift and select the Redshift cluster you want to connect with Reverse ETL.

  2. Follow the networking instructions to configure the correct network and security settings.

  3. Run the SQL commands below to create a user named segment.

    -- create a user named "segment" that Segment will use when connecting to your Redshift cluster.
CREATE USER segment PASSWORD '<enter password here>';

-- allows the "segment" user to create new schemas on the specified database. (this is the name you chose when provisioning your cluster)
GRANT CREATE ON DATABASE "<enter database name here>" TO "segment";

  4. Follow the steps listed in the Add a source section to finish adding Redshift as your source.

Extra Permissions

Give the segment user read permissions for any resources (databases, schemas, tables) the query needs to access.

Give the segment user write permissions for the Segment managed schema (__segment_reverse_etl), which keeps track of changes to the query results.