Redshift
Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. The Data Connect integration with Redshift allows you to automatically sync your Contentsquare data to Redshift for advanced analysis and joining with other business data.
Prerequisites
Section titled PrerequisitesBefore setting up the Redshift integration, ensure you have:
- An Amazon Redshift cluster that is provisioned and accessible
- Sufficient permissions to create schemas and tables in Redshift
- Database credentials with appropriate permissions
Redshift Setup
Section titled Redshift Setup-
Ensure your Redshift cluster is running and accessible
-
Create a dedicated schema for Contentsquare data (recommended):
CREATE SCHEMA heap_data; -
Create a dedicated user for Data Connect (optional but recommended):
CREATE USER heap_connect_user WITH PASSWORD 'your-secure-password';GRANT USAGE ON SCHEMA heap_data TO heap_connect_user;GRANT CREATE ON SCHEMA heap_data TO heap_connect_user;GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA heap_data TO heap_connect_user;ALTER DEFAULT PRIVILEGES IN SCHEMA heap_data GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO heap_connect_user; -
Ensure your Redshift cluster is accessible from Contentsquare’s servers:
- If your cluster is public, ensure the security group allows access
- If your cluster is private, you may need to set up VPC peering or a VPN connection
Configure Data Connect
Section titled Configure Data Connect- Log in to Contentsquare.
- Navigate to Analysis setup > Data Connect.
- Select Connect next to Redshift.
- Enter the required information:
- Host (endpoint)
- Port (typically 5439)
- Database name
- Username
- Password
- Schema (the schema you created for Contentsquare data)
- Select Connect.