Linked Events is in private beta
Linked Events is in private beta, and Segment is actively working on this feature. Some functionality may change before it becomes generally available.
At this time, you can only use Redshift with Linked Events.
On this page, you’ll learn how to connect your Redshift data warehouse to Segment.
To get started with Redshift:
- Log in to Redshift and select the Redshift cluster you want to connect.
- Follow these networking instructions to configure network and security settings.
Create a new role and user
Run the SQL commands below to create a role (
segment_entities) and user (
-- create role
CREATE ROLE segment_entities;
-- allow the role to create new schemas on specified database. (This is the name you chose when provisioning your cluster)
GRANT CREATE ON DATABASE "<enter database name here>" TO ROLE segment_entities;
-- create a user named "segment_entities_user" that Segment will use when connecting to your Redshift cluster.
CREATE USER segment_entities_user PASSWORD '<enter password here>';
-- grant role permissions to the user
GRANT ROLE segment_entities TO segment_entities_user;
Grant access to schemas and tables
You’ll need to grant access to schemas and tables that you’d like to enrich with. This allows Segment to list schemas, tables, and columns, as well as create entities with data extracted and ingested to Segment.
-- view specific schemas in database
GRANT USAGE ON SCHEMA <schema-name> TO ROLE segment_entities;
Grant table permissions based on customer need. Learn more about Amazon’s table permissions.
-- query data from a specific table in a schema
GRANT SELECT ON TABLE <schema-name>.<table-name> TO ROLE segment_entities;
RETL table permissions
If you used RETL in your database, you’ll need to add the following table permissions:
GRANT USAGE, CREATE ON SCHEMA __segment_reverse_etl TO ROLE segment_entities;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA __segment_reverse_etl TO ROLE segment_entities;
This page was last modified: 31 Jan 2024
Questions? Problems? Need more info? Contact Segment Support for assistance!