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>'
);