Amazon Redshift

Amazon Redshift and pREST

Analyze all of your data with the fastest and most widely used cloud data warehouse.

Amazon Redshift is based on PostgreSQL. Amazon Redshift and PostgreSQL have a number of very important differences that you must be aware of as you design and develop your data warehouse applications. read more

Amazon Redshift is compatible with postgresql just use the ODBC connection in the environment variable DATABASE_URL with the parameter OpenSourceSubProtocolOverride to make pREST connect to the database.

DATABASE_URL=postgresql://localhost:5432/postgres?OpenSourceSubProtocolOverride=true