Redshift Connection on Heroku using Django
<p>I am trying to to deploy a Python/Django app on Heroku that needs to execute read-only queries on a Redshift cluster. The primary problem is that <strong>the app has a dynamic IP address, but Redshift needs specific IP addresses to be whitelisted</strong>. </p>

<p>I would prefer to be able to query the cluster programmatically using the psycopg2 engine or the AWS SDK (Boto). One possibility would be to use a Heroku add-on such as Proximo or QuotaGuard Static to obtain a static IP address, but:</p>

<ol>
<li>I <em>don't</em> want to route ALL traffic through these add-ons - only the Redshift queries</li>
<li>I don't know how to 'wrap' the database queries through these services</li>
</ol>

<p>Has anyone else dealt with this problem before? Thanks in advance for any help!</p>

<p>I can connect to Redshift locally, but how do I do so once the app is deployed onto Heroku? I've tried using the Boto3 SDK and a static ip Heroku add-on like QuotaGuard Static or Proximo. </p>