> ## Documentation Index > Fetch the complete documentation index at: https://docs.castled.io/llms.txt > Use this file to discover all available pages before exploring further. # Amazon RedShift > Redshift is a fully managed data warehouse in the cloud which is part of the cloud-computing platform Amazon Web Service (AWS) Castled enables you to leverage the customer 360 data in your Redshift to engage your customers across different channels like Email, SMS, Push and In-app notifications. ### Permission Details **Create a dedicated user CASTLED for connecting to your Redshift warehouse.For making sure the connection is established successfully the CASTLED user created should have the below permissions:** 1. Required grants to create a new schema CASTLED with all required privileges to create/update/delete tables with in that schema. 2. **READ ONLY** access to the existing as well as future tables and views in the schemas from which you want Castled to sync the data to your destination app. 3. Permission to execute the existing as well as future functions in the schema from which you want Castled to sync the data to your destination app. You can use the below script to configure the required access required by Castled. ``` -----------------------------------USER CREATON STARTS------------------------------------------------------- — Create a new user CASTLED for connecting to redshift DB CREATE USER CASTLED WITH PASSWORD ''; -----------------------------------USER CREATON ENDS---------------------------------------------------------- -----------------------------------BOOK KEEPING SCHEMA ACCESS STARTS------------------------------------------ -- Create a private bookkeeping schema for storing sync data CREATE SCHEMA CASTLED; -- Give the CASTLED user full access to the bookkeeping schema GRANT ALL ON SCHEMA CASTLED TO CASTLED; -- Give CASTLED user access to all objects existing n the bookkeeping schema GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA CASTLED TO CASTLED; -----------------------------------BOOK KEEPING SCHEMA ACCESS ENDS--------------------------------------------- ``` Replace the \< your schema> with your applicable schema for the below scripts before executing them ``` -----------------------------------GRANT TABLE READ ONLY ACCESS STARTS------------------------------------------ -- Give access to CASTLED user to SEE your schema GRANT USAGE ON SCHEMA "" TO CASTLED; -- Give READ ONLY access to CASTLED user to read from all existing tables in your schema GRANT SELECT ON ALL TABLES IN SCHEMA "" TO CASTLED; -- Give READ ONLY access to CASTLED user to read from all the future tables being created in your schema ALTER DEFAULT PRIVILEGES IN SCHEMA "" GRANT SELECT ON TABLES TO CASTLED; -- Give access to the CASTLED user to execute any existing functions in you schema GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA "" TO CASTLED; -- Give access to the CASTLED user to execute any new functions added to this schema ALTER DEFAULT PRIVILEGES IN SCHEMA "" GRANT EXECUTE ON FUNCTIONS TO CASTLED; -----------------------------------GRANT TABLE READ ONLY ACCESS ENDS--------------------------------------------- ``` ### Connector Details **For configuring a new connector for Redshift the following fields needs to be captured**: * **Name**: A name to uniquely qualify the warehouse source created * **Database Server Host**: Host's IP address or DNS Name. * **Database Server Port**: The port on which your Amazon Redshift server is listening for connections. Default value: 5439. * **Database name**: Name of database you created for your cluster * **Database User**: Database username * **Database Password**: Database password * **Enable SSH Tunnel**: Enable this option to connect Redshift database host to Castled Data using a SSH Tunnel.This is done to provide an additional level of security and avoid exposing the Redshift setup to the public. * On enabling this option, you will have to enter the below details.Please refer Connecting through SSH Tunnel for more details * SSH Host * SSH Port * SSH User ![](https://mintlify.s3-us-west-1.amazonaws.com/castled/images/amazon-redshift.png) > [!NOTE] > > If the sync involves more than one schema in your database GRANT mentioned > above needs to be given for each of those schemas. If the views in your schema > references tables of another schema in your database, GRANT needs to be given > for those schemas as well. ### Whitelisting Castled IP Address Castled connects to Redshift using the ip address **34.205.244.96**. Please make sure this ip is allowed inbound traffic to the Redshift port. ### Connecting to SSH Tunnel Castled uses SSH Tunelling to connect to Redshift clusters accessible only on private or internal networks. In order to make sure the connection is established successfully with SSH Tunneling, you need to provide an SSH Host visible on the public internet which can also connect to the private Redshift warehouse. The basic admin actions mentioned below are required for the same While configuring a new warehouse connector for Redshift on the 'Create Connector', you need to enter the following details 1. SSH Host IP/DNS Name 2. SSH Port : Default is 22 unless changed 3. SSH Username : User created for Castled on the SSH Host Docusaurus Refer Connecting through SSH Tunnel for details on how to add the castled public key to authorized\_keys. ![](https://mintlify.s3-us-west-1.amazonaws.com/castled/images/redshift.png) Refer [Connecting through SSH Tunnel](https://docs.castled.io/appendix/connecting.md) for details on how to add the castled public key to authorized\_keys. This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.