The Redshift/PG targets time out queries after 8 hours. If possible, add to Snowflake and BQ. Also would be nice to make it a configuration option in targets config.