Apply query to Redshift table before importing?

Hello, I am very excited about the new Redshift connector. However, we use Redshift to store big data that needs to have a query applied to it before bringing it in for analysis and visualization...