require redshift stuff