Amazon Redshift Data Source Connections

Here is a programmatic example of an Amazon Redshift connection.

CREATE DATACONNECTION redshift_connection CXNPROPERTIES
(
  'connection_type'='JDBC',
  'jdbc_driver'='redshift',
  'host'='<instance>.<region>.redshift.amazonaws.com',
  'port'='<port, typically 5439>',
  'user_key'='awssm://my-username',
  'password_key'='awssm://my-password',
  'jdbc.db.name'='<Database to connect to>',
  'jdbc.schema.name'='<Schema to connect to>'
);

Enable Query Pushdown

To enable transparent query pushdown, add redshift to the list of enabled engines in the OKERA_CTE_REWRITE_ENABLED_ENGINES configuration setting. Multiple engines can be enabled (in addition to the ones enabled by default) by providing them as comma-separated values in this configuration setting.

For example:

OKERA_CTE_REWRITE_ENABLED_ENGINES: dremio:direct,redshift,postgresql