> ## Documentation Index
> Fetch the complete documentation index at: https://docs.inflection.io/llms.txt
> Use this file to discover all available pages before exploring further.
# Redshift Setup and Configuration
> Set up Amazon Redshift as an Inflection data source and export destination.
## Export Inflection Data to Redshift
For information on tables and schemas that Inflection exports to Redshift, please read this
These steps need to be run by someone with access to
1. Go to **Connections → Data Connections**, then click **Add new connection**.
2. **Choose your platform**: Select **Redshift** as your destination platform.
3. **Select connection type**: Choose **Export Data to Redshift**.
4. **Whitelist IPs**
For Redshift connection, you need to whitelist given IPs in your AWS dashboard before proceeding to setup page
5. **Enter your Redshift credentials**
Give a name for your data warehouse connection and fill in your credentials.
* Account name - a human-friendly name for this connection
* Username, password - service account credentials for redshift
* Database, schema and port - name of the database, schema and port to be used by Inflection.
6. Click **Create Connection** to set up the connection. Note that syncing will NOT BEGIN and connection will be in INACTIVE state until the credentials and destination tables are validated by your Inflection team.
We provide a custom SQL script tailored to your configuration. You'll need to run this script to create the export tables in your DW.
The script creates tables with the necessary structure and permissions (INSERT, UPDATE, DELETE) for Inflection to write data.
Once your credentials are saved and your data team has created the required tables in your warehouse, your setup is complete.
At this point:
* Inflection's team will validate the setup and activate the sync for you.
* No additional steps are required from your side.
* Optionally, you may test or delete the connection at this stage
* You will be notified once the sync has started and data is being sent.
Activation may take up to two business days. Please ensure your data team notifies you once your tables are set up in your data warehouse.
## Import Product Activity from Redshift to Inflection
For information on generic import guidelines, please read this
1. In the Inflection UI, select Connections on the left sidebar > "Data Connections" > "Add new Connection". Select Redshift to enter connection details and proceed with the setup workflow.
2. Copy the IPs to whitelist in your AWS dashboard. Select "I've Whitelisted the IPs" once you have completed that step.
3. Name your connection in the Connection name field, add your Redshift connection details, and save the connection:
* Host
* Port
* Database
* User
* Password
We need specific permissions to be granted for Redshift sync to work:
1. Create a user to be used by inflection to read and export data. This user should be created with password (Ref: [https://docs.aws.amazon.com/redshift/latest/dg/r\_CREATE\_USER.html](https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_USER.html))
2. Inflection needs an `inflection` schema to maintain state. Customers can do one of two things for this:
1. Create a schema named `inflection` within the database that is being connected and then grant all privileges to that schema.
```sql theme={null}
GRANT ALL PRIVILEGES ON SCHEMA inflection TO ;
```
2. Grant schema create permission for Inflection to automatically do above
```sql theme={null}
GRANT CREATE ON DATABASE TO ;
```
3. Grant usage access to the schema being connected to the new user
```sql theme={null}
GRANT USAGE ON SCHEMA TO ;
```
4. Grant select privilege on the specific tables being connected or to all the tables in the schema
```sql theme={null}
# Grant select on all tables in schema
GRANT SELECT ON ALL TABLES IN SCHEMA TO ;
# Grant select on specific tables in the schema
GRANT SELECT ON TABLE . TO ;
```
5. Make sure to Whitelist the IPs given from the UI
Connection creation notes:
* Use the hostname and port from `endpoint` details in the redshift cluster details
* Here, the hostname would be `redshift-cluster-1.cmjhsmtjaqgq.ap-south-1.redshift.amazonaws.com` and the port would be `5439`
* Use the username and password for the user that was created for the connection