Connect with Amazon Redshift and define your metrics and dimensions in Push.ai.
To connect Redshift to Push.ai, you need the following:
Log in to your Redshift data warehouse at http://console.aws.amazon.com/redshiftv2/home
Create a user with read permissions to the schema and tables that you want to connect from.
If data will be written back to the warehouse from Push.ai, add a schema and permissions to allow the Push.ai user to write to a specific schema.
Push.ai connects to your warehouse from the following IP addresses. Be sure to allow traffic from these IPs in your firewall, and include them in any database grants.
Region/Deployment | IP Addresses |
---|---|
All | 44.226.145.213 , 54.187.200.255 , 34.213.214.55 , 35.164.95.156 , 44.230.95.183 , 44.229.200.200 |
Add the Host, Port, Database, Username, Password
(Optional) Configure the schema name to write to. By default, data will be written to PUSH_AI
.
Test and create the datasource connection.
Connect with Amazon Redshift and define your metrics and dimensions in Push.ai.
To connect Redshift to Push.ai, you need the following:
Log in to your Redshift data warehouse at http://console.aws.amazon.com/redshiftv2/home
Create a user with read permissions to the schema and tables that you want to connect from.
If data will be written back to the warehouse from Push.ai, add a schema and permissions to allow the Push.ai user to write to a specific schema.
Push.ai connects to your warehouse from the following IP addresses. Be sure to allow traffic from these IPs in your firewall, and include them in any database grants.
Region/Deployment | IP Addresses |
---|---|
All | 44.226.145.213 , 54.187.200.255 , 34.213.214.55 , 35.164.95.156 , 44.230.95.183 , 44.229.200.200 |
Add the Host, Port, Database, Username, Password
(Optional) Configure the schema name to write to. By default, data will be written to PUSH_AI
.
Test and create the datasource connection.